public function _category($catid)
{
$catid = str_replace("category_","",$catid);
$catid=(int) $catid;
$search='';
if(!empty($catid)){
$sortpath=$this->db->fetch_one("select sort_path from ".WEBMENG_CONMENG."category_record where cat_id='".$catid."' ");
$search.=" and catid in(select cat_id from ".WEBMENG_CONMENG."category_record where sort_path like '".$sortpath."%') ";
}
$sql = "select *,thumb as img,inputtime as addtime from ".WEBMENG_CONMENG."record where catid='".$catid."' order by inputtime desc ";
$all_record = page_for_db_extend($sql); //查询带分页的
$data = array(
'info_reslut' => $all_record['data'],
'showpage' => $all_record['page'],
'category' => $this->_category_record()
);
$settings = array();
$sets = $this->db->fetch("select * from ".WEBMENG_CONMENG."settings ");
if(!empty($sets)){
foreach ($sets as $v) {
$webmeng[$v['variable']] = $v;
}
}
$data['webmeng'] = $webmeng; /*获取内页调用系统信息如LOGO 网站名称*/
$this->display('record/category.html',$data);
}
public function _category_record()
{
$record_list = $this->db->fetch("select cat_name as sortname,cat_id as id,parent_id from ".WEBMENG_CONMENG."category_record ");
$category = array();
$parent = array();
if(!empty($record_list)){
foreach ($record_list as $v) {
if($v['parent_id']==0){
$category[] = $v;
}
$parent[$v['parent_id']][]=$v;
}
foreach ($category as $k => $v) {
$category[$k]['child'] = isset($parent[$v['id']])?$parent[$v['id']]:array();
if(!empty($category[$k]['child'])){
foreach ($category[$k]['child'] as $key => $value) {
$category[$k]['child'][$key]['child'] = isset($parent[$value['id']])?$parent[$value['id']]:array();
}
}
}
}
return $category;
}
关于航天之星|SPACESTAR俱乐部
