php search code error - Irish SEO, Marketing & Webmaster Discussion

Keewee6 · #1 (**permalink**) 20-02-2008, 06:51 PM

heres the error

Search For

Seach for: in Events Day
Results

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/squarebar/domains/nixysthesquarebar.com/public_html/search.php on line 44

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/squarebar/domains/nixysthesquarebar.com/public_html/search.php on line 56
Sorry, but we can not find an entry to match your query

Searched For: SATURDAY

here is the code

<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body>
<h2>Search For</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<option value="events">Events</option>
<option value="day">Day</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?php
//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;
}
// Otherwise we connect to our Database
mysql_connect("localhost", "squarebar", "square462") or die(mysql_error());
mysql_select_db("squarebar_db1") or die(mysql_error());
// 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 users WHERE upper($field) LIKE'%$find%'");
//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['date'];
echo " ";
echo $result['day'];
echo "<br>";
echo $result['events'];
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;
}
?>
</body>
</html>

any help would be good

louie · #2 (**permalink**) 20-02-2008, 08:42 PM

compare with how you make a db connection to how it's shown here:

PHP MySQL Select

and you will notice the mistake.

ghost · #3 (**permalink**) 20-02-2008, 09:32 PM

Quote:

Originally Posted by Keewee6

mysql_connect("localhost", "squarebar", "square462") or die(mysql_error());
mysql_select_db("squarebar_db1") or die(mysql_error());

It is also better to put your db connection in a separate file and include it on your working pages.
like this

PHP Code:

  $host = 'localhost';
$user = 'squarebar';
$pass = 'square462';
$db = 'squarebar_db1';
$con = mysql_connect($host, $user, $pass) or die('ERROR: I Cant find the database!');
mysql_select_db($db) or die('ERROR: still Cant find it fix my db config file!');

in your working page do an

include('config.php');
If your Data base ever changes you will only need to make changes in one place

Forbairt · #4 (**permalink**) 20-02-2008, 09:58 PM

also not the best idea to post these details on a public site

Giving us your domain name ... your database username / password ... and so on

ghost · #5 (**permalink**) 20-02-2008, 10:24 PM

yes , but with his new bd include file he can change them every day

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ruby on Rails VS PHP Code Igniter	gav240z	Coding Help	10	03-02-2008 11:04 PM