<?php
|
|
/**
|
* 文章列表
|
*/
|
define('IN_ECS', true);
|
require('includes/init.php');
|
|
$cat_id = isset($_REQUEST['cat_id']) ? intval($_REQUEST['cat_id']) : 0;
|
$page=$_GET['page']*10;
|
|
$cat_id_list=$cat_id;
|
|
if(!empty($cat_id)){
|
$sql = "SELECT * FROM " .$ecs->table('article_cat'). " WHERE parent_id='$cat_id' ";
|
$cat_List=$db->getAll($sql);
|
for($i=0;$i<count($cat_List);$i++){
|
$cat_id_list.=",".$cat_List[$i]['cat_id'];
|
$cat_id1=$cat_List[$i]['cat_id'];
|
$sql = "SELECT * FROM " .$ecs->table('article_cat'). " WHERE parent_id ='$cat_id1' ";
|
$cat_List2=$db->getAll($sql);
|
for($j=0;$j<count($cat_List2);$j++){
|
$cat_id_list.=",".$cat_List2[$j]['cat_id'];
|
}
|
}
|
}
|
|
$res = $db -> getAll("SELECT article_id,title FROM ".$ecs->table('article')." WHERE cat_id in($cat_id_list) AND is_open=1 order by article_id asc LIMIT $page,10;");
|
|
|
print_r(json_encode($res));
|
|
?>
|
