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.

download

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
208 Comments to "MySQL Table Search"
  • Professional Php

    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

    Aly

    July 3, 2017 at 12:03 pm

    can you add paging?

  • lakheswar

    lakheswar

    June 6, 2017 at 14:42 pm

    i can't download , its not good

  • riya

    riya

    June 1, 2017 at 09:47 am

    i con't download link, plz help

  • Flo

    Flo

    May 20, 2017 at 17:31 pm

    Can you add pagination code ?

  • Rufus

    Rufus

    April 24, 2017 at 10:59 am

    I cannot download the link even after registering please help

  • GainAtts54

    GainAtts54

    November 2, 2016 at 11:17 am

    Thank you. ^^

  • Andrei Motpan

    Andrei Motpan

    July 18, 2016 at 13:00 pm

    Sasho Valkanov July 18, 2016 at 09:36 am
    Which part of adding the field you face problems with? Did you add it to the MySQL table? Do you have a problem visualizing the data or making a search field for it?

    Sorry,for some reasons I can't reply there.

    So we have like this at the moment:
    first search field: where you can input text
    second search: using drop down.
    Together they work perfectly, however I am trying to create another dropdown tab. But they don't work all 3 together.
    http://joxi.net/8AnopGXHqpzzNr - Client works only with output language.

    Thanks.

    Andrei

  • Andrei Motpan

    Andrei Motpan

    July 17, 2016 at 19:29 pm

    Hi mate,

    Thanks for the code.
    I am trying to add another field for city, let's say "country" but no luck.
    Can you give me a hint please?
    Thanks in advance.

    Andrei

    • Sasho Valkanov

      Sasho Valkanov

      July 18, 2016 at 09:36 am

      Which part of adding the field you face problems with? Did you add it to the MySQL table? Do you have a problem visualizing the data or making a search field for it?

    • Andrei Motpan

      Andrei Motpan

      July 25, 2016 at 11:20 am

      Hi mate,

      Any thoughts?

      Andrei

    • Sasho Valkanov

      Sasho Valkanov

      July 26, 2016 at 14:26 pm

      You need to add something like this

      if ($_REQUEST["lang"]<>'') {
      $search_lang = " AND lang='".mysql_real_escape_string($_REQUEST["lang"])."'";
      }

      (assuming that field and mysql column is named "lang"). Then add $search_lang to the SELECT query where $search_string.$search_city are.

  • Nymaalum

    Nymaalum

    July 1, 2016 at 19:46 pm

    Download link is not working properly I can't download the script plz help me

next

Add your comment

Captcha