if(isset($_GET['search_text']))
$search_txt = $_GET['search_text'];
else
$search_txt = $_POST['search_text'];

?>
error_reporting(E_All);

if(isset($_POST['search_text']) || isset($_GET['search_text'])){

if(isset($_GET['search_text']))
$search_txt = $_GET['search_text'];
else
$search_txt = $_POST['search_text'];

//alpha clean, then wrap for sql
$clean_search = preg_replace(‘/[^\w\s]+/’,”,$search_txt);
$search_list = explode(‘ ‘,$clean_search);
if(count($search_list) > 1){
$where_list = implode(‘”,”‘,$search_list);
//$where_list = substr($where_clause,0,strlen($where_clause)-1);
}
else
{
$where_list = $search_list[0];
}

$sql_count = ‘SELECT count(*) FROM search_data WHERE keyword IN (“‘.$where_list.’”) GROUP BY link’;
//echo $sql_count;
include(‘search_dbcreds.php’);

$rs_count = mysql_query($sql_count);
$total_results = mysql_num_rows($rs_count);
$row_count = 10;

if (!(isset($_GET['pagenum'])))
$pagenum = 1;
else
$pagenum = $_GET['pagenum'];

//This tells us the page number of our last page
$last = ceil($total_results/$row_count);

//this makes sure the page number isn’t below one, or more than our maximum pages
if ($pagenum < 1)
{
$pagenum = 1;
}
elseif ($pagenum > $last)
{
$pagenum = $last;
}

//This sets the range to display in our query
$max = ‘limit ‘ .($pagenum – 1) * $row_count .’,’ .$row_count;
$sql_sponsored = ‘SELECT link,description,title FROM search_data WHERE sponsored = 1 AND keyword IN (“‘.$where_list.’”) GROUP BY link LIMIT 3′;
$sql = ‘SELECT link,description,title FROM search_data WHERE keyword IN (“‘.$where_list.’”) GROUP BY link ‘.$max;

$rs = mysql_query($sql_sponsored);
if(mysql_num_rows($rs)>0){
echo ‘

‘;
$j =1;
while($line = mysql_fetch_assoc($rs)){
include(‘results_stub.tpl’);
$j++;
}
}
echo ‘

‘;

if($total_results >0){
$rs = mysql_query($sql);
$j =1;
while($line = mysql_fetch_assoc($rs)){

$results_desc_length = 400;
$description = $line['description'];

$desc_len = strlen($description);
$description = substr($description,0,$results_desc_length);
if ($desc_len > 200) {
$description .= “…”;
}
$description = str_replace($search_txt,”“.$search_txt.”“,$description);
include(‘search_results_stub.tpl’);
$j++;
}

}
else{
echo “No matches found. Perhaps try a different search.”;
$last = 1;
}
if($last != 1){
echo ‘Pages: ‘;
for($i=1;$i<($last+1);$i++){
echo ‘‘.$i.’ | ‘;
}
}

}

?>