<?php
$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)");
$mysqli->close();
?>