public function getBlogs() { $count = M("")->table('blog b,user u')->field('b.id,b.uid,b.content,b.type,b.view,b.rise,b.posttime,b.statu,b.tag,b.title,u.username,u.headpic')->where('b.uid=u.id')->order('b.posttime desc')->count(); // 查询满足要求的总记录数 $page = PAGEADMIN($count); // 实例化分页类 传入总记录数和每页显示的记录数 $show = $page->show(); // 分页显示输出 $data = M("")->table('blog b,user u')->field('b.id,b.uid,b.content,b.type,b.view,b.rise,b.posttime,b.statu,b.tag,b.title,u.username,u.headpic')->where('b.uid=u.id')->order('b.posttime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign('blogs', $data); $this->assign("page", $show); }
public function investorList() { $con = M()->table('user a,user_investor b')->field('a.id,a.username,a.nickname,b.type,a.email,a.province,a.reg_time')->where('a.id=b.uid')->count(); $page = PAGEADMIN($con); $show = $page->show(); // 分页显示输出 $data = M()->table('user a,user_investor b')->field('a.id,a.username,a.nickname,b.type,a.email,a.province,a.reg_time')->where('a.id=b.uid')->select(); $this->assign("title", "Investor"); $this->assign('user', $data); //数据源 $this->assign("tag", "投资人 <small>Investor</small>"); //标题头 $this->assign("icon", "dollar2"); //图标 $this->assign("page", $show); //分页 $this->display('user'); }
public function projectList() { $project = D("project"); $con = $project->count(); $page = PAGEADMIN($con); $show = $page->show(); // 分页显示输出 $data = $project->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign("title", "project"); $this->assign("tag", "项目 <small>Project</small>"); //标题头 $this->assign("icon", "lamp"); //图标 $this->assign('project', $data); //数据 $this->assign("page", $show); //分页 $this->display(); }
public function incubatorList() { $incubator = D('incubator'); $count = $incubator->getDataNum(); $page = PAGEADMIN($count); $data = $incubator->getDataList($page->firstRow, $page->listRows); $this->assign("incubatorList", $data); $this->assign("page", $page->show()); $this->display(); }