break;
case 'add':
//var_dump($_POST);
//获取数据条数；
$num = count($_POST) / 6;
//遍历拼接，组合sql
for ($i = 0; $i < $num; $i++) {
//拼接变量名
$orderid = 'orderid' . $i;
$goodsid = 'goodsid' . $i;
$name = 'name' . $i;
$price = 'price' . $i;
$score = 'score' . $i;
$content = 'content' . $i;
$addtime = time();
$str .= "(null,'{$_SESSION['user']['id']}','{$_POST[$orderid]}','{$_POST[$goodsid]}','{$_POST[$name]}','{$_POST[$price]}','{$_POST[$content]}','{$_POST[$score]}','{$addtime}'),";
}
//清除右边的逗号
$str = rtrim($str, ',');
//sql插入多条数据
$sql = "insert into " . PREFIX . "comment values" . $str;
//echo $sql; die;
$result = myQueryInsert($sql);
//var_dump($result);
if ($result) {
echo location_js('评论成功', './showcomment.php');
} else {
echo '失败';
}
break;
}
$status = 0;
//组合sql,提交订单,插入订单表
$sql = "insert into " . PREFIX . "orders values(null,'{$id}','{$linkman}','{$address}','{$code}','{$phone}','{$addtime}','{$total}','{$status}','{$userOrder}')";
//echo $sql;die;
$result = myQueryInsert($sql);
//插入成功，返回INSERT产生的ID
//遍历购物车，组合sql
foreach ($_SESSION['shoplist'] as $key => $value) {
$str .= "(null,'{$result}','{$value['id']}','{$value['goods']}','{$value['price']}','{$value['num']}','{$userOrder}','{$value['picname']}','{$value['network']}','{$value['color']}'),";
}
//echo $str;die();
$str = rtrim($str, ',');
//组合sql，插入订单详情表订单有多少个表?插入多条数据
$sqla = "insert into " . PREFIX . "detail values" . $str;
//echo $sqla;die;
$resaa = myQueryInsert($sqla);
if ($resaa > 0) {
//已经成功获取到了用户的订单
//销毁SESSION订单信息
unset($_SESSION['shoplist']);
header('location:./confirm2.php');
}
break;
case 'update':
$k = $_GET['key'];
if ($_GET['type'] == 'jia') {
$_SESSION['shoplist'][$k]['num']++;
header('location:./shop.php');
}
if ($_GET['type'] == 'jian') {
if ($_SESSION['shoplist'][$k]['num'] > 1) {
