<?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
