I want to connect to an MS Access Database (.MDB) from within a PHP Script. I googled a couple of tutorials on it and also tried an example given at: http://www.w3schools.com/php/php_db_odbc.asp
however, I was not able to accomplish it. I know how to do that using ASP but since now I am learning PHP so I want to accomplish it in PHP.
Interestingly enough, exampls or tutorials on a similar task are found that mostly use MySQL or PostgreSQL. I don't know either technology as of now.
Could anybody help me with the problem stated above?
Please, note that I want to accomlish these simply tasks:
Add a New Record to the MS Access Database (Table)
Delete and Update an Existing Record
Query to the Database (Table)
A Sample Database/Table is given here:
Database File Name: Helpdesk.mdb
Table Name: caseInfo
Code: Select all
[u]Field Name Data Type[/u]
caseID AutoNumber
escalated True / False
rmk Memo
Thanks!