Keyword search pt2

[thesingh]

<?php
mysql_connect("Localhost","root");
mysql_select_db("hamzy");

$result = mysql_query("SELECT * FROM books");


if (!isset($_POST['search']) || $_POST['search'] == '')
{
echo 'no search entered';
}
else
{
$search = $_POST['search'];
$query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR Author LIKE '%$search%";
} 
?>

<table width="581" height="410" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="581" height="90"><div align="center"><h1><img src="banner.jpg" width="581" height="105"></h1>
    </div></td>
  </tr>
  <tr>
    <td height="29"><form name="form1" method="post" action="results.php">
      <div align="center">
        <input type="text" name="textfield">
        <input name="search" type="submit" id="search" value="Search">  

        </div>
    </form></td>
  </tr>
  <tr>
    <td height="254"><div align="center" class="style1">
      <p>Welcome to HaMzY's Bookstore</p>
      </div>
    </div></td>
  </tr>
  <tr>
    <td height="22"><p align="center"> Copyright &copy; 2006 Hamzy Bookstore</p></td>
  </tr>
</table>
</body>
</html>

This is what iv done so far... sorry for the trouble im causing but, what would i do next?????? im sure there has to be something on the results.php page but what???

[khendar]

Nearly there - all you have to do is execute your search query and display the results. You can get rid of the first $query - you dont need it.

$query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR Author LIKE '%$search%"; 
$search_result = mysql_query($query);

while ($row = mysql_fetch_array($search_result)
{
// do some stuff to print out each search result.
}

[thesingh]

<?php
mysql_connect("Localhost","root");
mysql_select_db("hamzy");


if (!isset($_POST['search']) || $_POST['search'] == '')
{
echo 'no search entered';
}
else
{
$search = $_POST['search'];
$query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR Author LIKE '%$search%";
} 
$search_result = mysql_query($query);

while ($row = mysql_fetch_array($search_result)

$field1 = $row["Title"];
$field2 = $row["Author"];
$field3 = $row["Synopsis"];
$field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";

?>

im just getting an error message

Parse error: parse error, unexpected T_VARIABLE in c:\wamp\www\copy of index.php on line 39

which is $field1 line.

[khendar]

You are missing the curly braces ( { and } ) around the contents of the while statement

while (...)
{
// stuff
}

Incidentally - Parse errors are probably the most common errors that you will get. They usually mean you left out a semi-colon, or left out a bracket or something. You have to get used to looking for these kinds of errors, because you will get them all the time and need to know how to deal with them.

[thesingh]

$search_result = mysql_query($query);

while ($row = mysql_fetch_array($search_result)
{
	$field1 = $row["Title"];
	$field2 = $row["Author"];
	$field3 = $row["Synopsis"];
	$field4 = $row["Price"];
}
$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";

?>

Parse error: parse error, unexpected '{' in c:\wamp\www\copy of index.php on line 38

it keeps on calling this error.... iv put the curly braces before the echo and after still the same!!!

[khendar]

Still missing a bracket - at the end of the while( line.

And move your $field3 = ... and echo "... lines inside the } bracket.

And see the above post about parse errors.

[thesingh]

yeaaa... sorry i did not read that last bit you wrote.. i will look out for little errors like that...

this is what i got so far

<?php
mysql_connect("Localhost","root");
mysql_select_db("hamzy");


if (!isset($_POST['search']) || $_POST['search'] == '')
{
echo 'no search entered';
}
else
{
$search = $_POST['search'];
$query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR Author LIKE '%$search%";
} 
$search_result = mysql_query($query);

while ($row = mysql_fetch_array($search_result))
{
	$field1 = $row["Title"];
	$field2 = $row["Author"];
	$field3 = $row["Synopsis"];
	$field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";
}
?>

now im getting a "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\copy of index.php on line 37"

line 37 is the while line!

thats on the line of the while statment... when i added a ";" at the end of it i got that error message again but with a "...£" ????

[khendar]

OK you need to move your $search_result = ... etc and the entire while loop inside the else { } block.

What is happening - because there is no $search value - its not creating the $query, and the mysql_query call is failing. You have to make it so the query is only run if the $search value is entered.

<?php
mysql_connect("Localhost","root");
mysql_select_db("hamzy");


if (!isset($_POST['search']) || $_POST['search'] == '')
{
echo 'no search entered';
}
else
{
  $search = $_POST['search'];
  $query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR        Author LIKE '%$search%";

  $search_result = mysql_query($query);

  while ($row = mysql_fetch_array($search_result)) 
  {
    $field1 = $row["Title"];
    $field2 = $row["Author"];
    $field3 = $row["Synopsis"];
    $field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";
  }
}
?> 

[thesingh]

ok thanks!!!! thats working now! im slowly understanding now! next i need to do is have something on my results page ...

What i had originaly done before i had anyting was have a link going into the results page that showed all of the results from the table... i did it by using these codes..

?php
while($r=mysql_fetch_array($result)){
	$field1 = $r["Title"];
	$field2 = $r["Author"];
	$field3 = $r["Synopsis"];
	$field4 = $r["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p> <b>;
}
?>

that showed all of the info... but to show the results of the search i would need to add some sort of [GET] or [POST] statment if im correct????

[khendar]

The above code (in my post) WILL display the results of your search. You should put this code into a script and point your search form at the script and it will search the database for what you entered in the form.

[thesingh]

im soo sorry !!!!! i have had no sleep what so ever just trying to get this done!!! im not understanding what you are asking me to do .. im sorry for being dumb... let me tell you what i think your askin for ...

the script you are refering to is the form.... now i have to direct the coding that you have soo greatly helped or shall i say provided to direct to the results page????????

[thesingh]

<td height="29"><form name="form1" method="post" action="copy of results.php">
      <div align="center">
        <input type="text" name="textfield">
        <input name="search" type="submit" id="search" value="Search">  

        </div>
    </form></td>

This is my form i have!!!

[khendar]

Ok...Take the code that we worked on above, and put it in a file name "show_results.php"

The form that you have just pasted - make the action of that form action="show_results.php"

And that should be it. Load the form in your browser - type in a search term and hit submit and it should display the results of the search.

[khendar]

Actually you'll need to make a slight change:

<form name="form1" method="post" action="copy of results.php">
      <div align="center">
        <input type="text" name="search">
        <input name="submit" type="submit" id="submit" value="Search">  

        </div>
    </form>

Change the name of the text input area to "search" and the submit button name to "submit"

[TobyRT]

Don't forget, if you're doing a db query, error check it! If you do this, you'll avoid some of those "invalid resource" errors.

mysql_query($query) or die ("Error in query: " mysql_error())

[thesingh]

  while ($row = mysql_fetch_array($search_result))
  {
    $field1 = $row["Title"];
    $field2 = $row["Author"];
    $field3 = $row["Synopsis"];
    $field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";
  }
} 

do i add this code into the copy of results.php page ??

[TobyRT]

yes!

Just make sure you have alternatives if there are no results to display...

leaving for work in a minute - will try and take a butchers when i get there

[khendar]

Just use the block of code we finished off earlier !

[thesingh]

<?php
{
  $search = $_POST['search'];
  $query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR        Author LIKE '%$search%";

  $search_result = mysql_query($query);

  while ($row = mysql_fetch_array($search_result))
  {
    $field1 = $row["Title"];
    $field2 = $row["Author"];
    $field3 = $row["Synopsis"];
    $field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";
  }
}
?> 

knowing me i proberly put the wrong code in the copy of result.php file... im getting that "Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in c:\wamp\www\copy of results.php on line 46" error again ..

i been moved the curly braces around.. but nothing!!

[khendar]

Post your whole results.php file - and the whole form file. All you should have in the results.php file is :

<?php
mysql_connect("Localhost","root");
mysql_select_db("hamzy");


if (!isset($_POST['search']) || $_POST['search'] == '')
{
echo 'no search entered';
}
else
{
  $search = $_POST['search'];
  $query = "SELECT Title, Author, Price FROM books WHERE Title LIKE '%$search%' OR        Author LIKE '%$search%";

  $search_result = mysql_query($query);

  while ($row = mysql_fetch_array($search_result))
  {
    $field1 = $row["Title"];
    $field2 = $row["Author"];
    $field3 = $row["Synopsis"];
    $field4 = $row["Price"];

$field3 = substr($field3, 0, 200);

echo "<b>$field1</b><br> $field2</br> $field3 ...<b>£$field4</b></p>";
  }
}
?> 

And thats it.