php读取sphinx的例子

2. //检查sphinx是否能连接，不能重试两次，能则连接,不用mysql协议,仅供参考
3. function checkSphinxNoMysql() {
4. $flag = true;
5. $retries = 0;
6. while ( $flag && $retries $s = new SphinxClient ();
7. $s->setServer ( $_ENV ['db_host'], $_ENV ['current_sphinx_port'] );
8. if (! $s->open ()) {
9. //此处为如果连接不上就更改配置文件，根据项目需要来写
10. //global $configDefault;
11. //updateConfig ( $configDefault );
12. $retries ++;
13. } else {
14. $flag = false;
15. break;
16. }
17. }
18. return $s;
19. if ($retries >= 2) {
20. //sendemail or not
21. return false;
22. }
23. }
25. $order_column = 'id DESC,time DESC';//排序规则
26. //$s = checkSphinx ();
27. $s = new SphinxClient ();
28. $s->setServer ( 'sphinx_host', 'sphinx_port');
29. //以上两句代码亦可使用$s = checkSphinx ();来代替
30. $indexname = "page_keyword";//索引名字
31. $s->setMatchMode ( SPH_MATCH_PHRASE );
32. $s->SetSortMode ( SPH_SORT_EXTENDED, $order_column );
33. $s->setMaxQueryTime ( 100000 );
34. $s->setLimits ( 0, $limit_total, $limit_total );
35. $keyword_sphinx = iconv ( "gbk", "utf-8", $keyword );
36. $result = $s->query ( $keyword_sphinx, $indexname );
37. $s->close ();
38. if ($result ['total'] > 0) {
39. var_dump($result ['matches']);
40. //根据打印出的结果进行相应的读取
41. }
42. ?>

复制代码

2.采用mysql二进制网络协议的代码：

2. //检查sphinx是否能连接，不能重试两次，能则连接,用mysql14协议
3. protected function checkSphinx() {
4. $flag = true;
5. $retries = 0;
6. while ( $flag && $retries $conn = mysql_connect ( "{$_ENV ['db_host']}:{$_ENV ['current_sphinx_port']}" );
7. if (! $conn) {
8. //此处为如果连接不上就更改配置文件，根据项目需要来写
9. //global $configDefault;
10. //updateConfig ( $configDefault );
11. $retries ++;
12. } else {
13. $flag = false;
14. break;
15. }
16. }
17. if ($retries >= 2) {
18. die ( "Please contact with administrator." );
19. }
20. return $conn;
21. }
23. $order_column = 'id DESC,time DESC';//排序规则
24. $conn = mysql_connect ( "sphinx_host:sphinx_port" );
25. //以上代码亦可使用$conn = checkSphinx ();来代替
26. if (! $conn) {
27. return - 1;//连接不上返回状态
28. }
29. $keyword_sphinx = iconv ( "gbk", "utf-8", $keyword );
30. //keyword为索引名字
31. $sql = "select * from keyword where match('{$keyword_sphinx}') order by {$order_column} limit {$limit_total} option max_matches={$limit_total}";
32. $result = @mysql_query ( $sql, $conn );
34. $i = 0;
35. while ( ($row = mysql_fetch_array ( $result )) !== false ) {
36. var_dump($row);
37. //根据打印出的结果进行相应的读取
38. }
39. $totals = $this->getTotalFound ($conn);//获取总记录个数
40. ?>

复制代码

如何获取总记录个数参考：sphinxql如何得到结果数？show meta的详细说明？