<?php
//Here is an example of using the Sphinx api client
$server = "192.168.0.100:3306";
$username = "johnsmith";
$password = "Password1";
$database = "customers";
function newSQL() {
global $server, $username, $password, $database;
$con = new mysqli($server, $username, $password, $database);
return $con;
}
include('sphinxapi.php');
$search = '@postcode 2012';
$s = new SphinxClient;
$s->SetServer("192.168.0.100", 9312);
$s->SetMatchMode(SPH_MATCH_EXTENDED2);
$s->SetSortMode (SPH_SORT_EXTENDED,'@random');
$s->SetLimits(0, $times);
$index = 'main:delta';
$result = $s->Query($search, $index);
if ($result['total'] > 0) {
foreach ($result['matches'] as $id => $other) {
$people .= "pid=$id OR ";
}
$people = substr($people, 0, -4);
}
$mysqli = newSQL();
$mysqliResult = $mysqli->query("SELECT `pid`, `name`, `postcode` FROM `profiles` WHERE ($people)");
//Do something with $mysqliResult
$mysqli->close();
?>
SphinxClient::setServer
(PECL sphinx >= 0.1.0)
SphinxClient::setServer — Set searchd host and port
Description
public SphinxClient::setServer
( string
$server
, int $port
) : boolSets searchd host name and TCP port. All subsequent requests will use the new host and port settings. Default host and port are 'localhost' and 3312, respectively.
Parameters
-
server -
IP or hostname.
-
port -
Port number.
Return Values
Returns TRUE on success or FALSE on failure.
add a note
User Contributed Notes 1 note
craig dot constable at gmail dot com ¶
11 years ago
