贴代码
public function query_money(){
$m = M();
$where = "1=1";//fanwe_payment_notice.user_id >70000
$count = $m->where($where)->query("SELECT count(*) from fanwe_payment_notice LEFT JOIN fanwe_user on (fanwe_user.id = fanwe_payment_notice.user_id)");
//select u.id,u.user_name,u.mobile,p.notice_sn,p.is_paid,p.money,p.pay_date,p.memo from fanwe_user u , fanwe_payment_notice p where p.user_id = u.id $p = getpage($count[0]['count(*)'],10);
$sql = "SELECT fanwe_user.id,fanwe_user.user_name,fanwe_user.mobile,fanwe_payment_notice.notice_sn,fanwe_payment_notice.is_paid,fanwe_payment_notice.money,fanwe_payment_notice.pay_date from fanwe_payment_notice LEFT JOIN fanwe_user on (fanwe_user.id = fanwe_payment_notice.user_id)";
$list = $m->field(true)->where($where)->order('id')->limit($p->firstRow, $p->listRows)->query($sql);
$this->assign('page', $p->show()); // 赋值分页输出
$this->assign('list', $list); // 赋值数据集
$this->display();
}
1.数据可以查询出来,并且也是显示出来的,可是分页不起作用
我的分页方法是正常的,在别的页面可以正常调用!
但是在这个里面,就不显示分页效果了!求教各位大腿!
public function query_money(){
$m = M();
$where = "1=1";//fanwe_payment_notice.user_id >70000
$count = $m->where($where)->query("SELECT count(*) from fanwe_payment_notice LEFT JOIN fanwe_user on (fanwe_user.id = fanwe_payment_notice.user_id)");
//select u.id,u.user_name,u.mobile,p.notice_sn,p.is_paid,p.money,p.pay_date,p.memo from fanwe_user u , fanwe_payment_notice p where p.user_id = u.id $p = getpage($count[0]['count(*)'],10);
$sql = "SELECT fanwe_user.id,fanwe_user.user_name,fanwe_user.mobile,fanwe_payment_notice.notice_sn,fanwe_payment_notice.is_paid,fanwe_payment_notice.money,fanwe_payment_notice.pay_date from fanwe_payment_notice LEFT JOIN fanwe_user on (fanwe_user.id = fanwe_payment_notice.user_id)";
$list = $m->field(true)->where($where)->order('id')->limit($p->firstRow, $p->listRows)->query($sql);
$this->assign('page', $p->show()); // 赋值分页输出
$this->assign('list', $list); // 赋值数据集
$this->display();
}
1.数据可以查询出来,并且也是显示出来的,可是分页不起作用
我的分页方法是正常的,在别的页面可以正常调用!
但是在这个里面,就不显示分页效果了!求教各位大腿!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货