search script

[chinni_77]

Hello everybody,

The following search script I'm using inorder to search for the keywords in the articles table.If the keywords are found, I display the article names.When I run this code in my pc its absolutely working fine, but when i copy this into my server and test it, it always display the empty string message.I also noticed in the browser that it searches for the query word which I've given but, it does'nt actually display the results.For ex: when I search for the keyword "optical", I could see something like the following:

http://...admin/search1.php?q=optical&Submit=Search

Could somebody please tell me what would be the error???

Thanks for your time

<?php

// Get the search variable from URL

   $var = @$_GET['q'] ;
//trim whitespace from the stored variable  

   $trimmed = trim($var); 
//rows to return
   $limit=10 ; 

// check for an empty string and display a message.
   if ($trimmed == "")
   {
   echo "<p>Please enter a search...</p>";
   exit;
   }

// check for a search parameter
  if (!isset($var))
  {
  echo "<p>You dont seem to have a search parameter!</p>";
  exit;
  }
//connect to your database 
  mysql_connect("localhost","myadmin",""); 

//specify database 
  mysql_select_db("volatile") or die("Unable to select database"); 


// Build SQL Query  

 $query = "select ARTICLE_NAME, ARTICLE_CONTENT FROM articles WHERE ARTICLE_KEYWORDS LIKE '%".$trimmed."%' order by ARTICLE_ID"; 
 $numresults=mysql_query($query)or die (mysql_error());
 $numrows=mysql_num_rows($numresults);

// If we have no results, offer a google search as an alternative

  if ($numrows == 0)
  {
  echo "<h4>Results</h4>";
  echo "<p>Sorry, your search: &quot;" . $trimmed . "&quot; returned zero results</p>";

// google
  echo "<p><a href=\"http://www.google.com/search?q=" 
  . $trimmed . "\" target=\"_blank\" title=\"Look up 
  " . $trimmed . " on Google\">Click here</a> to try the search on google</p>";
  }

// next determine if s has been passed to script, if not use 0
  if (empty($s)) {
  $s=0;
  }

// get results
  $query .= " limit $s,$limit";
  $result = mysql_query($query) or die("Couldn't execute query");

// display what the person searched for
  echo "<p>You searched for: &quot;" . $var . "&quot;</p>";

// begin to show results set
  echo "Results";
  $count = 1 + $s ;

// now you can display the results returned
  echo "<table width=\"80%\">";
  echo "<table border=\"1\">";  

  while ($row= mysql_fetch_array($result)) {
  $title = $row["ARTICLE_NAME"];

echo "<tr>"; 
//  echo "<td width=\"5%\" valign=\"top\">"; 
//  echo "$count.)</td>" ; 
    echo "<td width=\"95%\"><a href='".$row[ARTICLE_CONTENT]."'>".$title."</a></td>"; 
    echo "</td></tr>"; 
//  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }
  echo "</table>";
  $currPage = (($s/$limit) + 1);

//break before paging
  echo "<br />";

  // next we need to do the links to other results
  if ($s>=1) { 
  // bypass PREV link if s is 0
  $prevs=($s-$limit);
  print "&nbsp;<a href=\"$PHP_SELF?s=$prevs&q=$var\">&lt;&lt; 
  Prev 10</a>&nbsp&nbsp;";
  }

// calculate number of pages needing links
  $pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from division

  if ($numrows%$limit) {
  // has remainder so add one page
  $pages++;
  }


// check to see if last page
  if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

  // not last page so give NEXT link
  $news=$s+$limit;

  echo "&nbsp;<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 &gt;&gt;</a>";
  }

  $a = $s + ($limit) ;
  if ($a > $numrows) { $a = $numrows ; }
  $b = $s + 1 ;
  echo "<p>Showing results $b to $a of $numrows</p>";

?>

[xblue]

versions? keep in mind that <4.1 doesn't support the $_GET syntax, only $HTTP_GET_VARS - and I know some hosts still use such old versions, mine has only upgraded recently.

[jassh]

some book i read recommend using the long style type of variables...

$HTTP_VARS_GET is adviceable..
but i think it will be deprecated in the future..