Access database software PHP with ADODB library to invoke the modified version of the Access database original

The most important download address, please first look at an article.
http://adodb.sourceforge.net/#download
Download this file locally
This file is extracted and placed in the ADODB directory, preferably all Ah, not only ohtml.inc.php and adodb.inc.php
The references are really as long as these two are available.

Copy the Code code as follows:

Include (' adodb/tohtml.inc.php '); Load code common to ADODB
Include (' adodb/adodb.inc.php '); Load code common to ADODB
$db = &adonewconnection ("ado_access");
Print "

Connecting $db->databasetype ...

";
$access = ' E:\php\phpaccess\test.mdb ';
$myDSN = ' provider=microsoft.jet.oledb.4.0; '. ' DATA source= '. $access. '; USER id=; password=; ';
Note that the MDB address is a physical address.
if (@ $db->pconnect ($myDSN, "", "", "")) {
Print "ADO version=". $db->_connectionid->version. ";
";
$sql = ' Select thename from News ';
$rs = $db->execute ($sql);
Rs2html ($rs, ' border=2 cellpadding=3 ', Array (' Customer Name ', ' Customer ID '));
} else print "Error:access test requires a Access database $access".
'. $db->errormsg ();
?>

database, the normal Access database, as normal, no need to pay attention to what
Test passed. If you have better suggestions, please indicate in the comments

The above describes the Access database software in PHP through the ADODB Library implementation of the modified version of the Access database, including the Access database software content, I hope that the PHP tutorial interested in a friend helpful.

