PHP search page problem

j8r8c8 · January 24, 2008

Anybody have any idea why this script produces a duplicate result for each keyword entered into the search form?

<html>

<?php

include ("../_borders/top.htm");

//This script searches 2 MySql fields

$address = $_SERVER['PHP_SELF'];

$hostname_logon = "****" ;

$database_logon = "****" ;

$username_logon = "****" ;

$password_logon = "****" ;

//open database connection

$connections = mysql_connect($hostname_logon, $username_logon, $password_logon) or die ( "Unabale to connect to the database" );

//select database

mysql_select_db($database_logon) or die ( "Unable to select database!" );

//specify how many results to display per page

$limit = 20;

// Get the search variable from URL

$var = @$_GET['q'] ;

//trim whitespace from the stored variable

$trimmed = trim($var);

//separate key-phrases into keywords

$trimmed_array = explode(" ",$trimmed);

// check for an empty string and display a message.

if ($trimmed == "") {

$resultmsg = "<p>Search Error</p><p>Please enter a search...</p>" ;

}

// check for a search parameter

if (!isset($var)){

$resultmsg = "<p>Search Error</p><p>We don't seem to have a search parameter! </p>" ;

}

// Build SQL Query for each keyword entered

foreach ($trimmed_array as $trimm){

// SQL Query

$query = "SELECT * FROM parts_search WHERE partno LIKE '%". $trimm ."%' OR description LIKE '%". $trimm ."%' ORDER BY partno" ;

// Execute the query to get number of rows that contain search kewords

$numresults=mysql_query ($query);

$row_num_links_main = mysql_num_rows ($numresults);

// next determine if 's' has been passed to script, if not use 0.

// 's' is a variable that gets set as we navigate the search result pages.

if (empty($s)) {

$s=0;

}

// now let's get results.

$query .= " LIMIT $s,$limit" ;

$numresults = mysql_query ($query) or die ( "Couldn't execute query" );

$row= mysql_fetch_array ($numresults);

//store record id of every item that contains the keyword in the array we need to do this to avoid display of duplicate search result.

do{

$adid_array[] = $row[ 'id' ];

}while( $row= mysql_fetch_array($numresults));

} //end foreach

if($row_num_links_main == 0 && $row_set_num == 0){

$resultmsg = "<p>Search results for:" . $trimmed ."</p><p>Sorry, your search returned zero results</p>" ;

}

//delete duplicate record id's from the array. To do this I will use array_unique function

$tmparr = array_unique($adid_array);

$i=0;

foreach ($tmparr as $v) {

$newarr[$i] = $v;

$i++;

}

// Display the results returned. But first we will display the search form on the top of the page

?>

<p align="center"><b><span lang="en-us"><font size="5"><a href="../index.htm">Home</a> </font><font color="#0000FF" size="2">●</font><font size="5"> <a href="../search.htm">Search</a> </font><font color="#0000FF" size="2">●</font><font size="5"> <a href="../site_map.htm">Index</a> </font><font color="#0000FF" size="2">●</font><font size="5">

<a href="../New%20Parts.htm">New Parts</a> </font><font color="#0000FF" size="2">●</font><font size="5">

<a href="../Preowned-Parts.htm">Preowned-Parts</a> </font><font color="#0000FF" size="2">●</font><font size="5">

<a href="../christmas_ideasUnder30.htm">Christmas Ideas</a> </font><font color="#0000FF" size="2">●</font><font size="5">

<a href="../technical.htm">Technical</a> </font><font color="#0000FF" size="2">●</font><font size="5"> <a href="../Race_Team.htm">

Race Team</a> </font><font color="#0000FF" size="2">●</font><font size="5"> <a href="../winter_rebuild.htm">Winter Rebuild</a> </font><font color="#0000FF" size="2">●</font><font size="5">

<a href="../Contact_Us.htm">Contact Us</a></font></span></b></p>

</div>

</form>

<?php

// display what the person searched for.

if( isset ($resultmsg)){

echo $resultmsg;

exit();

}else{

echo "Search results for: " . "$var";

echo "<br>";

}

echo "<body background=\"../Logos/GoodVibeLogo1989rev.JPG\">

<table width=100%>";

foreach($newarr as $value){

$query_value = "SELECT * FROM parts_search WHERE id = '$value'";

$num_value=mysql_query ($query_value);

$row_linkcat= mysql_fetch_array ($num_value);

$row_num_links= mysql_num_rows ($num_value);

//now let's make the keywods bold. To do that we will use preg_replace function.

$url = $row_linkcat[ 'url' ];

$part_num = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'partno' ] );

$description = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'description' ] );

$reg_price = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'reg_price' ] );

$your_price = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'your_price' ] );

$weight = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'weight' ] );

$vendor = preg_replace ( "'($var)'si" , "<b>\\1</b>" , $row_linkcat[ 'vendor' ] );

$url_f = sprintf ("%s",$url);

$filename = sprintf("../Product-Scans-NonDesc/%s_small.JPG",$url_f);

if (file_exists($filename)) {

$pic = getimagesize($filename,$size);

if ($pic[0] > $pic[1]) {

$sizew = (80);

$sizeh = round($pic[1] / $pic[0] * 80);

} elseif ($pic[0] < $pic[1]) {

$sizew = round($pic[0] / $pic[1] * 80);

$sizeh = (80);

} else if ($pic[0] == $pic[1]) {

$sizew = (80);

$sizeh = (80);

} else {

$sizew=$pic[0];

$sizeh=$pic[1];

}

foreach($trimmed_array as $trimm){

if($trimm != 'b' ){

$part_num = preg_replace( "'($trimm)'si" , "<b>\\1</b>" , $part_num);

$description = preg_replace( "'($trimm)'si" , "<b>\\1</b>" , $description);

}

//end highlight

?>

<?php echo "<tr><td rowspan=2 width=10%>

<font size=4 face=Verdana color=red><strong>$part_num</strong></font>&nbsp&nbsp

<font face=Arial>$description</font>

<font color=blue size=5 face=Verdana><strong>\$$your_price</strong></font>

</td></tr>

"; ?><?php

}

} //end foreach $newarr

echo "</table>";

//end foreach $trimmed_array

if($row_num_links_main > $limit){

// next we need to do the links to other search result pages

if ($s>=1) { // do not display previous link if 's' is '0'

$prevs=($s-$limit);

echo "<div align='left'><a href='$PHP_SELF?s=$prevs&q=$var&catid=$catid'>Previous " .$limit. "</a></div>";

}

// check to see if last page

$slimit =$s+$limit;

if (!($slimit >= $row_num_links_main) && $row_num_links_main!=1) {

// not last page so display next link

$n=$s+$limit;

echo "<div align='right'><a href='$PHP_SELF?s=$n&q=$var&catid=$catid'>Next " .$limit. "</a></div>";

}

echo "There were $row_num_links_main returned results";

?></html>

Thanks in advance for any assistance.

j8r8c8

Sign In

PHP search page problem

Recommended Posts

j8r8c8

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information