Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Creating a search form in PHP to search a database?
- <body>
- <?php
- $con = mysql_connect("localhost", "root", "");
- if (!$con)
- {
- die('Could not connect: ' . mysql_error());
- }
- if (mysql_query("CREATE DATABASE db_test", $con))
- {
- echo "Database created";
- }
- else
- {
- echo "Error creating database: " . mysql_error();
- }
- mysql_select_db("db_test", $con);
- $sql = "CREATE TABLE Liam
- (
- Code varchar (30),
- Description varchar (30),
- Category varchar (30),
- CutSize varchar (30),
- )";
- mysql_query($sql, $con);
- mysql_close($con);
- ?>
- </body>
- <body>
- <form action="form.php" method="post">
- Search: <input type="text" name="term" /><br />
- <input type="submit" name="submit" value="Submit" />
- </form>
- </body>
- <body>
- <?php
- $con = mysql_connect ("localhost", "root", "");
- mysql_select_db ("db_test", $con);
- if (!$con)
- {
- die ("Could not connect: " . mysql_error());
- }
- $sql = mysql_query("SELECT * FROM Liam WHERE Description LIKE '%term%'") or die
- (mysql_error());
- while ($row = mysql_fetch_array($sql)){
- 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'];
- }
- mysql_close($con)
- ?>
- </body>
- <form action="form.php" method="post">
- Search: <input type="text" name="term" /><br />
- <input type="submit" value="Submit" />
- </form>
- $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'];
- }
- <?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>
- <?php
- if (!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>
Add Comment
Please, Sign In to add comment