[code]
$user = M('product');
$data = $user->join('LEFT JOIN cc_type ON cc_product.id = cc_type.p_id' )->where('cc_type.type='.$type)->field('cc_product.id,cc_product.title,cc_product.material,cc_product.img_src,cc_product.price')->select();
$count=count($data);
$Page = new \Think\Page($count,12);
$Page -> setConfig('header','共%TOTAL_ROW%条');
$Page -> setConfig('first','首页');
$Page -> setConfig('last','共%TOTAL_PAGE%页');
$Page -> setConfig('prev','<<上一页');
$Page -> setConfig('next','下一页>>');
$Page -> setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// var_dump($data);exit();
$result = $data->order('id')->limit($Page->firstRow.','.$Page->listRows)->select();
$this->assign('result',$data);
$this->assign('page',$show);
$this->display();
[/code]这里显示order()错误,意思好像是说这个id不是一个对象?
打印出来的$data是这样的
而在别的地方[code]
$User = M('product');
$count = $User->count();// 查询满足要求的总记录数\
$Page = new \Think\Page($count,12);
$Page -> setConfig('header','共%TOTAL_ROW%条');
$Page -> setConfig('first','首页');
$Page -> setConfig('last','共%TOTAL_PAGE%页');
$Page -> setConfig('prev','<<上一页');
$Page -> setConfig('next','下一页>>');
$Page -> setConfig('theme','%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%');
$show = $Page->show();
// var_dump($User);exit();
$result = $User->order('id')->limit($Page->firstRow.','.$Page->listRows)->select();
[/code]这样就没错,问题到底出在哪里啊
- 2 回答
- 0 关注
- 479 浏览
添加回答
举报
0/150
提交
取消