public function getSearchResult($keyword) { $keywords = getSegmentation($keyword); foreach ($keywords as $v) { } }
/** * 在指定的表中对指定的字段进行关键词的模糊查询 * * @keyword string 关键词 会自动进行分词 * @table string 表名 * @keys string 字段名 可以多个 'name|abstract|detail' * @return array 查询结果集,二维数组 */ function getSearchResult($keyword, $table, $keys, $limit = '10', $where = array()) { //先分词 $keywords = getSegmentation($keyword); $sql = D($table); $rs = array(); $like = array(); foreach ($keywords as $v) { $like[] = '%' . $v . '%'; } $map[$keys] = array('like', $like); if ('Landscape' == $table) { $rs = $sql->where($map)->limit($limit)->where($where)->cache(true)->myselect(); } else { $rs = $sql->where($map)->limit($limit)->where($where)->cache(true)->select(); } return $rs; }