适用范围:thinkphp3.2和thinkphp5.0
php代码:
public function myorder_list(Request $request){
$uid = $this->uid;
$where = array(
'uid' => $uid,
);
$page = $this->request->param('page') ? $this->request->param('page') : 1; //获取请求的页数
$num = 10;//请求条数
$order_list = db('shop_order')
->alias('so')
->join(config('database.prefix').'shop_order_goods sog','so.id = sog.orderid')
->field('so.ordersn,so.pay_price,sog.id,sog.orderid,sog.goodsid,sog.goods_name,sog.goods_price,sog.thumb,sog.total')
->where($where)
->order("so.createtime", 'desc')
->page($page,$num)
->select();
foreach ($order_list as $k=>$v){
$order_list[$k]['total'] = db('member_video')->where('orderid',$v['id'])->count();
}
//判断是否为ajax请求,获取更多数据
<