PHPize Online / SQLize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
-- Hint: use Ctrl+Enter for SQL autocomplete CREATE TABLE `list` ( id varchar(32), count int ); INSERT INTO `list` VALUES ("1-2", 1), ("1-3", 12);
Copy Clear
Copy Format Clear
<?php $data = [ 'cart' => '[ {"id": "1-2", "name": "AN", "price": "490", "count": 2}, {"id": "1-3", "name": "AV", "price": "350", "count": 1}, {"id": "11-1", "name": "SF", "price": "450", "count": 1} ]' ]; function getList($conn) { $result = $conn->query("SELECT * FROM `list`;"); $data = []; if($result && $result->num_rows>0){ $data = $result->fetch_all(MYSQLI_ASSOC); } return $data; } function addList($data, $conn) { $cart = json_decode($data['cart'], true); $stmt = $conn->prepare("UPDATE `list` SET `count` = GREATEST(`count` - ?, 0) WHERE `id`= ? ;"); /* bind parameters for list */ $stmt->bind_param("ds", $count, $id); foreach($cart as $value ) { $id = $value['id']; $count = $value['count']; /* execute query */ $stmt->execute(); } } $list = getList($mysqli); print_r($list); addList($data, $mysqli); $list = getList($mysqli); print_r($list);
Show:  
Copy Clear