- 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
sachin
September 16, 2014 at 20:54 pm
thanxx
Cedric
September 14, 2014 at 03:33 am
Thanks for the script it helped me a lot.
viji
September 13, 2014 at 11:41 am
thank u
chol
August 31, 2014 at 19:22 pm
echo password(" ");
vipin
August 29, 2014 at 20:17 pm
thank you
Becky
August 15, 2014 at 16:12 pm
this has helped me alot. thanks guys
asad
August 8, 2014 at 14:56 pm
fodo
tehseen ullah
August 8, 2014 at 14:26 pm
tnx great tutorial
Lola
August 8, 2014 at 02:14 am
Great site!
Hi, I need to have this code custom a little. I need 4 fields the first field has numbers the second 2 is artist and then title and the last field is numbers. I don't want the table on the search.php to show data until the search is final. It would
(numbers) then search by (artist or title) then (numbers) again. Please, if you could give me a quote. Thanks
Steve
November 27, 2014 at 15:48 pm
Email me. I will give you a quote!
tal
July 26, 2014 at 16:25 pm
Hello,
I need to customize this script.. like add airport departure and airport arrival and remove full name and email... Where i can put the code...? Also how to hide data, and after clicking on filter.. it's show the data as i need.
Regards
O.