public function index() { $put = I('s'); if (trim($put) == '') { $this->error('搜索内容不能为空!'); die; } $where['biaoti'] = $put; $where['content'] = $put; $where['_logic'] = 'OR'; $map['_complex'] = $where; $map['islock'] = 0; //复合查询 $count = M('article')->where($map)->count(); import('ORG.Util.Page'); $page = new page($count, 10); $page->setConfig('theme', '<ul class="pages">%first%%upPage%%linkPage%%downPage%%end%</ul>'); $show = $page->show(); //返回分页信息 $article = M('article')->where($map)->limit($page->firstRow . ',' . $page->listRows)->select(); foreach ($article as $key => $value2) { $article[$key]["imgs"] = imgs($article[$key]["imgs"]); } $this->assign('put', $put); $this->assign('show', $show); //分页信息 $this->assign('count', $count); //数据总数 $this->assign('list', $article); //数据集 $sidebar1 = M('article')->where('type=0')->order('approval desc')->limit('10')->select(); //赞多到少 $this->assign('approval', $sidebar1); $this->display('search'); }
public function getxia() { /* print_r($_GET); exit(); */ if ($_GET['id'] == 1) { echo "1"; exit; } //下拉的时候的条件 if ($_GET['nextrow']) { $pagestart = $_GET['nextrow']; } else { $pagestart = 0; } $data = M('article')->where('islock=0 and type=0 and imgs <>""')->limit($pagestart, 12)->field('biaoti,name,fbsj,jiage,article_id,imgs,diqu,leixing')->order('article_id desc')->select(); foreach ($data as $key => $value2) { $data[$key]["fbsj"] = date('m-d', strtotime($data[$key]["fbsj"])); } //key相当于第几个数据 foreach ($data as $key => $value2) { $data[$key]["imgs"] = imgs($data[$key]["imgs"]); } echo json_encode($data); $this->display(); }
public function article() { $User = M('article'); $username = cookie('username'); $data = $User->where('username="******" and islock=0')->order('article_id desc')->select(); $udata = $User->where('username="******" and islock=1')->order('article_id desc')->select(); foreach ($data as $key => $value2) { $data[$key]["imgs"] = imgs($data[$key]["imgs"]); } foreach ($udata as $key => $value) { $udata[$key]["imgs"] = imgs($udata[$key]["imgs"]); } $this->assign('data', $data); $this->assign('udata', $udata); $this->display('article'); }
public function index() { $class1 = I('c1', '', 'intval'); $class2 = I('c2', '', 'intval'); $type = I('type', '', 'intval'); $cl1 = M('class1')->where("id={$class1}")->find(); if ($class2 != '') { $cl2 = M('class2')->where("id={$class2}")->find(); } $cl2all = M('class2')->where("class1={$class1}")->select(); $this->assign('class1', $cl1); $this->assign('class2', $cl2); $this->assign('cl2all', $cl2all); //数据分页 import('ORG.Util.Page'); // 导入分页类 if ($type == 1) { $count = M('article')->where("class2={$class2} and islock=0")->count(); } else { $count = M('article')->where("class1={$class1} and islock=0")->count(); } //获取数据的总数 $page = new Page($count, 20); $page->setConfig('theme', '<ul class="pages">%first%%upPage%%linkPage%%downPage%%end%</ul>'); $show = $page->show(); //返回分页信息 if ($type == 1) { $articles = M('article')->where("class2={$class2} and islock=0 and type=0")->order('article_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); } else { $articles = M('article')->where("class1={$class1} and islock=0 and type=0")->order('article_id desc')->limit($page->firstRow . ',' . $page->listRows)->select(); } foreach ($articles as $key => $value2) { $articles[$key]["imgs"] = imgs($articles[$key]["imgs"]); } $this->assign('show', $show); $this->assign('count', $count); $this->assign('data', $articles); $sidebar1 = M('article')->where('type=0')->order('approval desc')->limit('10')->select(); //赞多到少 $this->assign('approval', $sidebar1); $this->display('list_article'); }
function makeCategory($page = []) { $page['slug'] = isset($page['slug']) ? $page['slug'] : str_slug($page['title']); $page['images'] = isset($page['images']) ? $page['images'] : imgs(); return factory(\App\Category::class)->create($page); }