Advanced php database search form

I need an advanced property search form and php script to parse several database fields and then build the query and return the results in a random order, but with the option of listing in order of price, number of rooms etc.

The form itself should have an input field for a keyword/keywords search, then a drop down list of accommodation types, a drop down list for prices, a drop down list for the number of people, and then several check boxes for whether they want a place that accepts pets or accept smokers etc.

The database form fields to search are:

title (varchar)

description (text)

keywords (varchar)

The database form dropdowns to search are:

category (mediumint)

price (varchar)

sleep (int)

The database form check boxes to search are:

heat (varchar)

pet (varchar)

park (varchar)

smoke (varchar)

The search script must allow any combination of searches which might be just 1 check box or all check boxes, dropdowns and a keyword.

I also need the script to be able to show the output on a Google Map, this should be a link on the search results page.

Each property has a LAT LNG entry in the database as well for this feature.

Hopefully that will make sense to everyone. Please PM me if you have any questions.


Taidot: PHP

Näytä lisää: php database search form, php database search, php advanced search form, php form database search, database php search form prices, search database form php, php advanced search form script, advanced search form script, search form php database, advanced php search form, php form advanced search database, to advanced, that pet place, php description, int map, c text search, advanced search results, php advanced search script, php search database form, check box php form database, database search script php post, smoke, Sleep, php database, pets

Tietoa työnantajasta:
( 18 arvostelua ) Cardiff, United Kingdom

Projektin tunnus: #424697