/**
* @name getList
* @param $cate 栏目名称
* @package 获取单个栏目内容
* @return array or false
*/
private function getList($c_id, $page, $keywords = "", $limit = 10)
{
$select = "article_id,c_id,title,title_pic,keywords,abstract,add_time,out_time,source,author,link,color";
$order = "add_time desc,sortrank desc";
$start = ($page - 1) * 10;
$limits = $start . "," . $limit;
$where = "WHERE c_id in(" . $c_id . ") AND is_display=1 ";
if ($c_id == 0) {
$where = "WHERE 1=1 ";
}
if (!empty($keywords)) {
$where .= " and (";
$KArray = explode(" ", $keywords);
foreach ($KArray as $key => $v) {
$where .= " title like '%" . $v . "%' or ";
$where .= " keywords like '%" . $v . "%'";
}
$where .= " )";
}
$format = "SELECT %s FROM " . DB_PRE . "article %s order by %s limit %s";
$sql = sprintf($format, $select, $where, $order, $limits);
//echo $sql."<br />";
$result = parent::FetchArray($sql);
return $result;
}
