faqts : Computers : Programming : Languages : PHP : Database Backed Sites : Access

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

81 of 167 people (49%) answered Yes
Recently 3 of 10 people (30%) answered Yes

Entry

How can I use a Microsoft Access database with PHP?

Dec 20th, 2007 02:14
World Casino, Chris Hester, Henrik Hansen, John Kos, Phil Greenway, Nathan Wallace, http://www.chiefcyberpicks.com/ http://www.onlinecasinoreviewdirectory.com/ http://www.onlinebingoreviewdirectory.com/


Easysoft have added a PHP tuorial to their wed site with code examples 
for ODBC access.
This doesn't exactly help you - it just points you to the PHP manual 
which just explains the syntax with no code examples.
You can use an ODBC connection to your Access database.
However ODBC in my experience is somewhat clunky and is not really very
useful in large applications.
On non-windows platforms, the Easysoft ODBC-ODBC Bridge provides direct 
access to MS Access and any other ODBC enabled databases for PHP 
developers.
We have used Access and exported the database as a text-only file, each 
field separated by a comma. This can then be extracted line by line, 
each field split (by scanning for commas) etc. The data from each field 
can then be applied however you want. (I've even coded a search button 
from the database.) Why didn't I use MySQL? Because we're not allowed 
to use it on our server. I coded everything by hand, but it works!
http://www.chiefcyberpicks.com
http://www.onlinebingoreviewdirectory.com
http://www.onlinecasinoreviewdirectory.com
http://www.skillgameschief.com
http://www.skillgamesdirectory.com
http://www.skillgamesportal.com
http://www.skillgamesearch.com
http://www.onlinepokerreviewdirectory.com
http://www.pokerstarsnetwork.com
http://www.chiefbrand.com
http://www.chiefcyberpicks.us
http://www.NCAASportsBlog.com
http://www.casinogaminginsider.com
http://www.marchmadnessUSA.com
http://www.nflchampionshipblog.com
http://www.worldgamingarticles.com
http://www.SUPERBOWLBET.US
http://www.gaminglaws.com
source : easysoft.com