ecshop产品列表页按订单表销量排序

来源:互联网 发布:算法导论第三版 15.4-4 编辑:程序博客网 时间:2024/09/21 09:25
打开flow.php大概1654下加入
//更新销量到goods表      $goods_number_count=$_POST['goods_id'];//接收goods_id值  foreach($goods_number_count as $It) {   $sql_num = 'SELECT sum(goods_number) as number FROM ' . $GLOBALS['ecs']->table('order_goods') . " WHERE goods_id = ".$It."";   $goods_number_count = $GLOBALS['db']->getOne($sql_num)?$GLOBALS['db']->getOne($sql_num):0;//求出总合赋给$goods_number_count;   //修改goods表   $sql = "UPDATE ". $GLOBALS['ecs']->table('goods') ." set goods_number_count=".$goods_number_count." WHERE goods_id=".$It."";       $db->query($sql);     }

打开flow.dwt在提交订单表格里加个产品goods_id值

0 0
原创粉丝点击