Seach Form to MYSQL DB

[fooobee]

I am new to PHP, and was wondering if anyone knows of a good article, resource that can show me how to efficiently develop a form that searches a mysql DB. I want to create an advanced search form for a job portal. Some of the controls will allow multiple selections ie Locations, Job Categories, so any code to show me how to correctly parse those in php would also be appreciated. Thanks...

 

[sleipnir214]

I always recommend starting with the PHP online manual.


Getting data from a form field to a PHP variable:[ul][li]PHP populates superglobal arrays automatically:

http://www.php.net/manual/en/reserved.variables.php

[/li][li]A PHP quirk dealing with <SELECT> tags that have the "multiple" option set:

http://www.php.net/manual/en/faq.html.php#faq.html.select-multiple

[/li][/ul]

Fetching data from MySQL
All operations take the same steps:[ol][li]connect to the database[/li][li]Select a database[/li][li]send a query to the database server[/li][li]optionally fetch returned data[/li][/ol]You can see all four steps demonstrated in the example code on the PHP online manual page for mysql_fetch_assoc():

http://us2.php.net/manual/en/function.mysql-fetch-assoc.php

The only thing tricky is combining user input into a MySQL query.



Want the best answers? Ask the best questions! TANSTAAFL!