Hosting Solutions
mobile_logo Table of Contents

Build the HTML Search Form with Filter Select List

Part 2 of MySQL PHP Search Programming Exercises for database driven web sites. Search pages that allow advanced targeting and filtering of information. Learn to build HTML Search Forms and Advanced Search Filters, Various MySQL Search Query Methods, Joined Table Queries Targeting Multiple Tables, Natural Language Full-Text Search Queries, Boolean Full-Text Search Queries and discuss fine tuning your search programming and adjusting search parameters. <?php $search_output = ""; if(isset($_POST['searchquery']) && $_POST['searchquery'] != ""){ // run code if condition meets here } ?> <html> <head> </head> <body> <h2>Search the Exercise Tables</h2> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> Search: <input name="searchquery" type="text" size="70" maxlength="88"> <input name="myBtn" type="submit"> <br><br> Search In: <select name="filter1"> <option value="Whole Site">Whole Site</option> <option value="Pages">Pages</option> <option value="Blog">Blog</option> </select> </form> <div> <?php echo $search_output; ?> </div> </body> </html>

PHP Videos

Search Programming MySQL Database

Create and Populate Example Database TablesBuild the HTML Search Form with Filter Select ListSQL LIKE Syntax UNION and AS Alias with FiltersSQL MATCH AGAINST Fulltext Search UNION Tutorial