PHP - Search Script Returning Incorrect Results

Just finished a search script. However, when type two keywords it will return duplicate entries:

Code: [Select]
elseif(isset($_GET['search'])){
$search=$_POST['search'];
$search=str_replace(" ", ".", $search);
header("Location: ./index.php?q=".$search);
}
elseif(isset($_GET['q'])){
$search=$_GET['q'];
$keywords=explode(".",$search);
$sql10000="SELECT product_id FROM $tbl_name2 WHERE keyword LIKE '%" . implode("%' OR keyword LIKE '%",$keywords) . "%'";
$result10000=mysql_query($sql10000);
if(mysql_num_rows($result10000)==0){
$content='<div class="center">Search found no results.</div>';
}
else{
while($row10000=mysql_fetch_array($result10000)){
$product_id3=$row10000['product_id'];
$sql15000="SELECT * FROM $tbl_name WHERE product_id=".$product_id3;
$result15000=mysql_query($sql15000);
while($row15000=mysql_fetch_array($result15000)){
extract($row15000);
$content.=$product_name;
}
}
}
}

I have 3 products:
Test2 - microphone
Test3 - audio, microphone
Test123 - audio

When you search "audio" you get:
Test3, Test123

When you search "microphone" you get:
Test2, Test3

When you search "audio microphone" you get:
Test2, Test3, Test3, Test123
with Test3 being a duplicate.

Is there anyway to correct this? I tried SELECT DISTINCT * FROM, but there's no difference in the results returned, from what I have now.

Hi all,

I am new to PHP and am trying to implement a window that opens when a user is trying to validate an organisation on our site. I have an initial page where users can enter data. One of the fields is organisations. This has a button to its right that lets the user search existing organisations in the mysql db.

I have the search piece thanks to some code I found and altered.

However, instead of a static non-linked list 1,2,3 coming back from the search, I need the search results to be links / or at least "select"-able. When the user chooses the organisation they were referring to that exists in the db I would like the selection to go back to the original php page and populate the organisation field. Ideally without having other data in the original form being lost.

Any tips, hints or links would be greatly appreciated.

Here is my code:

<?php

$dbHost = 'localhost';
$dbUser = 'root';
$dbPass = 'mypass';
$dbDatabase = 'mydb';
$con = mysql_connect($dbHost, $dbUser, $dbPass) or trigger_error("Failed to connect to MySQL Server. Error: " . mysql_error());

mysql_select_db($dbDatabase) or trigger_error("Failed to connect to database {$dbDatabase}. Error: " . mysql_error());

// Set up our error check and result check array
$error = array();
$results = array();

// First check if a form was submitted.
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
   $searchTerms = trim($_GET['search']);
   $searchTerms = strip_tags($searchTerms); // remove any html/javascript.
   
   if (strlen($searchTerms) < 3) {
      $error[] = "Search terms must be longer than 3 characters.";
   }else {
      $searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
   }
   
   // If there are no errors, lets get the search going.
   if (count($error) < 1) {
      $searchSQL = "SELECT Organisation_Name FROM vcaccount_contact_organisation WHERE ";
     
      // grab the search types.
      $types = array();
      $types[] = isset($_GET['Organisation_Name'])?"`Organisation_Name` LIKE '%{$searchTermDB}%'":'';

     
      $types = array_filter($types, "removeEmpty"); // removes any item that was empty (not checked)
     
      if (count($types) < 1)
         $types[] = "`Organisation_Name` LIKE '%{$searchTermDB}%'"; // use the body as a default search if none are checked
     
          $andOr = isset($_GET['matchall'])?'AND':'OR';
      $searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `Organisation_Name`"; // order by organisation.

      $searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
     
      if (mysql_num_rows($searchResult) < 1) {
         $error[] = "The search term provided {$searchTerms} yielded no results.";
      }else {
         $results = array(); // the result array
         $i = 1;
         while ($row = mysql_fetch_assoc($searchResult)) {
            $results[] = "{$i}: {$row['Organisation_Name']}<br /><br />";
            $i++;
         }
      }
   }
}

function removeEmpty($var) {
   return (!empty($var));
}
?>
<html>
   <title>My Simple Search Form</title>
   <style type="text/css">
      #error {
         color: red;
      }
   </style>
   <body>
      <?php echo (count($error) > 0)?"The following had errors:<br /><span id=\"error\">" . implode("<br />", $error) . "</span><br /><br />":""; ?>
      <form method="GET" action="<?php echo $_SERVER['PHP_SELF'];?>" name="searchForm">
         Organisation: <input type="text" name="search" value="<?php echo isset($searchTerms)?htmlspecialchars($searchTerms):''; ?>" /><br />
                 <input type="submit" name="submit" value="Search!" />
      </form>
      <?php echo (count($results) > 0)?"Your search term: {$searchTerms} returned:<br /><br />" . implode("", $results):""; ?>
   </body>
</html>

I have a simple (1 table, 14 fields) database. I'm using 9 separate search boxes from my search page :
http://www.cinemaposter.com/database.html
There are currently 162 entries. Hitting "submit" throws them all out, same with valid input into any box, with the exception of "country" - example  : entering "F" gives 20results; "PL" gives 34 results.
Here's my code (to simplify, I only went down to the 4th box ('country' - the last and only one giving correct results).  I'm one sorry newbie.... please help !
Here's the code :
------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"
"http://www.w3.org/TR/1998/REC-html40-19980424/loose.dtd">
<html>
<head>
   <title>Search Results</title>
   <meta name="generator" content="BBEdit 6.5">
   <style type="text/css">
td
{
   color: #000000;
   font-family: arial;
   font-size: 10px;
}
</style>
</head>
<body>
<?php
$link = mysql_connect("xxxx", "xxxx", "xxxx") or die("Could not connect");
///print "Connected successfully<BR>";
mysql_select_db("xxxx") or die("Could not select database");


{
$Author = $_POST['Author'];
$sql = "SELECT * FROM posters WHERE Author LIKE '%$Author%'";
}

{
$Title = $_POST['Title'];
$sql = "SELECT * FROM posters WHERE Title LIKE '%$Title%'";
}

{
$Originaltitle =$_POST['Originalitle'];
$sql="SELECT * FROM posters WHERE Originaltitle LIKE '%$Originaltitle%'";
}

{
$Country =$_POST['Country'];
$sql="SELECT * FROM posters WHERE Country LIKE '%$Country%'";
}


$result = mysql_query ($sql) or die("Query failed : " . mysql_error());
$numrs = mysql_num_rows($result);

if ($numrs > 0){

if ($numrs==1){
   print ("<p><font face=\"Arial\"><b>There is $numrs record in our database.</B> <BR><BR>");
   }elseif($numrs>1){
   print ("<p><font face=\"Arial\"><b>There are $numrs records in our database. </B><BR><BR>");//Apparently, he wan't to be able to search again...</b><form method \"POST\" action=\"$PHP_SELF\">Search Again:");
   }
   
   
   
   
  echo("<a href='javascript:history.go(-1)'>Go Back</a></p>");
  print("<P align=center>Click on the column heading links to sort the results.<br><br />");   
   
print ("<TABLE CELLPADDING=\"1\" CELLSPACING=\"2\" BORDER=\"0\">\n");
PRINT ("<TR BGCOLOR=\"#FFFF77\">
<TD COLSPAN=2><P align=center>Author</td>
<TD><P align=center>Title</TD>
<TD><P align=center>Original Title</TD>
<TD><P align=center>Country</TD>
<TD><P align=center>Director</TD>
<TD><P align=center>Cast</TD>
<TD><P align=center>Year</TD>
<TD><P align=center>Original Year</TD>
<TD><P align=center>Photo</TD>
<TD><P align=center>Producer</TD>
<TD><P align=center>Circulation</TD>
<TD><P align=center>Size</TD>
<TD><P align=center>Print type</TD>
<TD><P align=center>Remarks</TD></TR>");

$z=1;
      while ($line = mysql_fetch_array($result)) {
      
         $num=$z++;
         //Note here that I'm assigning the found objects new names (indicated by lowercase) to that php wont get confused.....
         $auth=$line['Author'];
         $title=$line['Title'];
         $originaltitle=$line['Originaltitle'];
         $country=$line['Country'];
         $director=$line['Director'];
         $cast=$line['Cast'];
         $year=$line['Year'];
         $originalyear=$line['Originalyear'];
         $producer=$line['Producer'];
         $circ=$line['Circulation'];
         $size=$line['Size'];
         $print=$line['Print'];
         $remarks=$line['Remarks'];
         $pict=$line['Picture'];


         //Set the formatting
         $bgcolor = ($i++ & 1) ? '#d3d3d3' : '#c0c0c0';
         
                           
      PRINT("<TR BGCOLOR=$bgcolor>
      <TD>$num.</TD>
      <TD>$auth</td>
      <TD>$title</TD>
      <TD>$originaltitle</TD>
      <TD><P align=center>$country</TD>
      <TD>$director</TD>
      <TD>$cast</TD>
      <TD><P align=center>$year</TD>
      <TD><P align=center>$originalyear</TD><TD>");
// This is the test to find do we have a picture
if ($pict) {
// If there is a picture, display it:
print ("<P align=center><a href='zdjecie.php?zdj= $pict&autor=$auth&opis=$title&orig=$originaltitle&rok=$year' target='_blank'>
<img src=$pict height=\"150\"></a>");
} else {

// We don't have a picture, so we print some text instead:
print ("<P align=center>no picture available");
}

print ("</TD><TD>$producer</TD>
<TD><P align=center>$circ</TD>
<TD>$size</TD>
<TD>$print</TD>
<TD>$remarks</TD></TR>");
            
         }
      PRINT("</TABLE><BR><font face=\"Arial\"><a href=\"javascript:history.go(-1);\">Search Again</a></font>");
   }else {
   print ("<font face=\"Arial\">Sorry, there were no results for your search. <a href=\"javascript:history.go(-1);\">Please try again</a></font>");
   }
//mysql_close($link);
?>                                                                     
</body>
</html>

Currently I have 5 entries in my table.

Entring this query displays all five in the correct order.

Code: [Select]
SELECT * FROM products ORDER BY count DESC LIMIT 16


However, using this code, the first result is omitted and the last four are displayed.



$query="SELECT * FROM products ORDER BY count DESC LIMIT 16";
$result = mysql_query($query);
$row = mysql_fetch_array($result);

echo '<div>';
while ($row = mysql_fetch_array($result))
{
echo '<div>'.$row[product].'</div> <div>'.$row[count].'</div>';
}
echo '</div>';



Can someone help me find my error?
Thanks

Ok, so I have a bit of code but it's not working as it should, would one of you guys have a look at it and let me know where I'm going wrong?

Basically I need to be able to input several words or terms into the text area, each on a separate line and have the results displayed something like:

hello: 23,000.000
hello world: 19,000,000
world: 278,000,000

I also see that the script is not searching the words / terms inside quotes (EG. "hello world")

TIA

Code: [Select]
<html>
<body>
<?php
function my_fetch($url,$user_agent='Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)')
{
$ch = curl_init();
curl_setopt ($ch, CURLOPT_URL, $url);
curl_setopt ($ch, CURLOPT_USERAGENT, $user_agent);
curl_setopt ($ch, CURLOPT_HEADER, 0);
curl_setopt ($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt ($ch, CURLOPT_REFERER, 'http://www.google.com/');
$result = curl_exec ($ch);
curl_close ($ch);
return $result;
}

$s = $_GET['s'];
if (isset($s))
{
echo "<p><i>Search for $s</i></p>";
    $s = urlencode($s);
    $data = my_fetch("http://www.google.com/search?hl=en&q=" . $s . "&btnG=Google+Search");

    $data = strip_tags($data);

    $find = 'Results 1 - 10 of about ';
    $find2 = ' for';

    $data = strstr($data, $find);

    $pos = strpos($data, $find2);


$search_number=substr($data,strlen($find), $pos-strlen($find));

echo "Total Results: $search_number";
}
else
{
?>

<form name="form1" id="form1" method="get" action="">
<div align="left">
<p>  <textarea name="s" type="text" id="s" rows="8" style="width:60%" /></textarea><br />
<input type="submit" name="Submit" value="Results" /></p>
Put "" around the string: <input type="checkbox" checked name="apos" value="true" /><br />
</div>
</form>
<p>
<?php
}
?>
</p>
</body>
</html>