SphinxClient::setServer

(PECL sphinx >= 0.1.0)

SphinxClient::setServer — Set searchd host and port

Description

public bool SphinxClient::setServer ( string $server , int $port )

Sets 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.

User Contributed Notes

craig dot constable at gmail dot com

3 years ago


<?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();
?>