Will PHP work with MS Access DB?

[Anon]

I know alot about VB, ASP, and MS Access Databases and I was wondering if PHP supported MS Access Databases. If it doesn't, what whould be the most cost effective SQL solution? I am looking to buy Linux and download apache and PHP4 today.

Thanks,
Trey

[andyrobinson]

Trey,

PHP supports ODBC so you can connect to MS Access and any other DB that has an ODBC driver.

If you\'re planning on using PHP on a Linux box then you\'d probably be better off using MySQL as support for it is built into PHP4.

Hope this helps.

Andy.

[Anon]

The only reason I find this question fitting into this topic is that your last post illustrates exactly what I'm going to ask how not to do.

I need to insert a bunch of text into a database. The text will be ripe with single quotes, double quotes and the occasional html tag. Any Idea how I might go about doing this without using urlencoding functions? The sql update string chokes on all this stuff and gives me errors.

[jordanj]

Chris,

First off, I would recommend that you start your own Thread with this sort of question.. However you will want to look into the addslashes() command..

http://www.php.net/manual/en/function.addslashes.php

[jnutter]

review these:

magic_quotes_runtime
magic_quotes_gpc

addslashes()
stripslashes()
strip_tags()
htmlspecialchars()

Find the right combo for your environment and you are happenin =)

If the data is coming from a text file you can write a quickie script to pull the text file in and format it using some of the above functions and then output it as INSERT statements.

No doubt there are even easier ways to do this but that's what I usually do.

• nutter