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);
}
