Limited offer!

Get a huge collection of PHP scripts in a special bundle!

Mega Sale Price


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.


To download MySQL Table Search for FREE you need to login your account.

how to install

Follow these steps to run this free script

1) 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

Special Offer!

Get all 65 PHP scripts in a bundle for $4.29 each only!

Mega Sale Bundle Price
438 Comments to "MySQL Table Search"
  • smajgybjl


    February 15, 2020 at 07:54 am

    Огромное тебе СПАСИБО



    December 31, 2019 at 12:32 pm

    i have created everything but unable to filter the results display "no records found" and i have changed to myqli from mysql

  • jignesh acharya

    jignesh acharya

    September 19, 2019 at 08:45 am

    I cant not Download this code there is some problem so please send me this code on my email id

  • Fgroia


    March 14, 2019 at 13:07 pm

    hi tehre, i really like the script but i have a problem, how do i make this work with mysqli?!?

    • Jeton


      March 18, 2019 at 15:33 pm

      i have the same problem

    • Duvvuri Sandeep

      Duvvuri Sandeep

      April 30, 2019 at 10:34 am

      MYSQL HTML Table Search
      please listen to my query.
      can you please provide simple code for textbox,dropdown,dates(from,to) all at a time with single FILTER button.
      I mean can u modify your code in simple format.
      i.e instead of ".$SETTINGS["data_table"]." can we write our tablename directly.
      $_REQUEST["string"] can we write it as $a=$_REQUEST["string"] ant then we can execute query.
      There are still so many doubts I have.
      can we write config file in single satement as $connect = mysqli_connect("localhost","root","","databasename");
      I would hope for your reply.
      Thank You.

  • Abul Kalam Azad

    Abul Kalam Azad

    January 21, 2019 at 07:15 am

    I want to show the search data. Do not Show all data. Please Help me.

  • miko


    January 13, 2019 at 12:14 pm

    my script dowload of the day did start but I canceled it accidentaly please allow me to dowload again please I really need it today!

  • 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

    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.


  • 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!


Add your comment