Programming Forums > Web Development and Design > PHP

Arnack · Mar 26th, 2008, 3:13 PM

Okay, done.
Now I get this error:
SELECT * FROM users WHERE info LIKE '%HELLO%'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 '%HELLO%'' at line 1

With 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
 
      $sql = "SELECT * FROM users WHERE info LIKE '%$find%'";
 
      echo $sql;
 
      $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") 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 info LIKE '%$find%'";
  
      echo $sql;
   
      $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") 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>

this is the code in the mysql database

 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" )

big_k105 · Mar 26th, 2008, 3:31 PM

Look at line 49 of the code that you just posted.
Looks like this:

 php Syntax (Toggle Plain Text) 
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or  die(mysql_error());
$data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or  die(mysql_error());

should be:

 php Syntax (Toggle Plain Text) 
$data = mysql_query($sql) or die(mysql_error());
$data = mysql_query($sql) or die(mysql_error());

Right now you aren't using the $sql variable that you used to change the sql statement.

Arnack · Mar 26th, 2008, 3:50 PM

Ahh okay, I got it now. No errors anymore- now just this:

SELECT * FROM users WHERE info LIKE '%PEGGY%'Sorry, but we can not find an entry to match your query

So peggy which is in the database isn't even showing up x_x

big_k105 · Mar 26th, 2008, 4:06 PM

I don't know for sure but my guess is that the problem probably has something to do with the info column being a blob. Might want to change that to TEXT or read through MySQL's documention about the blob type and see if there is a way to look through it using like. Not sure how that data type really works. Maybe someone else can recommend something.

http://dev.mysql.com/doc/refman/5.0/en/blob.html

BLOB is for Binary objects so I would recommend changing that column to text.

Arnack · Mar 26th, 2008, 4:14 PM

SWEET

Now a simple problem here:
What it does is this:
SELECT * FROM users WHERE info LIKE '%JIM%'Jim Jones
In his spare time Jim enjoys biking, eating pizza, and classical music

That's what it echoes. I need to get rid of the beginning part, of course. The code is found on this line:
$sql = "SELECT * FROM users WHERE info LIKE '%$find%'";

Sane · Mar 26th, 2008, 4:26 PM

Well obviously don't echo $sql. Did you not write this script yourself?

Arnack · Mar 26th, 2008, 4:32 PM

No, a friend gave me the script to practice on.

Now- I believe that solves everything really. Now I need to figure out how to make the outputed searched material have a link to a review page for that website, a link to the website, a rating of the website and somehow have keywords for each data...

Arnack · Mar 26th, 2008, 7:26 PM

I'm actually just going to scratch the search thing and think up a whole new idea for my website...

Ooble · Apr 1st, 2008, 12:18 PM

Yo, mods. I see spam.

big_k105 · Apr 1st, 2008, 12:28 PM

taken care of Ooble

Mar 26th, 2008, 3:13 PM	#11
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 4	Re: Simple PHP Search Script Okay, done. Now I get this error: SELECT * FROM users WHERE info LIKE '%HELLO%'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 '%HELLO%'' at line 1 With 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 $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; echo $sql; $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") 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 info LIKE '%$find%'"; echo $sql; $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") 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> this is the code in the mysql database 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" ) __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 3:31 PM	#12
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,623 Rep Power: 10	Re: Simple PHP Search Script Look at line 49 of the code that you just posted. Looks like this: php Syntax (Toggle Plain Text) $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or die(mysql_error()); $data = mysql_query("SELECT * FROM users WHERE upper($field) LIKE '%$find%'") or die(mysql_error()); should be: php Syntax (Toggle Plain Text) $data = mysql_query($sql) or die(mysql_error()); $data = mysql_query($sql) or die(mysql_error()); Right now you aren't using the $sql variable that you used to change the sql statement. __________________ 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, 3:50 PM	#13
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 4	Re: Simple PHP Search Script Ahh okay, I got it now. No errors anymore- now just this: SELECT * FROM users WHERE info LIKE '%PEGGY%'Sorry, but we can not find an entry to match your query So peggy which is in the database isn't even showing up x_x __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 4:06 PM	#14
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,623 Rep Power: 10	Re: Simple PHP Search Script I don't know for sure but my guess is that the problem probably has something to do with the info column being a blob. Might want to change that to TEXT or read through MySQL's documention about the blob type and see if there is a way to look through it using like. Not sure how that data type really works. Maybe someone else can recommend something. http://dev.mysql.com/doc/refman/5.0/en/blob.html BLOB is for Binary objects so I would recommend changing that column to text. __________________ 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, 4:14 PM	#15
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 4	Re: Simple PHP Search Script SWEET Now a simple problem here: What it does is this: SELECT * FROM users WHERE info LIKE '%JIM%'Jim Jones In his spare time Jim enjoys biking, eating pizza, and classical music That's what it echoes. I need to get rid of the beginning part, of course. The code is found on this line: $sql = "SELECT * FROM users WHERE info LIKE '%$find%'"; __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 4:26 PM	#16
Sane Programming Guru Join Date: Apr 2005 Posts: 1,799 Rep Power: 5	Re: Simple PHP Search Script Well obviously don't `echo $sql`. Did you not write this script yourself? __________________ Waterloo's Canadian Computing Competition (CCC) - Stage 2 Problems, Solutions, and Test Data

Mar 26th, 2008, 4:32 PM	#17
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 4	Re: Simple PHP Search Script No, a friend gave me the script to practice on. Now- I believe that solves everything really. Now I need to figure out how to make the outputed searched material have a link to a review page for that website, a link to the website, a rating of the website and somehow have keywords for each data... __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Mar 26th, 2008, 7:26 PM	#18
Arnack Programmer Join Date: Jul 2005 Posts: 66 Rep Power: 4	Re: Simple PHP Search Script I'm actually just going to scratch the search thing and think up a whole new idea for my website... __________________ Ack Network UNDER CONSTRUCTION Now hiring staff of all sorts.

Apr 1st, 2008, 12:18 PM	#19
Ooble I eat cake for breakfast. Join Date: Jul 2004 Location: In my box. Posts: 4,434 Rep Power: 9	Re: Simple PHP Search Script Yo, mods. I see spam. __________________ Me :: You :: Them

Apr 1st, 2008, 12:28 PM	#20
big_k105 PFO Founder Join Date: Mar 2004 Location: Fargo, ND Posts: 1,623 Rep Power: 10	Re: Simple PHP Search Script taken care of Ooble __________________ 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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
PHP script ending prematurely causing Internal Error...???	Syntax_Error	PHP	2	Feb 29th, 2008 8:42 PM
Parsing PHP script output	bulio	PHP	1	Feb 18th, 2008 6:41 PM
A simple script isn't working correctly	scuzzman	Perl	3	Dec 23rd, 2005 6:42 AM
A simple perl script	satimis	Perl	3	Aug 15th, 2005 9:31 AM
A simple script to execute a command package	satimis	Bash / Shell Scripting	3	Aug 12th, 2005 11:28 PM

Programming Forums > Web Development and Design > PHP

Simple PHP Search Script