PHP generating tables

studioh3o

what im trying to do is when a user uses the search function on the page i want it to retrieve the information from the databse based on the criteria entered in the ssearch field and thn display it on a page in tables. does anybody know how i would go about doing this? thanks in advance.

Mike

HalfaBee

This is the basics of what you need.
It just displays every column of the DB in a table.
It searches for the search string any where in the column.

HalfaBee

mysql_connect( server,user,passwd )
mysql_select_db( dbname );

mysql_query( "select * from table where  text_column LIKE '%$search_string%' ");

echo "<TABLE>\\\n";
while( ($row=mysql_fetch_array($result)!==FALSE )
{
echo "<TR>";
 foreach( $row as $s )
{
  echo "<TD>$s</TD>"
}
echo "</TR>\\n";
}
echo "</TABLE>";

studioh3o

so to grab the information from the search form, how would i go about that? like what is the php code needed to be written.
thanks in advance..

mike

HalfaBee

It depends on how your form is set up.

If you use POST then $search_string = $_POST['search']; if you called your <input > search.

HalfaBee

studioh3o

ok cool, thanks i will try that and let you know.

Mike

studioh3o

ok im getting an error...

Parse error: parse error, unexpected T_STRING in /home/httpd/vhosts/heismy.com/httpdocs/search.php on line 4

this code is before the html tags

<?php
$search_string=$_POST['search'];
mysql_connect("localhost","user","pass")
mysql_select_db("store"); < line 4>
mysql_query("select * from products where text_column LIKE '%$search_string%' ");

?>

this is in between the html tags

<?
echo "<TABLE>\n";
while( ($row=mysql_fetch_array($result)!==FALSE )
{
echo "<TR>";
foreach( $row as $s )
{
echo "<TD>$s</TD>"
}
echo "</TR>\n";
}
echo "</TABLE>";
?>

any help would be great.

mike

HalfaBee

If you have an error, always look at the line before it.

$search_string=$_POST['search'];
mysql_connect("localhost","user","pass") ; // you had no ; here!
mysql_select_db("store"); < line 4>

HalfaBee

studioh3o

im getting the following error... im not sure where my code is wrong.
Parse error: parse error, unexpected '{' in /home/httpd/vhosts/heismy.com/httpdocs/search.php on line 135
this is the codse that is between html tags...
<?
echo "<TABLE>\n";
while( ($row=mysql_fetch_array($result)!==FALSE ) <line 35>
{
echo "<TR>";
foreach( $row as $s )
{
echo "<TD>$s</TD>"
}
echo "</TR>\n";
}
echo "</TABLE>";
?>

Mike

HalfaBee

Missing ) after restult) .

while( ($row=mysql_fetch_array($result))!==FALSE ) <line 35>

HalfaBee

darkke

It also looks like you missed another semicolon:

echo "<TD>$s</TD>"

should be:

echo "<TD>$s</TD>";