PHP search help please?

M

Mat

New member
OK, trying to make a search for my site using drop downs, here is what I got so far...

**********************************************************************html
<html>
<form action='search222.php' method='GET'>
<center>
<p><font size="5" face="sans-serif"><br>
<label for="beds"></label>
Bedrooms:
<select name="beds" id="beds">
<option>1</option>
<option>2</option>
<option>3</option>
<option>4</option>
<option>5</option>
</select></font></p>
<p><font size="5" face="sans-serif">Area:
<select name="area" id="area">
<option>Calderdale</option>
<option>Kirklees</option>
</select>
</font></p>
<p><font size="5" face="sans-serif">
<input type='submit' name='submit' value='Search'>
</font></p>
</center>

</form>
</html>

********************************************************************php
<?php

// Get the search variable from URL
$var1 = @$_GET['beds'] ;
$var2 = @$_GET['area'] ;
$trimmed = trim($var1); //trim whitespace from the stored variables

// 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;
}

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

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

// Build SQL Query
$query = "SELECT * FROM property_db"; // EDIT HERE and specify your table and field names for the SQL query

$numresults=mysql_query($query);

// 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: "" . $var1 . ", " . $var2 . ""</p>";

// 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.)*$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 "*<a href=\"$PHP_SELF?s=$prevs&q=$var\"><<
Prev 10</a>&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 "*<a href=\"$PHP_SELF?s=$news&q=$var\">Next 10 >></a>";
}

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

?>

********************************************************
I run this and it says could not execute query, can someone modify/correct pls, would be very greatful! :) Thanks
Yeah, this is just a test on my apache localhost not online, sorry hackers!
This is the line that is causing trouble...

$numresults = mysql_num_rows($results);

it says: "Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\search222.php on line 39
 
Back
Top