- 10223 Downloads
- Price: FREE
description
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:
1) sing jQuery date picker you can filter the results by date range
2) a text box lets you search for name or email
3) using a drop down with all the available cities you can filter the results by city only
Please check the Demo page of our PHP MySQL search script to see it in action and also check installation instructions. If you have problems, need help or customization or have a suggestion for improvement please use the comments box below.
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:
1) sing jQuery date picker you can filter the results by date range
2) a text box lets you search for name or email
3) using a drop down with all the available cities you can filter the results by city only
Please check the Demo page of our PHP MySQL search script to see it in action and also check installation instructions. If you have problems, need help or customization or have a suggestion for improvement please use the comments box below.
download
To download MySQL Table Search for FREE you need to login your account.
how to install
Follow these steps to run this free script1) open database.sql and import all the MYSQL queries in your database.
2) edit config.php file and set MySQL login details to connect to your database
3) using your web browser open search.php page which will show the results from the database and will let you filter them
abhijit dhumal
August 18, 2015 at 11:42 am
I want the same thing but on single date search function
Ram
July 21, 2015 at 09:45 am
If I don't want to display all the record during when put blank and press reset, where should I change the code?
can I use many pagination?
p
July 17, 2015 at 07:34 am
Hi
How can I order the list when it first shows. I would like to order by City column
dhana
June 23, 2015 at 06:59 am
congrts thank you. its working perfectly
dhana
June 23, 2015 at 07:00 am
thnk u
olame
May 18, 2015 at 03:44 am
merci
wew
May 15, 2015 at 03:51 am
thanks
surisada
April 29, 2015 at 08:49 am
Thanks! Good job!
galih
April 25, 2015 at 00:17 am
thanks for your share
ernesto5
April 18, 2015 at 17:59 pm
thanks let hope it will do what i want
kapil jain
April 16, 2015 at 21:24 pm
thanks