php读取sphinx的例子

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

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

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

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