using ms-access db

[akelabanda]

Hi Friends

I'm new to PHP. To make my website dynamic, I'm planning to store a list of URLS and other info on MS-access db. Can you tell me if PHP can open and read this file independently.

What I mean is -

1. Create the ms-access db on my desktop
2. ftp it over to my linux hosting service
3. create a php program that can read/query this mdb
4. from time to time, I would place a new copy of the mdb on the linux host server

Is this possible ?

Hope I'm clear.

Your responses will be much appreciated.

Thanks
Raj

 

[sleipnir214]

Reading and writing an Access database from a Linux machine is problematic at best because Microsoft's DBF format is proprietary.

You can maintain, I suppose, your workstation-local Access database, but I'd look into other options at your hosting provider for keeping data on the web server. Perhaps exporting your Access data as a CSV, then uploading that to the server, using a PHP script to update a non-Access database there. It's not outside the realm of possibility that your hosting provider makes a database like MySQL available.


Want the best answers? Ask the best questions! TANSTAAFL!