Jump to content

Archived

This topic is now archived and is closed to further replies.

a2bardeals

search?

Recommended Posts

i am having some trouble searching my database. the db is set up like an address book. name, address, city, state, phone, id(int) *auto_increment*  i created the db then created a php script to populate the db with entries. now i want to search those entries. i tried going this route but it returns a blank page.

of course i have a form page (search.html) that the action is set to srch.php

srch.php:

<font face="arial, helvetica" size="1">
<?

$username = "XXXXXX";
$password = "XXXXXXX";
$database = "aXXXXXXXX";
$server  = "localhost";


@mysql_connect($server,$username,$password);
@mysql_select_db($database);


?>
<?

$result = mysql_query("SELECT name, city, state, id FROM a2_bars WHERE name LIKE '".$_POST['term']."'");
if (!$result) {
echo 'Could not run query: ' . mysql_error();
exit;
}
while ($row = mysql_fetch_array($result, MYSQL_NUM)) {


printf('%s<br>%s<br><br>', $row[0], $row[1]);


}

mysql_free_result($result);


?>

Share this post


Link to post
Share on other sites
A blank page? That must be a PHP problem.

Share this post


Link to post
Share on other sites
Hi a2bardeals,

Here are a few things I would check.

1. Make sure the method in search.html is set to POST because that is what you are using in your query.
2. If that is set to POST, then you can look at your query. Try putting an actual name in that you know exists in your database.

i.e. 

$result = mysql_query("SELECT name, city, state, id FROM a2_bars WHERE name LIKE 'Bob' "); (or whatever name might exist)

3. If that gives you a result, then the problem lies with your  WHERE name LIKE '".$_POST['term']."'

Try setting a variable to your search term and using it in your query accordingly.

i.e.

$searchcontact = $_POST ['term'];

$result = mysql_query("SELECT name, city, state, id FROM a2_bars WHERE name LIKE '%$searchcontact%' ");


Also, I've found it helpful to put some html on the result page, or print out "ran successfully" after my queries during testing. That way, if the page comes up but there are no results, then you have query problems.  But, if the page is blank it's most likely a syntax error in your php somewhere.  In that case, just check your error logs.


Hope this helps you out!

Jay


Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.