public function sechWeibo() { $keyword = $this->_getKeyword(); if ($keyword) { //检索含有关键字的微博 $where = array('content' => array('LIKE', '%' . $keyword . '%')); $db = D('Weibo'); //分页 $count = M('weibo')->where($where)->count('id'); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(25) $limit = $Page->firstRow . ',' . $Page->listRows; $Page->setConfig('theme', "共 %TOTAL_ROW% 条记录 %FIRST% %UP_PAGE% %NOW_PAGE% / %TOTAL_PAGE% %DOWN_PAGE% %END% "); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $weibo = $db->getAll($where, $limit); //判断是否有内容 $this->weibo = $weibo ? $weibo : false; //页码 $this->count = $count; $this->page = $Page->show(); // 分页显示输出 } $this->keyword = $keyword; // p($result);die; $this->display(); }
public function index() { $user = $this->getModel(); $count = $user->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(10) // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $data = $user->relation(TRUE)->limit($Page->firstRow . ',' . $Page->listRows)->select(); //设置显示方式 $Page->setConfig('prev', "上一页"); //上一页 $Page->setConfig('next', '下一页'); //下一页 $Page->setConfig('first', '首页'); //第一页 $Page->setConfig('last', "末页"); //最后一页 $Page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); $show = $Page->show(); // 分页显示输出 $this->assign('data', $data); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display("user/list"); // 输出模板 }
public function showlist() { $model = new \Model\TypeModel(); //获取总记录数 $count = $model->count(); //获取页面大小 $pagesize = C('pagesize'); //实例化分页类 $page = new \Think\Page($count, $pagesize); //设置分页样式 $page->lastSuffix = false; //不显示末页 $page->rollPage = 3; //一次显示三页 $page->setConfig('prev', '【上一页】'); $page->setConfig('next', '【下一页】'); $page->setConfig('first', '【首页】'); $page->setConfig('last', '【末页】'); $page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); //调用分页显示方法 $pageinfo = $page->show(); //获取页面数据 $list = $model->order('type_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); //获取当前页方便跳转 $nowpage = $page->nowPage; //视图显示 $this->assign('list', $list); $this->assign('pageinfo', $pageinfo); $this->assign('nowpage', $nowpage); $this->display(); }
public function suggest1() { $id = $_SESSION['home']['id']; if (IS_POST) { //建议表内容 $suggest = $_POST['suggest']; $cont_info = $_POST['cont_info']; $user_id = $id; $cre_time = time(); //把建议内容插入到ju_suggest表中 $model = M(); $model->execute("insert into ju_suggest(`suggest`,`cont_info`,`user_id`,`cre_time`) values('{$suggest}','{$cont_info}','{$user_id}','{$cre_time}')"); } //意见反馈的遍历 $suggest = D('suggest'); $map['user_id'] = $id; $map['state'] = 1; $total = $suggest->where($map)->count(); $page = new \Think\Page($total, 5); $list = $suggest->where($map)->order('cre_time desc')->limit($page->firstRow . ',' . $page->listRows)->field('suggest,cre_time,reply')->select(); $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $page->setConfig('first', '首页'); $page->setConfig('last', '尾页'); $pageButton = $page->show(); //dump($list); $this->assign('list', $list); $this->assign('pageButton', $pageButton); $this->display(); }
public function search($pageSize = 20) { /**************************************** 搜索 ****************************************/ $where = array(); if ($level_name = I('get.level_name')) { $where['level_name'] = array('like', "%{$level_name}%"); } if ($bottom_num = I('get.bottom_num')) { $where['bottom_num'] = array('eq', $bottom_num); } if ($top_num = I('get.top_num')) { $where['top_num'] = array('eq', $top_num); } if ($rate = I('get.rate')) { $where['rate'] = array('eq', $rate); } /************************************* 翻页 ****************************************/ $count = $this->alias('a')->where($where)->count(); $page = new \Think\Page($count, $pageSize); // 配置翻页的样式 $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $data['page'] = $page->show(); /************************************** 取数据 ******************************************/ $data['data'] = $this->alias('a')->where($where)->group('a.id')->limit($page->firstRow . ',' . $page->listRows)->select(); return $data; }
public function index() { $ip = $_SERVER["REMOTE_ADDR"]; $now = date("Y-m-d H:i:s", time()); $less_minute_time = date("Y-m-d H:i:s", time() - 60); $visitor = M('Visitors'); $res = $visitor->where('ip_address="' . $ip . '" AND visit_start_at >="' . $less_minute_time . '"')->find(); if (!$res) { $sum = M('sums'); $total = $sum->where('id=1')->getField('visitor_sum'); $visitor->add(array('ip_address' => $ip, 'visit_start_at' => $now, 'created_at' => $now)); $data['visitor_sum'] = $total + 1; $sum->where('id=1')->save($data); } $article = new Article(); $count = $article->order('updated_at desc')->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 3); // 实例化分页类 传入总记录数和每页显示的记录数(25) $Page->setConfig('header', '页'); $Page->setConfig('prev', ''); $Page->setConfig('next', ''); $Page->setConfig('first', '>>'); $Page->setConfig('end', '<<'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $article->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('articles', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display('index'); // 输出模板 }
/** * @name index * @access root * @const 指明常量 * @module Home * @param * @return 渲染对应视图 * @throws * @todo * @var $all_log所有日志分页,$wait_user待审核用户 * @version 1.0 */ public function index() { $this->init(); $all_user = $this->user->join('exam_role_user ON exam_user.id = exam_role_user.user_id')->join('exam_role ON exam_role_user.role_id = exam_role.id')->field('exam_user.id,exam_user.email,exam_user.createtime,exam_user.username,exam_role.name')->where("exam_user.status = 1 AND exam_user.username != 'root'")->select(); $this->assign('all_user', $all_user); $all_wait_user = $this->user->where("status=0")->select(); $this->assign('wait_user', $all_wait_user); $this->assign('goal', $goal); // 赋值数据集 $count = $this->log->count(); // 查询满足要求的总记录数$Page $log = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数 $log->lastSuffix = false; $log->setConfig('prev', '上一页'); $log->setConfig('next', '下一页'); $log->setConfig('last', '末页'); $log->setConfig('first', '首页'); $log->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%'); $all_log = $this->log->limit($log->firstRow . ',' . $log->listRows)->select(); $this->assign('log', $all_log); $log_show = $log->show(); // 分页显示输出 $this->assign('log_cut', $log_show); // 赋值分页输出 $this->display(''); }
public function showlist() { //取出商品栏目 $cat_model = new \Model\CategoryModel(); $cat_list = $cat_model->getTree(); $this->assign('cat_list', $cat_list); //取出商品并分页显示 $goods_model = new \Model\GoodsModel(); $pagesize = C('pagesize'); $count = $goods_model->count(); $page = new \Think\Page($count, $pagesize); //设置分页样式 $page->lastSuffix = false; //不显示末页 $page->rollPage = 3; //一次显示三页 $page->setConfig('prev', '【上一页】'); $page->setConfig('next', '【下一页】'); $page->setConfig('first', '【首页】'); $page->setConfig('last', '【末页】'); $page->setConfig('theme', '共 %TOTAL_ROW% 条记录,当前 %NOW_PAGE%/%TOTAL_PAGE%%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); $pageinfo = $page->show(); //获取当前页方便跳转 $nowpage = $page->nowPage; $goods_list = $goods_model->order('goods_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); $this->assign('goods_list', $goods_list); $this->assign('pageinfo', $pageinfo); $this->assign('nowpage', $nowpage); $this->display(); }
/** * 广告列表 * */ public function index() { if (IS_POST) { $title = I('post.search_text'); if ($title) { $condition['name'] = array('like', '%' . $title . '%'); } } $advertModel = D('Advert'); $count = $advertModel->where($condition)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 15); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', "%UP_PAGE% %FIRST% %LINK_PAGE% %DOWN_PAGE% %END% <span>共%TOTAL_ROW% %HEADER% %NOW_PAGE%/%TOTAL_PAGE% 页</span>"); $show = $Page->show(); // 分页显示输出 $data = $advertModel->getList($Page, $condition); foreach ($data as $k => $v) { if ($v['status'] == 20) { $data[$k][status] = '启用'; } else { $data[$k][status] = '禁用'; } } $this->assign('data', $data); $this->assign('page', $show); $this->assign('title', '广告列表'); $this->display(); }
public function shop_edit() { check_login(); $edit_id = I('get.edit_id', '', 'number_int'); if ($edit_id) { $NODE_URL = U("Menu/dish_add?add_id=" . $edit_id); $this->assign("ADD_URL", $NODE_URL); $shop_thing = M('shop')->where('shop_id=' . $edit_id)->find(); $this->assign("shop_thing", $shop_thing); $M_shop = M("dish"); $count = $M_shop->where('shop_id=' . $edit_id)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); $Page->setConfig('header', '共 <span style="font-weight:bold;color:#FF6600;"> %TOTAL_ROW% </span>条记录'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('prev', '上一页'); $Page->setConfig('theme', '%HEADER% <span style="font-weight:bold;color:blue;">%NOW_PAGE%</span>/<span style="font-weight:bold;">%TOTAL_PAGE%</span>页 %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $M_shop->where('shop_id=' . $edit_id)->order('dish_id')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display('shop'); } else { $this->error('非法操作!'); } }
/** * 获取单一用户评论,并且关联商品信息 * @param string $email 邮箱 * @return array */ public function getUserComment($uid, $p) { $p *= 20; $comment = array(); $model = M(); $sql = "select cid from comment where uid={$uid} && status=1 order by addtime asc limit {$p},20"; $sqlCount = "select count(*) from comment where uid={$uid} && status=1 order by addtime asc"; $commentId = $model->query($sql); $countComment = $model->query($sqlCount); $count = $countComment[0]['count(*)']; // 查询满足要求的总记录数 $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $show = $Page->show(); // 分页显示输出 if (!empty($commentId)) { foreach ($commentId as $k => $v) { $sql = "select goods.gid, goods.title, goods.price, goods.oldprice, goods.gimage, goods.gurl,\n\t\t\t\t\t\tcomment.cid, comment.content, comment.addtime from comment left join goods on comment.gid\n\t\t\t\t\t\t= goods.gid where cid={$v['cid']} order by comment.addtime desc"; $comArr = $model->query($sql); $comment[] = $comArr[0]; } } return array($comment, $show); }
public function search($pageSize = 20) { /**************************************** 搜索 ****************************************/ $where = array(); if ($brand_name = I('get.brand_name')) { $where['brand_name'] = array('like', "%{$brand_name}%"); } if ($site_url = I('get.site_url')) { $where['site_url'] = array('like', "%{$site_url}%"); } if ($goods_desc = I('get.goods_desc')) { $where['goods_desc'] = array('eq', $goods_desc); } if ($sort = I('get.sort')) { $where['sort'] = array('eq', $sort); } if ($is_show = I('get.is_show')) { $where['is_show'] = array('eq', $is_show); } /************************************* 翻页 ****************************************/ $count = $this->alias('a')->where($where)->count(); $page = new \Think\Page($count, $pageSize); // 配置翻页的样式 $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $data['page'] = $page->show(); /************************************** 取数据 ******************************************/ $data['data'] = $this->alias('a')->where($where)->group('a.id')->limit($page->firstRow . ',' . $page->listRows)->select(); return $data; }
public function index() { if (!empty($_GET['name'])) { $map['lesson'] = array('like', "%{$_GET['name']}%"); } //if(strlen($_GET['sex'] ) > 0) $map['sex'] = $_GET['sex']; $lesson = D('Lesson'); $total = $lesson->where($map)->count(); $page = new \Think\Page($total, 5); $lesson_list = $lesson->where($map)->limit($page->firstRow . ',' . $page->listRows)->getAll(); $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $page->setConfig('first', '首页'); $page->setConfig('last', '尾页'); $pageButton = $page->show(); $this->assign('list', $lesson_list); $this->assign('pageButton', $pageButton); // 计划开始 $Plan = D('Plan'); $pl_list = $Plan->where('pid=0')->select(); $this->assign('pl_list', $pl_list); // 分享开始 $Share = D('Share'); $sh_list = $Share->select(); $this->assign('sh_list', $sh_list); $this->display(); }
public function join() { $this->title = '我参与的'; $this->user = M('user')->find($this->user_id); $page = I('request.p', 1); $page = $page < 1 ? 1 : $page; $list = M('hongbao_order')->where(array('user_id' => $this->user_id))->page($page, 10)->order("id DESC")->select(); if ($list) { foreach ($list as $i => $item) { $list[$i]['hongbao'] = M('hongbao')->find($item['hongbao_id']); $list[$i]['user'] = M('user')->find($list[$i]['hongbao']['user_id']); } } $total = M('hongbao_order')->where(array('user_id' => $this->user_id))->count(); $this->list = $list; $Page = new \Think\Page($total, 10); // 实例化分页类 传入总记录数和每页显示的记录数(20) $Page->rollPage = 5; $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', '%UP_PAGE% %DOWN_PAGE% <li ><a>共 %TOTAL_ROW% 条记录</a></li>'); $show = $Page->show(); $this->page = $show; $this->display(); }
public function index() { check_login(); $NODE_URL = U("Comment/index"); $this->assign("NODE_URL", $NODE_URL); $NODE_URL = U("Comment/node_add"); $this->assign("node_add", $NODE_URL); $M_shop = M("scomment"); $count = $M_shop->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); $Page->setConfig('header', '共 <span style="font-weight:bold;color:#FF6600;"> %TOTAL_ROW% </span>条记录'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('prev', '上一页'); $Page->setConfig('theme', '%HEADER% <span style="font-weight:bold;color:blue;">%NOW_PAGE%</span>/<span style="font-weight:bold;">%TOTAL_PAGE%</span>页 %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $M_shop->order('comment_id')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); }
public function index() { $name = session('nickname'); if (empty($name)) { header("Location:/TP/index.php/login"); exit; } else { $user = M("user"); $map['nickname'] = array('neq', $name); $count = $user->where($map)->count(); //echo $count; $page = new \Think\Page($count, 5); $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $page->setConfig('last', '末页'); $page->setConfig('first', '首页'); $page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% 第 ' . I('p', 1) . ' 页/共 %TOTAL_PAGE% 页 (5位/页)'); $show = $page->show(); $list = $user->where($map)->order('id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); //var_dump($list); $this->assign('list', $list); $this->assign('page', $show); $this->display('./Application/home/view/addfriend.html'); } }
/** * 系统参数列表 * @author copoet */ public function index() { if (IS_POST) { $title = I('post.search_text'); if ($title) { $condition['id|sys_explain|sys_name'] = array('like', '%' . $title . '%'); } } $systemModel = D('system'); $count = $systemModel->where($condition)->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 20); // 实例化分页类 传入总记录数和每页显示的记录数(25) $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', "%UP_PAGE% %FIRST% %LINK_PAGE% %DOWN_PAGE% %END% <span>共%TOTAL_ROW% %HEADER% %NOW_PAGE%/%TOTAL_PAGE% 页</span>"); $show = $Page->show(); // 分页显示输出 $data = $systemModel->getList($Page, $condition); $this->assign('data', $data); $this->assign('page', $show); // 赋值分页输 $this->assign('title', '系统参数列表'); $this->display(); }
public function index() { /** !控制器必须 **/ /* 热词调用*/ $hotsearch = R("Index/getHotsearch"); $this->assign('hotsearch', $hotsearch); /** * 控制器必须!**/ $tuan = M("tuan"); $category = $tuan->order("id")->select(); //团购分类 $this->assign('category', $category); // 赋值数据集 /* 获取商品*/ $User = M("tuanid"); $count = M('tuanid')->count(); $Page = new \Think\Page($count, 10); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('first', '第一页'); $Page->setConfig('last', '尾页'); $Page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%'); $show = $Page->show(); $list = $User->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); $this->display(); }
public function projects() { // type=2; $News = M('news'); // 实例化User对象 $count = $News->where('type=2')->count(); // 查询满足要求的总记录数 $page = new \Think\Page($count, 8); // 实例化分页类 传入总记录数和每页显示的记录数(25) // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $res = $News->where('type=2')->order('datetime desc')->limit($page->firstRow . ',' . $page->listRows)->select(); for ($i = 0; $i < sizeof($res); $i++) { $res[$i]['url'] = U('News/newsinfo', array('id' => $res[$i]['id'])); } $page->setConfig('header', '共%TOTAL_ROW%条新闻'); $page->setConfig('theme', '%HEADER% %FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% 共%TOTAL_PAGE%页'); $show = $page->show(); // 分页显示输出 $this->assign('news', $res); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->display(); // 输出模板 }
public function search($pageSize = 20) { /**************************************** 搜索 ****************************************/ $where = array(); if ($attr_name = I('get.attr_name')) { $where['attr_name'] = array('like', "%{$attr_name}%"); } if ($attr_type = I('get.attr_type')) { $where['attr_type'] = array('eq', $attr_type); } if ($attr_option_values = I('get.attr_option_values')) { $where['attr_option_values'] = array('like', "%{$attr_option_values}%"); } if ($type_id = I('get.type_id')) { $where['type_id'] = array('eq', $type_id); } /************************************* 翻页 ****************************************/ $count = $this->alias('a')->where($where)->count(); $page = new \Think\Page($count, $pageSize); // 配置翻页的样式 $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $data['page'] = $page->show(); /************************************** 取数据 ******************************************/ $data['data'] = $this->alias('a')->where($where)->group('a.id')->limit($page->firstRow . ',' . $page->listRows)->select(); return $data; }
/** * 列表 * */ public function index() { $smsModel = D('sms'); $count = $smsModel->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 15); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('header', '条记录'); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', "%UP_PAGE% %FIRST% %LINK_PAGE% %DOWN_PAGE% %END% <span>共%TOTAL_ROW% %HEADER% %NOW_PAGE%/%TOTAL_PAGE% 页</span>"); $show = $Page->show(); // 分页显示输出 $data = $smsModel->getList($Page); foreach ($data as $k => $v) { if ($v['status'] == 20) { $data[$k][status] = '启用'; } else { $data[$k][status] = '禁用'; } } $this->assign('data', $data); $this->assign('page', $show); $this->assign('title', '短信配置'); $this->display(); }
/** * 列表页 */ public function index() { $id = (int) I('get.id'); $cate = M('cate')->order('sort')->select(); $cids = \Admin\Common\Category::getChildsId($cate, $id); $cids[] = $id; $where = array('cid' => array('IN', $cids), 'del' => 0); // 获取总文章数 $count = M('blog')->where($where)->count(); // 实例化分页类 $page = new \Think\Page($count, 5); // 设置分页链接样式 $page->setConfig('prev', '<'); $page->setConfig('next', '>'); $limit = $page->firstRow . ',' . $page->listRows; $cate = D('BlogView')->getAll($where, $limit); // 显示分页 $page = $page->show(); // 解析并重新整理分页URL $page = trimPageUrl($page); // 转换每一篇文章video字段的HTML实体用于输出 foreach ($cate as $key => $value) { $cate[$key]['video'] = htmlspecialchars_decode($cate[$key]['video']); $cate[$key]['image'] = __APP__ . '/' . trim($cate[$key]['image'], '@'); } $this->assign('cate', $cate); $this->assign('page', $page); $this->display(); }
public function lineAction() { header("Content-Type:text/html; charset=UTF-8"); $res = $this->achievementAction(10000); $rebate = D('Rebate'); $key = 1; $res = $rebate->init($key); $Page = new \Think\Page(count($res), 10); // 实例化分页类 传入总记录数和每页显示的 $Page->setConfig('theme', '%FIRST% %UP_PAGE% %HEADER% %DOWN_PAGE% %END%'); $Page->setConfig('header', '<span class="rows">共 %TOTAL_ROW% 个返点</span>%LINK_PAGE%<span class="currentrows">当前第 %NOW_PAGE% 页</span>'); $show = $Page->show(); // 分页显示输出 $this->assign('page', $show); // 赋值分页输出 foreach ($res as $key => $value) { $res[$key]['actionUrl']['edit'] = U('Rebate/Edit/line?id=' . $value['id']); $res[$key]['actionUrl']['delete'] = U('Rebate/Delete/line?id=' . $value['id']); } $this->assign('rebate', $res); $this->assign('urlAdd', U('Rebate/Add/line')); $TPL = T('Rebate@Index/index'); $this->assign('YZRight', $this->fetch($TPl)); $this->display(YZ_TEMPLATE); }
/** * 视图:用户列表 */ public function index() { $visitors = M('Visitors'); $count = $visitors->order('created_at desc')->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(25) $Page->setConfig('header', '页'); $Page->setConfig('prev', ''); $Page->setConfig('next', ''); $Page->setConfig('first', '>>'); $Page->setConfig('end', '<<'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $visitors->order('created_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); //访问总次数 $sum = M('sums'); $total = $sum->where('id=1')->getField('visitor_sum'); $this->assign('visitors', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->assign('sum', $total); $this->display('index'); // 输出模板 }
public function index() { $keyword = I('words'); //获取分类的英文名称 $key = I('get.order'); $sort = I('get.sort'); if (isset($key)) { if ($key == "1") { $listsort = "view" . " " . $sort; } if ($key == "2") { $listsort = "id" . " " . $sort; } if ($key == "3") { $listsort = "price" . " " . $sort; } if ($key == "4") { $listsort = "sale" . " " . $sort; } } if (empty($key)) { $key = "1"; $see = "asc"; $order = "view"; $sort = "asc"; $listsort = $order . " " . $sort; } if ($sort == "asc") { $see = "desc"; } if ($sort == "desc") { $see = "asc"; } $this->assign('see', $see); $this->assign('order', $key); $this->assign('value', $sort); $map['title|name|description'] = array('like', '%' . $keyword . '%'); $count = M('Document')->where($map)->count(); $Page = new \Think\Page($count, 12); $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('first', '第一页'); $Page->setConfig('last', '尾页'); $Page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END% %HEADER%'); $show = $Page->show(); $field = "id,title,price,tuan_price,qg_price,ms_price,brand,fengmian"; $list = M('Document')->where($map)->field($field)->order($listsort)->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('list', $list); // 赋值数据集 $this->assign('page', $show); $this->assign('searchlist', $list); $this->assign('keyword', $keyword); /* 热词调用*/ $hotsearch = C('HOT_SEARCH'); $this->assign('hotsearch', $hotsearch); $this->meta_title = $keyword . '的搜索结果'; $this->display(); }
function PAGE($count, $pageNum = 12) { $Page = new \Think\Page($count, $pageNum); // 实例化分页类 传入总记录数和每页显示的记录数 $Page->setConfig('prev', '上一页'); $Page->setConfig('next', '下一页'); $Page->setConfig('theme', "%UP_PAGE%%LINK_PAGE%%DOWN_PAGE%"); return $Page; }
function getPage($table, $eachNum, $where) { $count = $table->where($where)->count(); $page = new \Think\Page($count, $eachNum); $page->setConfig('prev', 'prev'); $page->setConfig('next', 'next'); $page->setConfig('theme', '%FIRST% %UP_PAGE% %LINK_PAGE% %DOWN_PAGE% %END%'); return $page; }
/** *视图: 评论列表 **/ public function index() { $map = array(); $content = $article_id = $created_at_start = $created_at_end = ''; $content = $_GET['content']; if ($content != null) { $map['content'] = array('like', "%{$content}%"); } $article_id = $_GET['article_id']; if ($article_id != null) { $map['article_id'] = array('eq', $article_id); } $created_at_start = $_GET['created_at_start']; if ($created_at_start != null) { $map['created_at'] = array('egt', $created_at_start); } $created_at_end = $_GET['created_at_end']; if ($created_at_end != null) { $map['created_at'] = array('elt', $created_at_end); } if ($created_at_start != null && $created_at_end != null) { $map['created_at'] = array('between', array($created_at_start, $created_at_end)); } $this->assign('content', $content); $this->assign('article_id', $article_id); $this->assign('created_at_start', $created_at_start); $this->assign('created_at_end', $created_at_end); //所有文章 $mod = M('articles'); $articles = $mod->order('updated_at desc')->select(); $articleArr = array(); foreach ($articles as $article) { $articleArr[$article['article_id']] = $article['title']; } $comments = new Comment(); $count = $comments->where($map)->order('updated_at desc')->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(25) $Page->setConfig('header', '页'); $Page->setConfig('prev', ''); $Page->setConfig('next', ''); $Page->setConfig('first', '>>'); $Page->setConfig('end', '<<'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $comments->where($map)->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('comments', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->assign('articleArr', $articleArr); $this->display('index'); // 输出模板 }
public function index() { $map = array(); $title = $author = $case_type = $updated_at_start = $updated_at_end = ''; $title = $_GET['title']; if ($title != null) { $map['title'] = array('like', "%{$title}%"); } $author = $_GET['author']; if ($author != null) { $map['author'] = array('like', "%{$author}%"); } $case_type = $_GET['case_type']; if ($case_type != null) { $map['case_type'] = array('eq', $case_type); } $updated_at_start = $_GET['updated_at_start']; if ($updated_at_start != null) { $map['updated_at'] = array('egt', $updated_at_start); } $updated_at_end = $_GET['updated_at_end']; if ($updated_at_end != null) { $map['updated_at'] = array('elt', $updated_at_end); } if ($updated_at_start != null && $updated_at_end != null) { $map['updated_at'] = array('between', array($updated_at_start, $updated_at_end)); } $this->assign('title', $title); $this->assign('author', $author); $this->assign('case_type', $case_type); $this->assign('updated_at_start', $updated_at_start); $this->assign('updated_at_end', $updated_at_end); $case = M('Cases'); $count = $case->where($map)->order('updated_at desc')->count(); // 查询满足要求的总记录数 $Page = new \Think\Page($count, 10); // 实例化分页类 传入总记录数和每页显示的记录数(25) $Page->setConfig('header', '页'); $Page->setConfig('prev', ''); $Page->setConfig('next', ''); $Page->setConfig('first', '>>'); $Page->setConfig('end', '<<'); $show = $Page->show(); // 分页显示输出 // 进行分页数据查询 注意limit方法的参数要使用Page类的属性 $list = $case->where($map)->order('updated_at desc')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $this->assign('cases', $list); // 赋值数据集 $this->assign('page', $show); // 赋值分页输出 $this->assign('case_types', getCaseType()); $this->display('index'); // 输出模板 }
/** * 获取显示页 */ public function show($count) { // 查询满足要求的总记录数 $page = new \Think\Page($count, 8); // 每页八条记录 $page->setConfig('header', '个会员'); $page->setConfig('prev', '上一页'); $page->setConfig('next', '下一页'); $show = $page->show(); return $show; }