MS Access Database and PHP

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
devarishi
Forum Contributor
Posts: 101
Joined: Fri Feb 05, 2010 7:15 pm

MS Access Database and PHP

Post 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!
JakeJ
Forum Regular
Posts: 675
Joined: Thu Dec 10, 2009 6:27 pm

Re: MS Access Database and PHP

Post by JakeJ »

Please post the PHP code you used to try and connect.
Post Reply