- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
// table for cart must have unique index for both columns for correct effect of this function
function save() {
if ($this->errno_ || !$this->db_link_)
return;
// optimized loop
$n = count($this->products_) - 1;
$s_query = "REPLACE INTO `". Config::DB_CART_TABLE_NAME ."` VALUES ";
for($i = 0; $i < $n; ++$i) {
$s_query .= "('". $this->phpsessid_ ."',". $this->products_[$i]->getId() .",". $this->counts_[$i] .",'". $this->sizes_[$i] ."')";
}
if ($n + 1)
$s_query .= "('". $this->phpsessid_ ."',". $this->products_[$n]->getId() .",". $this->counts_[$n] .",'". $this->sizes_[$n] ."')";
print($s_query);
$res = mysqli_query($this->db_link_, $s_query);
if (!$res)
$this->errno_ = IModel::E_DB_QUERY;
}
// Запрос сформирован некорректно, нету запятых между кортежами значений:/
// REPLACE INTO `cart` VALUES ('cbn1c7ljjd3gglb2lmpa96grnq3prq2iefb2elvcb4fhr9r0qls1',700,4,'')('cbn1c7ljjd3gglb2lmpa96grnq3prq2iefb2elvcb4fhr9r0qls1',701,2,'')
Опять мой говнокод.
И это как-то србатывало О_о
Комментарии (4) RSS