Help needed for new AJAX search snippet

I have struggled to get the AJAX search snippet to work very well for my site, it runs very slow with AJAX on or off.

As a result I have got a replacement for this that has been written in PHP outside of MODX, at present it Connects to the DB, queries the content table and returns search results in a nice AJAX format with paginated results.

The only problem is that it pulls out any results in the Content table regardless of them being published or not.

<?php

$username = "username";
$password = "password";
$hostname = "localhost";
$database = "dbase";

mysql_connect($hostname, $username, $password) or die(mysql_error());
mysql_select_db($database) or die(mysql_error());

$table_name = "modx_site_content"; //which table from database
$first_field = "pagetitle"; //which field from table
$second_field = "introtext"; //which field from table
$limitchar = 4; //minimum of characters
$records_number = 10; // Number of records to show per page (different from 0)
$page_number = 1;// default start page

// file for database connection
include(’../assets/templates/clean/inc/db.inc.php’);

// configuration file
include(’../assets/templates/clean/inc/config.inc.php’);

if(isset($_GET[’p’])) {
$page_number = $_GET[’p’];
$arraySearch = $_GET[’terms’];
$show_count = $_GET[’count’];
settype($page_number, ’integer’);
}
$nospaces = substr($_GET[’terms’],0,4);
$offset = ($page_number - 1) * $records_number;
// check for an empty string and display a message.
if ($_GET[’terms’] == "") {
echo ’<div id="counter">eg. write &acute;book and&acute; or &acute;science fiction&acute; without quotes.</div>’;
// minim 3 characters condition
} else if(strlen($_GET[’terms’]) < $limitchar) {
echo ’<div id="counter">’. $limitchar .’ characters minimum</div>’;
// no spaces in first 4 letters
} else if(preg_replace(’/[a-zA-Z0-9]/’, ’’, $nospaces)) {
echo ’<div id="counter">Please use letters or numbers in first 4 characters</div>’;
} else {

// explode search words into an array
$arraySearch = explode(" ", $_GET[’terms’]);
// table fields to search
$arrayFields = array(0 => $first_field, 1 => $second_field);
$countSearch = count($arraySearch);
$a = 0;
$b = 0;
$query = "SELECT * FROM $table_name WHERE (";
$countFields = count($arrayFields);
while ($a < $countFields)
{
while ($b < $countSearch)
{
$query = $query."$arrayFields[$a] LIKE ’%$arraySearch[$b]%’";
$b++;
if ($b < $countSearch)
{
$query = $query." AND ";
}
}
$b = 0;
$a++;
if ($a < $countFields)
{
$query = $query.") OR (";
}
}
$query = $query.") LIMIT $offset, $records_number;";
$search = mysql_query($query);


// get number of search results
$arrayFields = array(0 => $first_field, 1 => $second_field);
$countSearch = count($arraySearch);
$a = 0;
$b = 0;
$query = "SELECT * FROM $table_name WHERE (";
$countFields = count($arrayFields);
while ($a < $countFields)
{
while ($b < $countSearch)
{
$query = $query."$arrayFields[$a] LIKE ’%$arraySearch[$b]%’";
$b++;
if ($b < $countSearch)
{
$query = $query." AND ";
}
}
$b = 0;
$a++;
if ($a < $countFields)
{
$query = $query.") OR (";
}
}
$query = $query.")";
$count_results = mysql_query($query);
$numrows = mysql_num_rows($count_results);

// no results
if($numrows == 0) {
echo ’<div id="counter">No results found</div>’;

// show results
} else {

echo ’<div id="results">
<div id="results_top"><p><b>’. $_GET[’terms’] .’</b> - ’. $numrows .’ results found</p></div>
’;

while($row = mysql_fetch_assoc($search)) {

$urltitle = str_replace(" ","_", $row[’alias’]);

echo ’<div class="item">
<div class="details">
<a href="’.$urltitle.’.htm" class="title">’.$row[’pagetitle’].’</a>

’.$row[’introtext’].’</div>
<div style="clear:both;"></div></div>’;
}
// pagination
$maxPage = ceil($numrows/$records_number);

$nav = ’’;
for($page = 1; $page <= $maxPage; $page++) {
if ($page == $page_number) {
$nav .= "$page";
}
else
{
$nav .= "<a href=\"javascript:htmlData(’search.php’,’terms=".$_GET[’terms’]."&amp;p=$page’)\">$page</a>";
}
}

if ($page_number > 1) {

$page = $page_number - 1;
$prev = "<a href=\"javascript:htmlData(’search.php’,’terms=".$_GET[’terms’]."&amp;p=$page’)\">&laquo;</a>";

$first = "<a href=\"javascript:htmlData(’search.php’,’terms=".$_GET[’terms’]."&amp;p=1’)\">First</a>";
}
else {
$prev = ’’;
$first = ’’;
}

if ($page_number < $maxPage) {
$page = $page_number + 1;
$next = "<a href=\"javascript:htmlData(’search.php’,’terms=".$_GET[’terms’]."&amp;p=$page’)\">&raquo;</a>";

$last = "<a href=\"javascript:htmlData(’search.php’,’terms=".$_GET[’terms’]."&amp;p=$maxPage’)\">Last</a>";
}
else {
$next = ’’;
$last = ’’;
}
echo $data;
echo "<div id=\"results_bottom\"><p>$first $prev $nav $next $last</p></div>
</div>";
}
}
?>

function GetXmlHttpObject(handler)
{
var objXMLHttp=null
if (window.XMLHttpRequest)
{
objXMLHttp=new XMLHttpRequest()
}
else if (window.ActiveXObject)
{
objXMLHttp=new ActiveXObject("Microsoft.XMLHTTP")
}
return objXMLHttp
}

function stateChanged()
{
if (xmlHttp.readyState==4 || xmlHttp.readyState=="complete")
{
// show_results will be filled with new page
document.getElementById("show_results").innerHTML = xmlHttp.responseText
}
else {
//alert(xmlHttp.status);
}
}

function htmlData(url, terms, pag)
{
if (url.length==0)
{
document.getElementById("show_results").innerHTML = "";
return;
}

xmlHttp = GetXmlHttpObject();

if (xmlHttp==null)
{
alert ("Browser does not support HTTP Request");
return;
}

url=url+"?"+terms+"&amp;"+pag;
url=url+"&sid="+Math.random();
xmlHttp.onreadystatechange = stateChanged;
xmlHttp.open("GET",url,true) ;
xmlHttp.send(null);
}

search_id = ’’;
function handleHttpResponse() {
if (http.readyState == 4) {
if (search_id != ’’) {
document.getElementById(search_id).innerHTML = http.responseText;
}
}
}
function getHTTPObject() {
var xmlhttp;
if (!xmlhttp && typeof XMLHttpRequest != ’undefined’) {
try {
xmlhttp = new XMLHttpRequest();
} catch (e) {
xmlhttp = false;
}
}
return xmlhttp;
}
var http = getHTTPObject();

function getScriptPage(div_id,terms_id,get_count,get_p) {
search_id = div_id;
zearch = document.getElementById(terms_id).value;
http.open("GET", "search.php?terms=" + escape(zearch)+"&count="+get_count+"&page="+get_p, true);
http.onreadystatechange = handleHttpResponse;
http.send(null);
}

<!-- begin content -->
<div id="searchcontent">
<img src="../assets/templates/clean/images/search_form.png" width="240" height="32" alt="search form" />
<!-- begin form -->
<div id="form">
<input type="text" id="terms" size="40" onkeyup="getScriptPage(’show_results’,’terms’,’1’)" onblur="if ( this.value == ’’ ) this.value = this.defaultValue" onfocus="if ( this.value == this.defaultValue ) this.value = ’’" value="type your search here" /></div><!-- end form -->
</div><!-- end content -->

$query = "SELECT * FROM $table_name WHERE (";

$query = "SELECT * FROM $table_name WHERE (published=1) AND (searchable=1) AND (deleted=0) AND (privateweb=0) AND (";

The AjaxSearch snippet would take 30-40 seconds (or even more sometimes) to process a search, which is a long time for a visitor to wait, and it does load a fairly large library.

This run with no other parameters set other than debug, as you can see it’s pretty slow, including going to the next / previous page,

but also the results it displays aren’t always the best either, for example if you search for "hylton smith" you get 43 results, but in reality (and reflected in the search I am currently using) there are only 5 pages that are actually relevant.

---- &advSearch [ ’exactphrase’ | ’allwords’ | ’nowords’ | ’oneword’ ] (optional)

Advanced search
- exactphrase : provides the documents which contain the exact phrase
- allwords : provides the documents which contain all the words
- nowords : provides the documents which do not contain the words
- oneword : provides the document which contain at least one word [default]