Creating a search form in PHP to search a database? [duplicate]
try this out let me know what happens.
Form:
<form action="form.php" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" value="Submit" /> </form> Form.php:
$term = mysql_real_escape_string($_REQUEST['term']); $sql = "SELECT * FROM liam WHERE Description LIKE '%".$term."%'";$r_query = mysql_query($sql);while ($row = mysql_fetch_array($r_query)){ echo 'Primary key: ' .$row['PRIMARYKEY']; echo '<br /> Code: ' .$row['Code']; echo '<br /> Description: '.$row['Description']; echo '<br /> Category: '.$row['Category']; echo '<br /> Cut Size: '.$row['CutSize']; } Edit: Cleaned it up a little more.
Final Cut (my test file):
<?php$db_hostname = 'localhost';$db_username = 'demo';$db_password = 'demo';$db_database = 'demo';// Database Connection String$con = mysql_connect($db_hostname,$db_username,$db_password);if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db($db_database, $con);?><!DOCTYPE html><html lang="en"> <head> <meta charset="utf-8" /> <title></title> </head> <body><form action="" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" value="Submit" /> </form> <?phpif (!empty($_REQUEST['term'])) {$term = mysql_real_escape_string($_REQUEST['term']); $sql = "SELECT * FROM liam WHERE Description LIKE '%".$term."%'"; $r_query = mysql_query($sql); while ($row = mysql_fetch_array($r_query)){ echo 'Primary key: ' .$row['PRIMARYKEY']; echo '<br /> Code: ' .$row['Code']; echo '<br /> Description: '.$row['Description']; echo '<br /> Category: '.$row['Category']; echo '<br /> Cut Size: '.$row['CutSize']; } }?> </body></html>