$count = count($childs); return $count; } /** * 获取指定id的所有后代,不含指定id * @param type $id 指定id, 有可能是array * @return type 所有后代id的一维数组 */
public function Index() { //读数据库,改刀数组,循环输出 if (!($list = S('index_list'))) { //如果缓存'index_lis'不存在,则走数据库 //1st. hd_cate 中cid=0的所有数据 $db = M('cate'); $where = array('pid' => 0); $list = $db->where($where)->order('sort')->select(); $cate = $db->select(); import('Class.Category', APP_PATH); foreach ($list as $k => $v) { $cids = Category::getChildsId($cate, $v['id']); $cids[] = $v['id']; $field = array('id', 'title', 'time'); $where = array('cid' => array('IN', $cids)); //事实证明, $list[$k]['blog'] !=$v['blog'] $list[$k]['blog'] = M('blog')->order('time DESC')->field($field)->where($where)->limit('5')->select(); } S('index_list', $list, 10); //将$list(数组)缓存到'index_list'中,缓存时间一天 } $this->list = $list; $this->display(); }
public function index() { import('Class.Category', APP_PATH); import('ORG.Util.Page'); $id = (int) $_GET['id']; $cate = M('cate')->order('sort')->select(); $cids = Category::getChildsId($cate, $id); $cids = $id; $where = array('cid' => array('IN', $cids)); $count = M('blog')->where($where)->count(); $page = new Page($count, 15); $limit = $page->firstRow . ',' . $page->listRows; $this->blog = D('BlogView')->getAll($where, $limit); $this->page = $page->show(); $this->display(); }
public function index() { if (!($list = S('index_list'))) { $list = M('cate')->where(array('pid' => 0))->order('sort')->select(); import('Class.Category', APP_PATH); $cate = M('cate')->order('sort')->select(); $db = M('blog'); foreach ($list as $k => $v) { $cids = Category::getChildsId($cate, $v['id']); $cids[] = $v['id']; $where = array('cid' => array('IN', $cids)); $list[$k]['blog'] = $db->field(array('id', 'title', 'time'))->where($where)->order('time DESC')->select(); } //缓存名称 缓存数据 缓存时间10s S('index_list', $list, 10); } $this->cate = $list; $this->display(); }
public function detailsList() { import('Class.Category', './'); //引入无限极分类 import('ORG.Util.Page'); //导入分页类 $sort_id = intval($_GET['id']); //获取传过来的分类id $objDiscussSort = M('discuss_sort'); $objDiscuss = M('discuss'); $sortList = $objDiscussSort->select(); $sortList = deep_htmlspecialchars_decode($sortList); //查询输出了数据库数据之后记得反转义 $idList = Category::getChildsId($sortList, $sort_id); //传一个父ID获取所有的子ID 返回的是数组 $idList = implode(',', $idList); //把数组拆成字符串 方便下面用in查询出父ID及其子id下面的文章 $idList = $sort_id . ',' . $idList; //把当前的分类id 连接起子分类id $idList = rtrim($idList, ','); //去除右边的 逗号 $count = $objDiscuss->count(); //统计总数 $Page = new Page($count, 15); //实例化分页类 传入总记录数和每页显示的记录数 $list = $objDiscuss->alias('AS a')->join('yrq_discuss_sort AS s ON a.sort_id = s.id')->field('s.sort_name,a.*')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list = deep_htmlspecialchars_decode($list); $this->assign('list', $list); $show = $Page->show(); //分页显示输出 $this->assign('page', $show); $this->display(); }
public function detailsList() { import('Class.Category', './'); //引入无限极分类 import('ORG.Util.Page'); //导入分页类 $sort_id = intval($_GET['id']); //获取传过来的分类id $objAdSort = M('ad_sort'); $objAd = M('ad'); $sortList = $objAdSort->select(); $sortList = deep_htmlspecialchars_decode($sortList); //查询输出了数据库数据之后记得反转义 $idList = Category::getChildsId($sortList, $sort_id); //传一个父ID获取所有的子ID 返回的是数组 $idList = implode(',', $idList); //把数组拆成字符串 方便下面用in查询出父ID及其子id下面的文章 $idList = $sort_id . ',' . $idList; //把当前的分类id 连接起子分类id $idList = rtrim($idList, ','); //去除右边的 逗号 $count = $objAd->count(); //统计总数 $Page = new Page($count, 15); //实例化分页类 传入总记录数和每页显示的记录数 $list = $objAd->alias('AS a')->join('yrq_ad_sort AS s ON a.sort_id = s.id')->field('s.sort_name,a.*')->limit($Page->firstRow . ',' . $Page->listRows)->select(); $list = deep_htmlspecialchars_decode($list); //广告是否有效标记 foreach ($list as &$value) { if ($value['status'] == 0 || $value['start_time'] > mktime() || $value['end_time'] < mktime()) { $value['use_tag'] = 0; } else { $value['use_tag'] = 1; } } $this->assign('list', $list); $show = $Page->show(); //分页显示输出 $this->assign('page', $show); $this->display(); }