$Dao = M();
import('ORG.Util.Page');// 导入分页类
$count = $Dao->count();
$Page = new Page($count);
$show = $Page->show();
$sql="SELECT order_info.total_price,order_info.order_sn,productinfo.softname,entprise.name,order_info.createtime FROM order_info
INNER JOIN order_product_mapping ON order_info.order_sn=order_product_mapping.order_sn
INNER JOIN productinfo ON productinfo.id = order_product_mapping.productid
INNER JOIN entprise ON entprise.id = order_product_mapping.entid
ORDER BY order_product_mapping.createtime DESC";
$odlist = $Dao->order('createtime')->limit($Page->firstRow.','.$Page->listRows)->query($sql);
$this->assign('page',$show);
//var_dump($show);exit;
//$odlist = $Dao->query($sql);
if($odlist) {
$this->orderlist = $odlist;// 模板变量赋值
}else{
$this->error('数据错误');
}
// $this->display();
R('Index/index');
import('ORG.Util.Page');// 导入分页类
$count = $Dao->count();
$Page = new Page($count);
$show = $Page->show();
$sql="SELECT order_info.total_price,order_info.order_sn,productinfo.softname,entprise.name,order_info.createtime FROM order_info
INNER JOIN order_product_mapping ON order_info.order_sn=order_product_mapping.order_sn
INNER JOIN productinfo ON productinfo.id = order_product_mapping.productid
INNER JOIN entprise ON entprise.id = order_product_mapping.entid
ORDER BY order_product_mapping.createtime DESC";
$odlist = $Dao->order('createtime')->limit($Page->firstRow.','.$Page->listRows)->query($sql);
$this->assign('page',$show);
//var_dump($show);exit;
//$odlist = $Dao->query($sql);
if($odlist) {
$this->orderlist = $odlist;// 模板变量赋值
}else{
$this->error('数据错误');
}
// $this->display();
R('Index/index');
解决方案 »
- mysql中的查询语言
- 一个参数问题,寻求帮忙(送高分)
- orcal怎样设置局域网连接?
- PHP mysqli如何连接MySQL数据库
- 请教如何将数据库中的数据显示在textarea中
- curl在本地wamp没问题,传到服务器lampp下载不了文件
- 高分求救,为什么还是显示找不到文件?
- 如何计算两个tmestamp时间之间差多少天?
- 在使用GD图形库处理的图形在IE中看见的只是乱码,请问着是怎么回事?
- preg_replace_callback替换preg_replace
- android访问本机PHP页面遇到的问题
- 选课系统,PHP模拟POST后,返回值与正常抓包所得的返回值一致,但是在已选课中却并没有这门课?
$map=array('id'=>intval($_GET['id']));
$count = $userDB->where($map)->count();
$Page = new Page($count);
$list = $userDB->join('AS w LEFT JOIN '.C('DB_PREFIX').'users AS u ON w.uid=u.id')
->join('LEFT JOIN '.C('DB_PREFIX').'user_group AS g ON u.gid=g.id')
->join('LEFT JOIN '.C('DB_PREFIX').'wechat_group_list AS l ON w.token=l.token')
->field('w.*,u.username,g.name AS groupName,count(l.id) AS fansNum')
->group('w.id')
->where($map)
->order('w.id ASC')
->limit($Page->firstRow.','.$Page->listRows)
->select();$this->assign('list',$list);
$this->assign('page',$Page);// 赋值分页输出
$this->display();