MySQL Table Search is a free PHP MySQL search script which will let you print the content of a MySQL database table and then filter the results using different criteria.
MySQL table structure that we use in this script is useful to store details of a booking. You can add/edit/remove any of the fields and modify the search script to print and search your own custom made MySQL table.
The following fields are used in our MySQL table:
- from_date - start date for the reservation - MySQL date field
- to_date - end date for the reservation - MySQL date field
- full_name - name of the person who made the reservation - MySQL varchar field
- email - email address of the person who made the reservation - MySQL varchar field
- city - city where reservation was made - MySQL varchar field
There are 3 ways to filter the data:
- sing jQuery date picker you can filter the results by date range
- a text box lets you search for name or email
- using a drop down with all the available cities you can filter the results by city only
How To Run this Script Follow these steps to run this free script
- open database.sql and import all the MYSQL queries in your database. There is some sample data which is used for the filters
- edit config.php file and set MySQL login details to connect to your database
- using your web browser open search.php page which will show the results from the database and will let you filter them
Download MySQL Table Search PHP Script
Though you need to create an account at phpjabbers to download this php script but its worth it,trust me.
Enjoy!
