ThinkPHP - 博客获取列表信息

得到数据:

Array
(
[0] => Array
(
[id] => 5
[name] => PHP
[pid] => 0
[sort] => 1
[blog] =>
) [1] => Array
(
[id] => 2
[name] => DIV+CSS
[pid] => 0
[sort] => 2
[blog] => Array
(
[0] => Array
(
[id] => 1
[title] => 这是一条测试文章
[time] => 1455717047
) ) ) [2] => Array
(
[id] => 3
[name] => JavaScript
[pid] => 0
[sort] => 3
[blog] => Array
(
[0] => Array
(
[id] => 2
[title] => jquery博文
[time] => 1455763110
) [1] => Array
(
[id] => 4
[title] => 博文博文
[time] => 1455869366
) ) ) [3] => Array
(
[id] => 4
[name] => Apache
[pid] => 0
[sort] => 4
[blog] =>
) [4] => Array
(
[id] => 1
[name] => HTML
[pid] => 0
[sort] => 5
[blog] =>
) [5] => Array
(
[id] => 6
[name] => Linux
[pid] => 0
[sort] => 6
[blog] =>
) [6] => Array
(
[id] => 7
[name] => 其他
[pid] => 0
[sort] => 7
[blog] =>
) )

代码:

Public function index() {
//获取所有父类分类
$FaCate = M('Cate')->where(array('pid'=>0))->order('sort')->select(); //获取所有分类
$allCate = M('Cate')->order('sort')->select(); // 引入分类类文件
import('Class.Category', APP_PATH); $db = M('Blog');
$field = array('id', 'title', 'time');//取出的字段
foreach ($FaCate as $key => $value) {
//根据父类id,获取子类id
$cids = Category::getChildsId($allCate, $value['id']);
//连同父类id一起放入数组,输出的结果是,父类id以及其下的所有子类id
$cids[] = $value['id']; //根据查询出的id,查找博文表blog,获取博文数据,将博文数据放入Facate数组中的blog子数组中。
$whe = array('cid'=>array('IN', $cids));//博文表中的查询条件,cid IN ('', '', '')
//将查询除的数据放入blog数组中
$FaCate[$key]['blog'] = $db->field($field)->where($whe)->select();//不能进行排序
} print_r($FaCate);die; $this->cate = $FaCate; $this->display();
}

效果:

ThinkPHP - 博客获取列表信息

上一篇:30道小学生四则运算题C/C++编程


下一篇:C#版(击败100.00%的提交) - Leetcode 151. 翻转字符串里的单词 - 题解