/** * @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; }