thinkphp几个表的数据合并,并用数组分页

控制器:

//金币扣除
public function jbkc(){
$map['UG_dataType']= 'xtkc';
$list1 = M ( 'userget' )->where ( $map )->select ();
$list2 = M ( 'userget2' )->where ( $map )->select ();
$list3 = M ( 'userget3' )->where ( $map )->select ();
$list0=array_merge($list1,$list2,$list3);
$count=count($list0);
$p = getpage($count,20);
$list=array_slice($list0,$p->firstRow,$p->listRows);
$this->assign ( 'list', $list );
$this->assign ( 'page', $p->show());
$this->display('index/jbkc');
}

公共函数:

function getpage($count, $pagesize = 10) {
$p = new Think\Page($count, $pagesize);
$p->setConfig('header', '<li class="rows">共<b>%TOTAL_ROW%</b>条记录 第<b>%NOW_PAGE%</b>页/共<b>%TOTAL_PAGE%</b>页</li>');
$p->setConfig('prev', '上一页');
$p->setConfig('next', '下一页');
$p->setConfig('last', '末页');
$p->setConfig('first', '首页');
$p->setConfig('theme', '%FIRST%%UP_PAGE%%LINK_PAGE%%DOWN_PAGE%%END%%HEADER%');
$p->lastSuffix = false;//最后一页不显示为总页数
return $p;
}
上一篇:C++名字空间/C++命名空间


下一篇:思维导图软件MindManager for Windows中如何修改思维导图布局