Ajax AutoSuggest Search using PHP / MS Access DB

[mjs87]

Hi I am fairly new to Ajax and have been searching for a autosuggest search tutorial that uses suggestions from a field in an MS Access database. I have found a few tutorials using mysql, however these tutorials use the mysql functions with php and I am not able to tailor this towards my MS Access DB. Could someone point me in the right direction of a simple way to produce a Ajax search field that autosuggests using a field in a MS Access db.

 

Thanks

[RichardRotterdam]

Your problem is not really Ajax related it's more PHP related. The examples you came across most likely used the mysql_ functions to work with a mysql database. Instead of using the mysql_ look into the odbc_ functions for connecting to a access db.

 

Edit: PDO might also work for you.

[mjs87]

useful, I never knew PHP had odbc functions, I always thought it was limited in that respect and had to use mysql. I just need to find the tutorial i was working from again because I didn't think I would be able to use it. I am quite a newbie to this so I will most likely be writing back for more help! thanks in the meantime!!

[mjs87]

Could someone point me in the right direction where I could find a decent tutorial? thanks

[RichardRotterdam]

If you searched for "Ajax PHP autocomplete" or something along those lines then it should be pretty much those tutorials. As stated before you just need to know how to connect to an MS Acces database using odbc_ functions, PDO or something else that might work with MS Access. The tutorials written for mysql should otherwise be pretty much the same except for the database handling.

 

What code have you got so far and what tutorials have you tried? Simply asking for tutorials that will point you to the right direction for "PHP MS Access" comes off as if you haven't done enough research yourself thus having the result that people are less willing to help you out on your problem.