- 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
Dconcept
June 8, 2018 at 10:59 am
Please the downloading is not going... anybody who have it can please send it to my email box [email protected].
Thank you.
Marc
April 20, 2018 at 04:56 am
Anyone know how I can change the config file with mysqli instead of mysql? I'm pretty sure that's why I'm getting a blank white screen.
thanks
jade
September 21, 2018 at 09:26 am
im getting that error also
Marc
April 20, 2018 at 04:20 am
Downloaded the folder and I'm looking at the instructions...
"1) open database.sql and import all the MYSQL queries in your database."
Can I open this with MAMP? I tried but not successful. I'm very new at this, could someone help me out? I do have a local server running on my Mac...just not sure how to get started here...
Jamin
December 24, 2017 at 02:29 am
This is a Amazing script, you can tell a real professional made this. This script was a GREAT launch point for a database searching tool!
PHPCoder
November 6, 2017 at 05:55 am
Download link is not working properly I can't download the script.
PHPCoder
November 8, 2017 at 02:52 am
Just for tip disable your download manager extension, just in case for me like 'IDM' and you can download the file successfully.
Professional Php
August 16, 2017 at 07:44 am
Nice one. This is a fully informative tutorial about MySQL table search. This was so easy to follow and exactly what I was looking for. Good job and well explained.
Thanks.
Aly
July 3, 2017 at 12:03 pm
can you add paging?
lakheswar
June 6, 2017 at 14:42 pm
i can't download , its not good
riya
June 1, 2017 at 09:47 am
i con't download link, plz help
Flo
May 20, 2017 at 17:31 pm
Can you add pagination code ?