PHP - Trying To Get A Simple Php Sql Search To Work

Hi everyone,

Would someone be able to help me out here, I cannot get this to work.
Basically I have 3 pages, I with a search box which then run's a search script to display the results.  Then the results are clickable, the idea is when the user clicks the result it takes them to another page which I want to display the info from the database.....if that makes sense, but when the link is clicked nothing is displaying.

So here is what I have done so far:

index.php - This is the page with the search box, code is :
Code: [Select]
<?php
$dbhost = 'localhost';
$dbuser = '*********';
$dbpass = '********';

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');

$dbname = '***********';
mysql_select_db($dbname);
?>
<form name="form" action="search.php" method="get">
  <input type="text" name="q" />
  <input type="submit" name="Submit" value="Search" />
</form>

When they hit submit it takes them to the results page, code is:
Code: [Select]
<?php

  // Get the search variable from URL
  $var = @$_GET['q'] ;
  $trimmed = trim($var); //trim whitespace from the stored variable

// 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>We dont seem to have a search parameter!</p>";
  exit;
  }

//connect to your database ** EDIT REQUIRED HERE **
mysql_connect("localhost","********","********"); //(host, username, password)

//specify database ** EDIT REQUIRED HERE **
mysql_select_db("**********") or die("Unable to select database"); //select which database we're using

// Build SQL Query  
$query = "select * from Fish where Commonn like \"%$trimmed%\"  
  order by Commonn"; // EDIT HERE and specify your table and field names for the SQL query

 $numresults=mysql_query($query);
 $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<br><br>";
$count = 1 + $s ;

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["Commonn"];

  echo "$count.)&nbsp;<a href='info.php?ID=$ID'>$title</a>" ;
  $count++ ;
  }

$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>";
  
?>

When they click the results from this page it takes them to another page which should (but doesnt) display the info from the mysql database, code is:

Code: [Select]
<?php


// now you can display the results returned


  echo "$title" ;



?>


Im really sorry if this is obvious or if I have dont something completely wrong but im very new to php and trying to learn on the job.

Many Thanks in advance

Jay

Good evening,

I am a newbie when it comes to programming, and I am yet learning. With several help from this forum, and other websites, I am able to finish my very first PHP project. It worked fine, as well as the search engine. However, it is foreseen that the application will be utilizing huge amount of data which would require pagination when viewing. And so I found a tutorial from php freaks as well. However, after I integrated the codes from my web application, the search engine suddenly stopped working. It is still, when I leave the field blank, which would display all data. However, if I type down a search query on the field, it still displays all data. Can anyone help me on this? Here's my complete code:

<link href="add_client.css" rel="stylesheet" type="text/css">

<?PHP
include("dbconnection.php");

$query = "SELECT * FROM records";


if(isset($_POST["btnSearch"]))

{
$query .= " WHERE last_name LIKE '%".$_POST["search"]."%' OR first_name LIKE '%".$_POST["search"]."%'OR territory LIKE '%".$_POST["search"]."%'OR job_title LIKE '%".$_POST["search"]."%'OR title LIKE '%".$_POST["search"]."%'OR employer LIKE '%".$_POST["search"]."%' ORDER BY territory ASC"  ;

$result = mysql_query($query, $connection) or die(mysql_error());

} 

?>

<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="199" align="center" valign="top"><a href="login.html"><img src="invent-asia.gif" alt="" width="152" height="58" border="0" /></a>        <script type="text/javascript" src="menu.js"></script></td>
        <td width="176" align="right" valign="bottom"><a href="main.php"><img src="Home.jpg" width="104" height="20" border="0"/></a></td>
        <td width="130" align="right" valign="bottom"><img src="View.jpg" width="104" height="20" border="0"/></td>
        <td width="146" align="right" valign="bottom"><a href="add_client.php"><img src="Add.jpg" width="104" height="20" border="0"/></a></td>
        <td width="109" align="right" valign="bottom">&nbsp;</td>
        </tr>

    </table></td>
  </tr>
  <tr>
    <td><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" height="3"  bgcolor="#1B1C78"><img src="images/topspacerblue.gif" alt="" width="1" height="3" /></td>
        <td width="560"  bgcolor="#0076CC"><img src="images/topspacerlblue.gif" alt="" width="1" height="3" /></td>

      </tr>
    </table></td>

  </tr>
  <tr>
    <td height="553" align="center" valign="top" bgcolor="#F3FAFE"><br />

      <form name="form" action="view_client.php" method="post">
        <br />
      <table width="351" border="0">
          <tr>
            <td width="137" align="left" valign="middle">SEARCH RECORD:</td>
            <td width="144" align="center" valign="middle"><input type="text" name="search" /></td>
            <td width="56" align="left" valign="middle"><input type="submit" name="btnSearch" value="Search" /></td>
          </tr>
        </table>
        <br />
        <table border="0" cellpadding="3" cellspacing="1" bordercolor="38619E" >
          <tr>
            <th width="80" align="center" bgcolor="#E0E8F3">Territory</th>
            <th width="330" align="center" bgcolor="#E0E8F3">Employer</th>
             <th width="160" align="center" bgcolor="#E0E8F3">Name</th>
            <th width="80" align="center" valign="middle" bgcolor="#E0E8F3">&nbsp;</th>
          </tr>
<?php

$conn = mysql_connect('localhost','root','') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('invent-asia',$conn) or trigger_error("SQL", E_USER_ERROR);


$sql = "SELECT COUNT(*) FROM records";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];


$rowsperpage = 10;

$totalpages = ceil($numrows / $rowsperpage);


if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

   $currentpage = (int) $_GET['currentpage'];
} else {

   $currentpage = 1;
}


if ($currentpage > $totalpages) {

   $currentpage = $totalpages;
}

if ($currentpage < 1) {

   $currentpage = 1;
} 


$offset = ($currentpage - 1) * $rowsperpage;


$sql = "SELECT * FROM records LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);


if($result)
  {
  for($i=0; $i<mysql_num_rows($result); $i++)
  {
  $id = trim(mysql_result($result, $i, "id"));
  $territory = trim(mysql_result($result, $i, "territory"));
  $employer = trim(mysql_result($result, $i, "employer"));
  $first_name = trim(mysql_result($result, $i, "first_name"));
  $last_name = trim(mysql_result($result, $i, "last_name"));
  
     echo "<td>".$territory."</td>";
  echo "<td>".$employer."</td>";
  echo "<td>".$last_name.", ".$first_name."</td>";
  echo "<td><a href='edit_client.php?id=".$id."'>edit</a> | <a href='delete_client.php?id=".$id."'>delete</a> </td>";
  echo "</tr>";
  }
  }


$range = 3;


if ($currentpage > 1) {

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";

   $prevpage = $currentpage - 1;

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} 


for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

   if (($x > 0) && ($x <= $totalpages)) {

      if ($x == $currentpage) {

         echo " [<b>$x</b>] ";

      } else {

         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } 
   }
} 
                 
       
if ($currentpage != $totalpages) {

   $nextpage = $currentpage + 1;

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";


}

?>


  
        </table>
        <p>
<br />
        </p>
      </form>
    <p>&nbsp;</p></td>

  </tr>
  <tr>
    <td height="38"><table width="760" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="200" height="35" align="center"  bgcolor="#1B1C78" class=white><img src="images/topspacerblue.gif" alt="" width="1" height="3" />&nbsp;<a href="disclaimer.html"><font color="#FFFFFF">Legal Disclaimer</font></a> </td>

        <td width="560" align="center"  bgcolor="#0076CC"  class=white><img src="images/topspacerlblue.gif" alt="" width="1" height="3" />&nbsp;Copyright &copy; 2006 - 2010 InventAsia Limited. All rights reserved.
</td>
      </tr>

    </table></td>
  </tr>
</table>

Immediate response is very well appreciated. Thank you very much ^^

As per the code below I am trying to create a search page which enable people to search different databases in a simple method.  However, the code searches each other.

So if I put "What is your name?" into "Questions" it shows:

Questions: "What is your name?"
Answer:  "Sorry, but we can not find an entry to match your query"

But I am not searching the Answer database so it should just remain blank and should show:

Questions: "What is your name?"
Answer:  (Blank)

Does anyone know why it is doing this?
Code: [Select]
<h2>Questions</h2>
 <form name="search" method="post" action="<?=$PHP_SELF?>">
 Seach for: <input type="text" name="find" /> in
 <Select NAME="field">
 <Option VALUE="category">Category</option>
 <Option VALUE="question">Question</option>
 <Option VALUE="notes">Notes</option>
 </Select>
 <input type="hidden" name="searching" value="yes" />
 <input type="submit" name="search" value="Search" />
 </form>
 

 <?
 //This is only displayed if they have submitted the form
 if ($searching =="yes")
 {
 echo "<h2>Results</h2><p>";
 
 //If they did not enter a search term we give them an error
 if ($find == "")
 {
 echo "<p>You forgot to enter a search term";
 exit;
 }
 

 // We preform a bit of filtering
 $find = strtoupper($find);
 $find = strip_tags($find);
 $find = trim ($find);
 
 //Now we search for our search term, in the field the user specified
 $data = mysql_query("SELECT * FROM questions WHERE upper($field) LIKE'%$find%'");
 
 //And we display the results
 while($result = mysql_fetch_array( $data ))
 {
 echo $result['category'];
 echo " <br>" ;
 echo $result['question'];
 echo "<br>";
 echo $result['notes'];
 echo "<br>";
 echo "<br>";
 }
 
 //This counts the number or results - and if there wasn't any it gives them a little message explaining that
 $anymatches=mysql_num_rows($data);
 if ($anymatches == 0)
 {
 echo "Sorry, but we can not find an entry to match your query<br><br>";
 }
 
 //And we remind them what they searched for
 echo "<b>Searched For:</b> " .$find;
 }

// close connection
mysql_close();
 ?>








<h2>Answers</h2>
 <form name="search" method="post" action="<?=$PHP_SELF?>">
 Seach for: <input type="text" name="find" /> in
 <Select NAME="field">
 <Option VALUE="answer">Answer</option>
 </Select>
 <input type="hidden" name="searching" value="yes" />
 <input type="submit" name="search" value="Search" />
 </form>
 

 <?
 //This is only displayed if they have submitted the form
 if ($searching =="yes")
 {
 echo "<h2>Results</h2><p>";
 
 //If they did not enter a search term we give them an error
 if ($find == "")
 {
 echo "<p>You forgot to enter a search term";
 exit;
 }
 
  // We preform a bit of filtering
 $find = strtoupper($find);
 $find = strip_tags($find);
 $find = trim ($find);
 
 //Now we search for our search term, in the field the user specified
 $data = mysql_query("SELECT * FROM answers WHERE upper($field) LIKE'%$find%' LIMIT 0,10 ");
 
 //And we display the results
 while($result = mysql_fetch_array( $data ))
 {
 echo $result['answer'];
 echo " <br>";
 }
 
 //This counts the number or results - and if there wasn't any it gives them a little message explaining that
 $anymatches=mysql_num_rows($data);
 if ($anymatches == 0)
 {
 echo "Sorry, but we can not find an entry to match your query<br><br>";
 }
 
 //And we remind them what they searched for
 echo "<b>Searched For:</b> " .$find;
 }
 ?>

OK, I am new to PHP
I am wanting to create a property search using drop down boxes.
I have a database with 4 main fields to search: Bedrooms (beds), Area (area), Price Range (price) and Type (type)
Here is the code so far, can someone please correct it. Thanks...

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<?php

  // Get the search variable from URL
  $var1 = @$_GET['beds'] ;
  $var2 = @$_GET['area'] ;
  $var3 = @$_GET['price'] ;
  $var4 = @$_GET['type'] ;
  $trimmed = trim($var1, $var2, $var3, $var4);

// rows to return
$limit=10;

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

// check for a search parameter
if (!isset($var1))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

$host = "localhost";
$username = "root";
$password = "";
//connect to your database ** EDIT REQUIRED HERE **
$link = mysql_connect($host, $username, $password) or die("Unable to connect to SQL Server"); //(host, username, password)

$db = "property_db";
//specify database ** EDIT REQUIRED HERE **
mysql_select_db($db, $link) or die("Unable to select database"); //select which database we're using

// Build SQL Query

$results = mysql_query("SELECT * FROM house_src", $link);
$numresults = mysql_num_rows($results);



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

// display what the person searched for
echo "<p>You searched for: ". $var4 . "property, with ". $var1 . " bedrooms, in the " . $var2 . "area, with a price range of " . $var3 ."";

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

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$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>";
 
?>

OK, I am new to PHP
I am wanting to create a property search using drop down boxes.
I have a database with 4 main fields to search: Bedrooms (beds), Area (area), Price Range (price) and Type (type)
Here is the code so far, can someone please correct it. Thanks...
******************************
When I run it it says:

Warning: trim() expects at most 2 parameters, 4 given in C:\wamp\www\search222.php on line 8

Warning: mysql_query() expects parameter 1 to be string, resource given in C:\wamp\www\search222.php on line 45

Couldn't execute query

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

<?php

  // Get the search variable from URL
  $var1 = @$_GET['beds'] ;
  $var2 = @$_GET['area'] ;
  $var3 = @$_GET['price'] ;
  $var4 = @$_GET['type'] ;
  $trimmed = trim($var1, $var2, $var3, $var4);

// rows to return
$limit=10;

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

// check for a search parameter
if (!isset($var1))
  {
  echo "<p>We dont seem to have a search parameter!</p>";
  exit;
  }

$host = "localhost";
$username = "root";
$password = "";
//connect to your database ** EDIT REQUIRED HERE **
$link = mysql_connect($host, $username, $password) or die("Unable to connect to SQL Server"); //(host, username, password)

$db = "property_db";
//specify database ** EDIT REQUIRED HERE **
mysql_select_db($db, $link) or die("Unable to select database"); //select which database we're using

// Build SQL Query

$results = mysql_query("SELECT * FROM house_src", $link);
$numresults = mysql_num_rows($results);



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

// display what the person searched for
echo "<p>You searched for: ". $var4 . "property, with ". $var1 . " bedrooms, in the " . $var2 . "area, with a price range of " . $var3 ."";

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

// now you can display the results returned
  while ($row= mysql_fetch_array($result)) {
  $title = $row["1st_field"];

  echo "$count.)&nbsp;$title" ;
  $count++ ;
  }

$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>";
 
?>