PHP Search function with Access DB

[bigcat48]

All - I want to create a search function reading the Access db.

Can anyone help with this?

 

[jpadie]

i suspect you would be better off looking in the access forum.

 

[vacunita]

Several steps to take:


1. Create a form to take search terms.
2. Using PHP connect to Access database, and perform search.
3. retrieve search results and display.

Creating the form should be simple.

For the connection you'll need to know how to connect to your access DB and how to pass queries to it. Using ODBC is the usual method.

Here are some an examples:

http://www.w3schools.com/PHP/php_db_odbc.asp

http://www.configure-all.com/php_access.php

PHP.net's online reference for ODBC:

http://php.net/manual/en/ref.uodbc.php

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.