October 21st, 2004, 10:18 PM
How To: Access .mdb database with PHP?
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!
All consequences are eternal in some way.
October 22nd, 2004, 12:44 PM
Re: How To: Access .mdb database with PHP?
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 !
Click Here to Expand Forum to Full Width