Programming Forums > Web Development and Design > PHP

Arnack · Mar 26th, 2008, 1:18 PM

I put this all on index.php:

 PHP Syntax (Toggle Plain Text) 
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
error_reporting(E_ALL); 
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Name</option>
<Option VALUE="lname">Last Name</option>
<Option VALUE="info">Profile</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
error_reporting(E_ALL); 
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>

Problem is outputed as:
Notice: Undefined variable: searching in /home/arnackco/public_html/index.php on line 20

Any help please?

big_k105 · Mar 26th, 2008, 1:26 PM

The problem is your not pulling the searching variable out of the POST data.
What you need to do first is this:

 php Syntax (Toggle Plain Text) 
$searching = $_POST['searching'];
$searching = $_POST['searching'];

Put that above the if statement and it will work.

Freaky Chris · Mar 26th, 2008, 1:31 PM

Im no PHP expert but, im guessing that when the user submits the form it reloads to its own page then checks what the user entered based on the code provided.

You are trying to acces a variable $searching, which doesn't exist this is because you want the result from the previous page when it was submitted no? So since you are using the post method for the form you need to use this

 php Syntax (Toggle Plain Text) 
$searching=$_POST['searching'];
$searching=$_POST['searching'];

or just directly link it in instead of assigning it to the variable searching.

Chris

o Big K beat me, o well lol

Arnack · Mar 26th, 2008, 1:39 PM

Okay, thanks... and I tried that. Now it's bringing the error that I forgot to type something in the search for some reason.. (when I am typing in the search is still does the same thing..).

EDIT: nevermind, I saw that 'find' variable was not defined either. Now I have this code:

 PHP Syntax (Toggle Plain Text) 
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Person Shooters</option>
<Option VALUE="lname">Role PLaying Games</option>
 
<Option VALUE="info">Real Time Strategy</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
$searching = $_POST['searching'];
$find = $_POST['find'];
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Person Shooters</option>
<Option VALUE="lname">Role PLaying Games</option>

<Option VALUE="info">Real Time Strategy</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
$searching = $_POST['searching'];
$find = $_POST['find'];
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>

Now it says:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/arnackco/public_html/index.php on line 46

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/arnackco/public_html/index.php on line 58
Sorry, but we can not find an entry to match your query

big_k105 · Mar 26th, 2008, 1:58 PM

 php Syntax (Toggle Plain Text) 
<html>
<head>
	<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
	<h2>Search</h2>
	<form name="search" method="post" action="<?=$PHP_SELF?>">
		Seach for: <input type="text" name="find" /> in
		<select NAME="field">
			<option VALUE="fname">First Person Shooters</option>
			<option VALUE="lname">Role PLaying Games</option>
			<option VALUE="info">Real Time Strategy</option>
		</select>
		<input type="hidden" name="searching" value="yes" />
		<input type="submit" name="search" value="Search" />
	</form>
	<?
	$searching = $_POST['searching'];
	$find = $_POST['find'];
	//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
		mysql_select_db("arnackco_search") 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%'");
		if ($data) {
			//And we display the results
			while($result = mysql_fetch_array( $data )) {
				echo $result['fname'];
				echo " ";
				echo $result['lname'];
				echo "<br>";
				echo $result['info'];
				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;
		} else {
			echo "Error while sending query";
		}
	}
	?>
</body>
</html>
<html>
<head>
	<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
	<h2>Search</h2>
	<form name="search" method="post" action="<?=$PHP_SELF?>">
		Seach for: <input type="text" name="find" /> in
		<select NAME="field">
			<option VALUE="fname">First Person Shooters</option>
			<option VALUE="lname">Role PLaying Games</option>
			<option VALUE="info">Real Time Strategy</option>
		</select>
		<input type="hidden" name="searching" value="yes" />
		<input type="submit" name="search" value="Search" />
	</form>
	<?
	$searching = $_POST['searching'];
	$find = $_POST['find'];
	//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
		mysql_select_db("arnackco_search") 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%'");
		if ($data) {
			//And we display the results
			while($result = mysql_fetch_array( $data )) {
				echo $result['fname'];
				echo " ";
				echo $result['lname'];
				echo "<br>";
				echo $result['info'];
				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;
		} else {
			echo "Error while sending query";
		}
	}
	?>
</body>
</html>

Give this a try, I didn't test it though. All I did was add an if statement to check the $data variable before going through the results. I think you could also try changing this line $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'"); to $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'") or die("Query Error");

Arnack · Mar 26th, 2008, 2:20 PM

Alright it does print out Query Error..

big_k105 · Mar 26th, 2008, 2:39 PM

Ok, so atleast now you know there is a problem when sending your query. might want to check your SQL statement.

Change this:

 php Syntax (Toggle Plain Text) 
#
//Now we search for our search term, in the field the user specified
#
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$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%'");

to:

 php Syntax (Toggle Plain Text) 
//Now we search for our search term, in the field the user specified
$sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
echo $sql;
$data = mysql_query($sql) or die(mysql_error());
//Now we search for our search term, in the field the user specified
$sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
echo $sql;
$data = mysql_query($sql) or die(mysql_error());

This way you can see exactly what is being sent to the database.

Sane · Mar 26th, 2008, 2:41 PM

Try printing out the variables and the query before sending them off. Verify that the query and related variables are sound and correct.

Also, I'm not sure but it could matter that you had an apostraphe directly after the word 'LIKE'.

Then finally, add a mysql_error() command to see what happened.

 php Syntax (Toggle Plain Text) 
$qry = "SELECT * FROM users WHERE upper($field) LIKE '%$find%'";
echo "Query: $qry<br />Field: $field<br />Find: $find<br />";
$data = mysql_query($qry);
 
echo mysql_error();
$qry = "SELECT * FROM users WHERE upper($field) LIKE '%$find%'";
echo "Query: $qry<br />Field: $field<br />Find: $find<br />";
$data = mysql_query($qry);

echo mysql_error();

Arnack · Mar 26th, 2008, 2:45 PM

Okay. Here is my MySQL code:

 MYSQL Syntax (Toggle Plain Text) 
CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB);
 
INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" )
CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB);

INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" )

I don't see anything wrong here.. hmm..

 php Syntax (Toggle Plain Text) 
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Person Shooters</option>
<Option VALUE="lname">Role PLaying Games</option>
 
<Option VALUE="info">Real Time Strategy</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
$searching = $_POST['searching'];
$find = $_POST['find'];
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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
 
      $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
 
      echo $sql;
 
      $data = mysql_query($sql) or die(mysql_error());
 
//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>
<html>
<head>
<title>arnack.com Gaming Wesbite Database</title>
</head>
<body>
<h2>Search</h2>
<form name="search" method="post" action="<?=$PHP_SELF?>">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="fname">First Person Shooters</option>
<Option VALUE="lname">Role PLaying Games</option>

<Option VALUE="info">Real Time Strategy</option>
</Select>
<input type="hidden" name="searching" value="yes" />
<input type="submit" name="search" value="Search" />
</form>
<?
$searching = $_POST['searching'];
$find = $_POST['find'];
//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", "arnackco_Arnack", "oompa123") or die(mysql_error());
mysql_select_db("arnackco_search") 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
   
      $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'";
  
      echo $sql;
   
      $data = mysql_query($sql) or die(mysql_error());

//And we display the results
while($result = mysql_fetch_array( $data ))
{
echo $result['fname'];
echo " ";
echo $result['lname'];
echo "<br>";
echo $result['info'];
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>

error: (i typed in testsearch in the search)

SELECT * FROM users WHERE upper() LIKE'%TESTSEARCH%'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIKE'%TESTSEARCH%'' at line 1

big_k105 · Mar 26th, 2008, 2:59 PM

The problem is in your select statement. You don't have a column name after the WHERE in your select statement. Probably should look like this

 sql Syntax (Toggle Plain Text) 
SELECT * FROM users WHERE info LIKE '%searchTerm%'
SELECT * FROM users WHERE info LIKE '%searchTerm%'

so in your php it should be:

php Syntax (Toggle Plain Text)

$sql = "SELECT * FROM users WHERE info LIKE '%$find%'";

Mar 26th, 2008, 1:18 PM	#1
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 3	Simple PHP Search Script I put this all on index.php: PHP Syntax (Toggle Plain Text) <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Name</option> <Option VALUE="lname">Last Name</option> <Option VALUE="info">Profile</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? error_reporting(E_ALL); //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Name</option> <Option VALUE="lname">Last Name</option> <Option VALUE="info">Profile</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? error_reporting(E_ALL); //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> Problem is outputed as: Notice: Undefined variable: searching in /home/arnackco/public_html/index.php on line 20 Any help please? __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts. Last edited by big_k105; Mar 26th, 2008 at 1:23 PM. Reason: changed ICODE tag to CODE=PHP tag

Mar 26th, 2008, 1:26 PM	#2
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,613 Rep Power: 10	Re: Simple PHP Search Script The problem is your not pulling the searching variable out of the POST data. What you need to do first is this: php Syntax (Toggle Plain Text) $searching = $_POST['searching']; $searching = $_POST['searching']; Put that above the if statement and it will work. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Mar 26th, 2008, 1:31 PM	#3
Freaky Chris Hobbyist Programmer Join Date: Dec 2007 Location: England Posts: 169 Rep Power: 1	Re: Simple PHP Search Script Im no PHP expert but, im guessing that when the user submits the form it reloads to its own page then checks what the user entered based on the code provided. You are trying to acces a variable $searching, which doesn't exist this is because you want the result from the previous page when it was submitted no? So since you are using the post method for the form you need to use this php Syntax (Toggle Plain Text) $searching=$_POST['searching']; $searching=$_POST['searching']; or just directly link it in instead of assigning it to the variable searching. Chris o Big K beat me, o well lol

Mar 26th, 2008, 1:39 PM	#4
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 3	Re: Simple PHP Search Script Okay, thanks... and I tried that. Now it's bringing the error that I forgot to type something in the search for some reason.. (when I am typing in the search is still does the same thing..). EDIT: nevermind, I saw that 'find' variable was not defined either. Now I have this code: PHP Syntax (Toggle Plain Text) <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Person Shooters</option> <Option VALUE="lname">Role PLaying Games</option> <Option VALUE="info">Real Time Strategy</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Person Shooters</option> <Option VALUE="lname">Role PLaying Games</option> <Option VALUE="info">Real Time Strategy</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> Now it says: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/arnackco/public_html/index.php on line 46 Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/arnackco/public_html/index.php on line 58 Sorry, but we can not find an entry to match your query __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 1:58 PM	#5
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,613 Rep Power: 10	Re: Simple PHP Search Script php Syntax (Toggle Plain Text) <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <select NAME="field"> <option VALUE="fname">First Person Shooters</option> <option VALUE="lname">Role PLaying Games</option> <option VALUE="info">Real Time Strategy</option> </select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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%'"); if ($data) { //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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; } else { echo "Error while sending query"; } } ?> </body> </html> <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <select NAME="field"> <option VALUE="fname">First Person Shooters</option> <option VALUE="lname">Role PLaying Games</option> <option VALUE="info">Real Time Strategy</option> </select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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%'"); if ($data) { //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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; } else { echo "Error while sending query"; } } ?> </body> </html> Give this a try, I didn't test it though. All I did was add an if statement to check the `$data` variable before going through the results. I think you could also try changing this line `$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'");` to `$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$find%'") or die("Query Error");` __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Mar 26th, 2008, 2:20 PM	#6
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 3	Re: Simple PHP Search Script Alright it does print out Query Error.. __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 2:39 PM	#7
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,613 Rep Power: 10	Re: Simple PHP Search Script Ok, so atleast now you know there is a problem when sending your query. might want to check your SQL statement. Change this: php Syntax (Toggle Plain Text) # //Now we search for our search term, in the field the user specified # $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE'%$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%'"); to: php Syntax (Toggle Plain Text) //Now we search for our search term, in the field the user specified $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); //Now we search for our search term, in the field the user specified $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); This way you can see exactly what is being sent to the database. __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Mar 26th, 2008, 2:41 PM	#8
Sane Programming Guru Join Date: Apr 2005 Posts: 1,788 Rep Power: 5	Re: Simple PHP Search Script Try printing out the variables and the query before sending them off. Verify that the query and related variables are sound and correct. Also, I'm not sure but it could matter that you had an apostraphe directly after the word 'LIKE'. Then finally, add a mysql_error() command to see what happened. php Syntax (Toggle Plain Text) $qry = "SELECT * FROM users WHERE upper($field) LIKE '%$find%'"; echo "Query: $qry<br />Field: $field<br />Find: $find<br />"; $data = mysql_query($qry); echo mysql_error(); $qry = "SELECT * FROM users WHERE upper($field) LIKE '%$find%'"; echo "Query: $qry<br />Field: $field<br />Find: $find<br />"; $data = mysql_query($qry); echo mysql_error(); __________________ Waterloo's Canadian Computing Competition (CCC) - Stage 2 Problems, Solutions, and Test Data

Mar 26th, 2008, 2:45 PM	#9
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 3	Re: Simple PHP Search Script Okay. Here is my MySQL code: MYSQL Syntax (Toggle Plain Text) CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB); INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" ) CREATE TABLE users (fname VARCHAR(30), lname VARCHAR(30), info BLOB); INSERT INTO users VALUES ( "Jim", "Jones", "In his spare time Jim enjoys biking, eating pizza, and classical music" ), ( "Peggy", "Smith", "Peggy is a water sports enthusiast who also enjoys making soap and selling cheese" ),( "Maggie", "Martin", "Maggie loves to cook itallian food including spagetti and pizza" ),( "Tex", "Moncom", "Tex is the owner and operator of The Pizza Palace, a local hang out joint" ) I don't see anything wrong here.. hmm.. php Syntax (Toggle Plain Text) <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Person Shooters</option> <Option VALUE="lname">Role PLaying Games</option> <Option VALUE="info">Real Time Strategy</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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 $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> <html> <head> <title>arnack.com Gaming Wesbite Database</title> </head> <body> <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="fname">First Person Shooters</option> <Option VALUE="lname">Role PLaying Games</option> <Option VALUE="info">Real Time Strategy</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? $searching = $_POST['searching']; $find = $_POST['find']; //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", "arnackco_Arnack", "oompa123") or die(mysql_error()); mysql_select_db("arnackco_search") 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 $sql = "SELECT * FROM users WHERE upper($field) LIKE'%$find%'"; echo $sql; $data = mysql_query($sql) or die(mysql_error()); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['fname']; echo " "; echo $result['lname']; echo "<br>"; echo $result['info']; 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> error: (i typed in testsearch in the search) SELECT * FROM users WHERE upper() LIKE'%TESTSEARCH%'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') LIKE'%TESTSEARCH%'' at line 1 __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 2:59 PM	#10
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,613 Rep Power: 10	Re: Simple PHP Search Script The problem is in your select statement. You don't have a column name after the WHERE in your select statement. Probably should look like this sql Syntax (Toggle Plain Text) SELECT * FROM users WHERE info LIKE '%searchTerm%' SELECT * FROM users WHERE info LIKE '%searchTerm%' so in your php it should be: php Syntax (Toggle Plain Text) $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; __________________ BIG K aka Kyle Programming Forums Kyle K Online Please do not PM or email me programming questions. Post them in the forums instead.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

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

Programming Forums > Web Development and Design > PHP

Simple PHP Search Script