ThinkPHP3.1分页时,采用联表查询的处理。
采用table和field来查询所需数据
//实例化specialist表
$mod = M("specialist");
// 导入分页类
import('ORG.Util.Page');
//分页处理
$page = new Page($mod->where($where)->count(),2);
//分页联表查询
$mmod = $mod->table("sh_specialist a,sh_admin b")->field('a.specialist_id,a.specialist_name,
a.specialist_title,a.specialist_portrait,
a.specialist_class,a.research_field,a.detail_info,
b.admin_name')->where("a.admin_id=b.admin_id")
->where($where)->limit($page->firstRow,$page->listRows)->select();