MS Access and PHP...
I build all of my sites with ASP and am just now starting to pick up PHP. The department I work for doens't have the need for anything larger or more advanced than MS Access to support the applications being used. I am trying to open an Access DB and just list the items in the database into a form. I can't find any easy way to do this using Access (MySQL is everywhere). Thanks for any help.
relative location of DB - (database/officelist.mdb)
fields to query - (Rep_First_Name, Rep_Last_Name)
Thanks for any help.
Maverick posted this at 21:50 — 12th March 2001.
They have: 334 posts
Joined: Dec 1999
There's a tutorial for using PHP to work with an MS Access DB at:
http://www.phpbuilder.com/columns/siddarth20000228.php3
artsapimp posted this at 22:14 — 12th March 2001.
They have: 330 posts
Joined: Apr 2000
Thanks. It worked perfectly accept for one thing. I am not using a DSN. I did find another example but it then made me use a static link to connect the DB. In asp I would write .. " & Server.MapPath("database/name.mdb") ... so I don't have to write c:\inetpub\wwwroot\...
Thanks for any help.
Free Math Test
Fun Math Games
Mark Hensler posted this at 23:21 — 12th March 2001.
He has: 4,048 posts
Joined: Aug 2000
did you know that mySQL is FREE?
artsapimp posted this at 23:39 — 12th March 2001.
They have: 330 posts
Joined: Apr 2000
Yes. I am running this on a large corporation's web server so getting anything installed (free or not) takes a lot of work. I have MySQL running on my laptop (not without problems) and I do hope to have most if not all of our databases converted. But to make any progress today I will need to connect to Access.
Free Math Test
Fun Math Games
Mark Hensler posted this at 06:04 — 13th March 2001.
He has: 4,048 posts
Joined: Aug 2000
ahhh.. I see
Best of Luck,
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.