How to Create Search Query using PHP/MySQL

Submitted by alpha_luna on Saturday, June 18, 2016 - 10:13.
In this tutorial, we are going to create Search Query using PHP/MySQL. Search query using PHP/MySQL is a simple PHP source code that the users enable to search in the table. Creating one TextBox for the user where they enter the desired word to search and the table with our data in a data table as you can see in the image below. ResultHere's the source code of the image above. Kindly copy and paste to your BODY tag of your page. 
  1.                     <div class="row-fluid">
  2.                         <div class="span6">
  3.                             <div class="span6">
  4.                                 <form method="POST" action="search.php" class="navbar-search pull-left">
  5.                                     <input type="text" name="search" class="search-query" placeholder="Search">
  6.                                 </form>
  7.                             </div>
  8. 							<br />
  9. 							<br />
  10. 							<br />
  11.                             <table class="table table-bordered  table-hover table-striped"> 
  12.                                 <thead>
  13.                                     <tr>
  14.                                         <th>Title</th>
  15.                                         <th>Author</th>
  16.                                         <th>Category</th>
  17.                                     </tr>
  18.                                 </thead>
  19.                                 <tbody>
  20.                                     <?php
  21. $query = mysql_query("select * from book") or die(mysql_error());
  22.  
  23. while ($row = mysql_fetch_array($query))
  24. 	{
  25. ?>
  26.  
  27.                                         <tr>
  28.                                             <td><?php
  29. 	echo $row['title']; ?></td>
  30.                                             <td><?php
  31. 	echo $row['author']; ?></td>
  32.                                             <td><?php
  33. 	echo $row['category']; ?></td>
  34.  
  35.                                         </tr>
  36.                                         <?php
  37. 	}
  38.  
  39. ?>
  40.                                 </tbody>
  41.                             </table>
  42.                         </div>
  43.                     </div>
We are going to search the "Programming" word. Let's enter to the TextBox and it will show in the image below what happen next. ResultAs you can see in the image above, only has a Programming word display on our table. Here's the source code for the searching data in our data table. 
  1.                 <div class="span12">
  2. 							<br />
  3.                           <a href="index.php" class="btn btn-success">Back</a>
  4. 							<br />
  5. 							<br />
  6.                     <div class="row-fluid">
  7.                         <div class="span6">
  8.                             <div class="span6">
  9.                                 <form method="POST"  class="navbar-search pull-left">
  10.                                     <input type="text" name="search" class="search-query" placeholder="Search">
  11.                                 </form>
  12.                             </div>
  13. 							<br />
  14. 							<br />
  15. 							<br />
  16.                             <table class="table table-bordered  table-hover table-striped"> 
  17.                                 <thead>
  18.                                     <tr>
  19.                                         <th>Title</th>
  20.                                         <th>Author</th>
  21.                                         <th>Category</th>
  22.                                     </tr>
  23.                                 </thead>
  24.                                 <tbody>
  25.                                     <?php
  26.  
  27. if (isset($_POST['search']))
  28. 	{
  29. 	$search = $_POST['search'];
  30. 	$query = mysql_query("select * from book where category like '%$search%' or title like '%$search%' or author like '%$search%'") or die(mysql_error());
  31. 	while ($row = mysql_fetch_array($query))
  32. 		{
  33. ?>
  34.  
  35.                                         <tr>
  36.                                             <td><?php
  37. 		echo $row['title']; ?></td>
  38.                                             <td><?php
  39. 		echo $row['author']; ?></td>
  40.                                             <td><?php
  41. 		echo $row['category']; ?></td>
  42.  
  43.                                         </tr>
  44.                                         <?php
  45. 		}
  46. 	}
  47.  
  48. ?>
  49.  
  50.  
  51.  
  52.                                 </tbody>
  53.                             </table>
  54.                         </div>
  55.                     </div>
  56.                 </div>
Hope that this tutorial will help you a lot. Share us your thoughts and comments below. Thank you so much for dropping by and reading this tutorial post. For more updates, don’t hesitate and feel free to visit this website more often and please share this with your friends or email me at [email protected]. Practice Coding. Thank you very much.

Tags

Add new comment

About text formats
  • 2775 views