Posted by Richard Lynch on 02/25/05 20:35

Bruno Santos wrote:
> I need to to an application in PHP with graphics creation.
> The database where i need to go and fetch the values is access.
> is possible for PHP to fecth values from an access database ??

Sure!

You can Google for "PHP MS-Access" and find a ton of info.

I'm pretty sure it (still) boils down to setting up a DSN in Windows and
using http://php.net/odbc

NOTE:
MS-Access was *NOT* designed for multi-user multi-threaded usage. If
*two* people try to use MS-Access at once (IE, if two people surf to your
site at the same time) MS-Access will most likely crash.

If at all possible, I'd recommend generating the images "in advance" and
using the generated images on the web. You can do a scheduled task to
updatethem every few minutes or whatever, and control connections to the
MS-Access db that way.

You may also want to consider just exporting the data and dumping it into
MySQL and using one of the pre-existing PHP Graphing libraries "out there"
-- If you want bar charts or pie charts, there are some excellent
libraries already written that you can just "plug in" to your database and
be done -- But they may not support Access, so a quick CSV dump and import
to MySQL will do the trick, still faster than writing your own, if not as
fun :-)


--
Like Music?
http://l-i-e.com/artists.htm

[Back to original message]