<?php /** * Created by PhpStorm. * User: Yu * Date: 2015/4/8 * Time: 14:42 */ require_once 'store.php'; $conn = dbConnect(); echo "User(id = 1) Storage left:" . get_user_storage_left($conn, 1); echo "</br>User(id = 1) Goods(id = 1) Count:" . get_user_goods_count($conn, 1, 1); echo "</br>User(id = 1) Goods(id = 2) Count:" . get_user_goods_count($conn, 1, 2);
if ($count == $n * -1) { $sql = "DELETE FROM `storage` WHERE user_id = {$uid} AND goods_id = {$gid}"; // echo $sql."</br>"; mysqli_query($conn, $sql); } else { $goods_left = $count + $n; $sql = "UPDATE `storage` SET goods_num={$goods_left} WHERE user_id = {$uid} AND goods_id = {$gid}"; // echo $sql."</br>"; mysqli_query($conn, $sql); } } else { //no enough goods to sell } } else { //buying $store_left = get_user_storage_left($conn, $uid); if ($n > $store_left) { //no enough room for this deal } else { //change 2 tables : 1.storage 2.user // $goods_num = $n + // $sql = "UPDATE `storage` SET goods_num=$goods_left WHERE user_id = $uid AND goods_id = $gid"; // echo $sql."</br>"; // mysqli_query($conn, $sql); } } } else { //BAD VALUE } } else { //BAD VALUE