select * from core_pages left join core_categories on core_pages.cid = core_categories.id where fid=1
select * from core_pages right join core_categories on core_pages.cid = core_categories.id where fid=1
public function getPagebyfid()
{
$select = $this->select()->setIntegrityCheck(false);
$select->from('core_pages', '*');
$select->join('core_categories', 'core_pages.cid = core_categories.id','');
return $result=$this->fetchAll($select);
}
结果
[0] => Array | |
( | |
[id] => 6 | |
[cid] => 3 | |
[uid] => 0 | |
[title] => 突破最薄极限 -- vivo X3 体验 | |
[body] => 2013年的手机市场犹如展开了一场“轻薄挑战 ”,手机轻薄已经是多年的热点话题,例如九年前的摩托罗拉 V3,凭借金属外壳和轻薄机身,销售量突破1.3亿台。如今的全触控智能手机少了以前实体键盘厚度所约束的硬件限制 | |
[status] => 1 | |
[createtime] => 1395517893 | |
[updatetime] => 0 | |
[comment] => 0 | |
[star] => 0 | |
[top] => 0 | |
[type] => | |
) | |
[1] => Array | |
( | |
[id] => 9 | |
[cid] => 3 | |
[uid] => 0 | |
[title] => MIUI V5 加持 MTK -- 红米手机快速上手 | |
[body] => 七月底,小米公司发布了一款名为红米的手机,与此同时这台机也引发了各种各样的热议。而其根源应该就是其799的定价吧,木头对于一台799的手机能够给用户带来怎样体验也是充满好奇,刚好近日编辑部收到一台红米手机,于是就拿来试了一试,简单与大家分享一下。 | |
[status] => 1 | |
[createtime] => 1378173793 | |
[updatetime] => 0 | |
[comment] => 0 | |
[star] => 0 | |
[top] => 0 | |
[type] => | |
) | |
[2] => Array | |
( | |
[id] => 7 | |
[cid] => 4 | |
[uid] => 0 | |
[title] => 变焦 ▪ 影像革命 -- Lumia 1020 国行联通版上手体验 | |
[body] => 现在是凌晨十二点半,我刚拿到诺基亚 Lumia 1020 拍完了一些照片,来开始敲打这篇快速上手体验。而这篇文章,大家看到的时候应该是当天中午左右了。先来回顾一下被戏称为“奥利奥”手机的 Lumia 1020 的信息,与国际 ... | |
[status] => 1 | |
[createtime] => 1378173228 | |
[updatetime] => 0 | |
[comment] => 0 | |
[star] => 0 | |
[top] => 0 | |
[type] => | |
) | |
意思:文章cid在分类表里有对应分类(id)的文章;
public function getPagebyfid()
{
$select = $this->select()->setIntegrityCheck(false);
$select->from('core_categories', '*');
$select->join('core_pages', 'core_pages.cid = core_categories.id','');
return $result=$this->fetchAll($select);
}
结果
[0] => Array | |
( | |
[id] => 3 | |
[fid] => 1 | |
[name] => 安卓 | |
[path] => 1,3 | |
) | |
[1] => Array | |
( | |
[id] => 3 | |
[fid] => 1 | |
[name] => 安卓 | |
[path] => 1,3 | |
) | |
[2] => Array | |
( | |
[id] => 4 | |
[fid] => 1 | |
[name] => 诺基亚 | |
[path] => 1,4 | |
) |
意思是
分类id在文章表中有对应cid的分类;
[0] => Array | |
( | |
[id] => 3 | |
[fid] => 1 | |
[name] => 安卓 | |
[path] => 1,3 | |
) | |
[1] => Array | |
( | |
[id] => 3 | |
[fid] => 1 | |
[name] => 安卓 | |
[path] => 1,3 | |
) | |
[2] => Array | |
( | |
[id] => 4 | |
[fid] => 1 | |
[name] => 诺基亚 | |
[path] => 1,4 | |
) |