微微族

private $port;

private $db;

private $indexs;

private $searchd;

private $keywords;

private $total;

function __construct($db = null, $host = ‘localhost‘, $port = 3312, $indexs = “cmsindex|addcmsindex“)
{
if ($db === null)?{
global $db;
}
$this->host = $host;
$this->port = $port;
$this->db = $db;
$this->indexs = $indexs;
$index = explode(“|“, $this->indexs);
$this->mainIndex = $index[0];
$this->searchd = new SphinxClient();
$this->searchd->setServer($this->host, $this->port);
$this->searchd->setMatchMode(SPH_MATCH_EXTENDED);
}

function setLimits($page = 1, $limit = 10)
{
$offset = ($page - 1) * $limit;
$this->searchd->setLimits($offset, $limit, 1000);
return $this;
}

function setWhere($field, $value)
{
if (!is_array($value))?{
$value = array($value);
}
$this->searchd->setFilter($field, $value);
return $this;
}

/**
*?set?how?to?sort?the?search?result.
*
*?@param?int?$mode?SPH_SORT_ATTR_DESC?or?SPH_SORT_ATTR_ASC
*?@param?string?$sortby?sort?field.
*/
function setSortMode($sortby = ‘postdate‘, $mode = SPH_SORT_ATTR_DESC)
{
$this->searchd->setSortMode(SPH_SORT_ATTR_DESC, $sortby);
return $this;
}

function find($query)
{
$result = $this->searchd->query($this->prepare($query), $this->indexs);
$ids = array_keys($result['matches']);
unset($result['matches']);
$this->total = $result['total'];
if (empty($ids))?{
return false;
}
$data = $this->fetchContents($ids);
return $data;
}

function getTotal()
{
return $this->total;
}

function getList($query, $page = 1, $sortby = null, $limit = 10, $sort_mode = SPH_SORT_ATTR_DESC)
{
$this->setLimits($page);
if ($sortby)?{
$sort_mode = empty($sort_mode) ? SPH_SORT_ATTR_DESC : $sort_mode;
$this->setSortMode($sortby, $sort_mode);
}
if ($result = $this->find($query))?{
$this->buildExcerpts($result, “content“);
$this->buildExcerpts($result, “title“);
}
return $result;
}

function buildExcerpts(&$data, $field = “content“)
{
$contents = array();
foreach ($data as $item)
{
$item = trim(strip_tags($item[$field]));
$contents[] = preg_replace(“/\s+/“, “”, $item);
}
$contents = $this->searchd->buildExcerpts($contents, $this->mainIndex, $this->keywords);
foreach ($data as $k => &$v)?{
$v[$field] = $contents[$k];
}
return $data;
}

/**
*?fetch?content?from?database;
*
*?@param?array?$ids??tids
*?@return?array??search?result
*/
private function fetchContents($ids)
{
$q = “SELECT?th.tid,th.cid,?th.title,?th.postdate,?th.hits,?t.content,?t.author,?th.linkurl?,?th.url
FROM?cms_contentindex?th
LEFT?JOIN?cms_content1?t
USING?(tid)
WHERE?th.tid?in?(“ . implode(“,“, $ids) . “)“;

$result = $this->db->query($q);
$data = array();

$score = array_flip($ids);
$score_sort = array();
while ($line = $this->db->fetch_array($result))
{
$line['score'] = $score[$line['tid']];
$data[] = $line;
$score_sort[] = $line['score'];
}
array_multisort($score_sort, SORT_ASC, SORT_NUMERIC, $data);
return $data;
}

/**
*?prepare?the?search?query,?and?then?use?SPH_MATCH_EXTENDED?mode?to?query.
*
*?@param?string?$query?string?to?search
*?@return?string?of?extend?style.
*/
private function prepare($query)
{
$keywords = $this->searchd->buildKeywords($query, $this->mainIndex, false);
$query = array();
foreach ($keywords as $key)?{
$query[] = $key["tokenized"];
}

$query = implode(“|“, $query);
$query = iconv(“utf-8“, “gbk“, $query);
$this->keywords = $query;
return $query;
}
}
?>

$search = new Cms_Search_API($db);
$page = 1;
$sortby = ‘postdate‘; //hits?or?null
$search->setWhere(“cid“, 5);
$result = $search->getList(“提升6-12个月宝宝记忆力的游戏“, $page, $sortby);
print_r($result);
?>