Page 1 of 1

MS Access Database and PHP

Posted: Sun Feb 07, 2010 1:21 pm
by devarishi
Hi,

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!

Re: MS Access Database and PHP

Posted: Mon Feb 08, 2010 11:16 am
by JakeJ
Please post the PHP code you used to try and connect.