public function index() { $User = D($this->selectmodel); // 实例化User对象 import('@.Util.Page'); // 导入分页类 $where = array(); $this->setwhere($where); $count = $User->where($where)->count(); // 查询满足要求的总记录数 $Page = new Page($count, 25); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('theme', "%upPage% %linkPage% %downPage%"); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $User->where($where)->order($this->orderby)->limit($Page->firstRow . ',' . $Page->listRows)->select(); // echo D()->getLastSql(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display("index"); // 输出模板 }
public function index() { // $data = Db::table('article')->get(); // $count = count($data); // // p($_SERVER);exit; // // // p($count);exit; // // // p(Page::getTotalPage($data));exit; // $page = Page::row(10)->pageNum(3)->make($count); // $data = Db::table('article')-> // limit(Page::limit())->get(); // $num = Page::getTotalPage($page); // // p($num);exit; // View::with('page',$page)->with('data',$data)->make(); $data = Db::table('article')->get(); // p($data); $page = Page::row(10)->pageNum(4)->make(count($data)); $data = Db::table('article')->limit(Page::limit())->get(); p(Page::limit()); $num = Page::getTotalPage(); p($num); View::with('page', $page)->with('data', $data)->make(); }
public function category() { if (IS_POST) { define('THEME_PATH', './Template/'); $id = I('cid', '', 'intval'); if (!$id) { $this->error('请选择栏目!', U('Html/category')); exit; } $where = array('is_show' => 1, 'id' => $id); $cate = M('cate')->where($where)->select(); foreach ($cate as $k => $v) { $_GET['cid'] = $v['id']; $htmldir = './Html/' . C('WEBSTYLE') . '/' . $v['list_html'] . '/'; $list_style = reset(explode('.', $cate['list_style'])); $list = $list_style ? $list_style : 'list'; $htmlfile = C('WEBSTYLE') . '/' . $list; $this->buildHtml('index', $htmldir, $htmlfile, 'utf-8'); import('Common/Org/Util/Page'); for ($i = 1; $i <= \Page::$staticTotalPage; $i++) { $_GET['page'] = $i; $pageurl = './Html/' . C('WEBSTYLE') . '/' . $v['list_html'] . '/'; \Page::$staticUrl = $pageurl . '{page}.html'; $this->buildHtml($i, $htmldir, $htmlfile, 'utf-8'); } copy($htmldir . '1.html', $htmldir . 'index.html'); } $this->success('成功生成栏目页静态!', U('Index/welcome')); } else { $where = array('is_show' => 1, 'is_html' => 1); $cate = M('cate')->where($where)->order('sort asc')->select(); import('Common/ORG/Util/Data'); $MyCate = new \Data(); $this->cate = $MyCate::tree($cate, 'name'); $this->display(); } }
public function createCategoryConfig() { if (IS_POST) { $cat = Db::table('category')->get(); $data = array(); foreach ($cat as $c) { $_GET['id'] = $c['id']; ob_start(); $obj = new \Home\Controller\IndexController(); $obj->category(); ob_get_clean(); // $c['id'] = 20; $num = Page::getTotalPage(); $data[$c['id']] = $num; } F('__HTML__', $data); go('createCategory'); } else { F('__HTML__', '[del]'); View::make(); } }
function pageNavgation($count, $pageSize = 10) { import('@.ORG.Page'); $page = new Page($count, $pageSize); $page->setConfig('header', '条记录'); $page->setConfig('theme', '<span class="pagestyle" style="color:blue">共%totalRow%%header%</span> <span class="pagestyle">当前%nowPage% / %totalPage% 页</span> %first% %upPage% %linkPage% %downPage% %end%'); return $page; }