ciaran1987 Posted March 2, 2009 Share Posted March 2, 2009 Hi Guys I am php novice but was wondering could anyone help me with a problem I am having.I am trying to create a search form on a HTML page what will search a Mysql DB and return what I have entered into the search bar along with its relevant information.I have created the follwing HTML page <html> <head> <title>Search the Database</title> </head> <body> <form action="search.php" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" name="submit" value="Submit" /> </form> </body> </html> I have then created the following search.php file <?php mysql_connect ("localhost", "root","password") or die (mysql_error()); mysql_select_db ("heskdb"); $term = $_POST['term']; $sql = mysql_query("select * from hesk_std_replies where title like '%$term%'"); while ($row = mysql_fetch_array($sql)){ echo '<br/> id: '.$row['id']; echo '<br/> message: '.$row['message']; echo '<br/><br/>'; } ?> When I run this and submit a term into the search bar It returns what I have asked it to echo IE id: '.$row['id']; echo ' message: '.$row['message']; echo ' '; } ?> I have created HTML/php page all as one as follows <html> <head> <title>Search the Database</title> </head> <body> <form action="search2.php" method="post"> Search: <input type="text" name="term" /><br /> <input type="submit" name="submit" value="Submit" /> </form> </body> </html> <?php mysql_connect ("localhost", "root","password") or die (mysql_error()); mysql_select_db ("heskdb"); $term = $_POST['term']; $sql = mysql_query("select * from hesk_std_replies where title like '%$term%'"); while ($row = mysql_fetch_array($sql)){ echo '<br/> id: '.$row['id']; echo '<br/> message: '.$row['message']; echo '<br/><br/>'; } ?> While this does what I want it to do IE search a MySQL db and return what I have searched along with other information because it is one page each of the entries into the field are displayed when I run the page in the browser initially and then disappear when I enter a term into the search bar (except the info I have actually searched for).Could anybody help me create 2 separate pages to do this function so that nothing is displayed initially apart from my search bar? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.