I would like to know how can I use Access .mdb databases with PHP.
I would apreciate very much a small snipet.
Also, what are the dependencies for such database to work in php? (dlls, mdac, etc...)
Thanks your for your atention! :wave:
Printable View
I would like to know how can I use Access .mdb databases with PHP.
I would apreciate very much a small snipet.
Also, what are the dependencies for such database to work in php? (dlls, mdac, etc...)
Thanks your for your atention! :wave:
Man thats a no-brainer in Windows if you have access to the server. If not you have to ask your host provider or use some sort of interface to create a DSN (this is what you use in odbc_connect PHP function to connect to a data source) which will be mapped to an Access Database. I will not explain you how to do it, because all ISPs have their own way of doing this.
If you host PHP on a Windows machine and you can access the Administrato desktop:
1. Go to Control Panel->Administrative Tools->Data Sources (ODBC). You can make a new data source name there.
2. Use this name in odbc_connect.
Dont forget to create an Access database with your tables !