access database software A revised version of calling the Access database through the ADODB library in PHP Original

The most important download address, please read the previous article first.
http://adodb.sourceforge.net/#download
Local download Download this file
Unzip this file and put it in the adodb directory, preferably all of them, not just ohtml.inc.php and adodb.inc.php
You only need to quote these two

Copy the code The code is 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...< ;/h1>";
$access = 'E:phpphpaccesstest.mdb';
$myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access.';USER ID=; PASSWORD=;';
//Attention, 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( );
?>

As for the database, the ordinary access database is the same as normal, there is nothing to pay attention to
The test passed. If you have any better suggestions, please point them out in the comments

The above introduces the access database software. The revised version of Access database calling through the ADODB library in PHP is original. It includes the content of access database software. I hope it will be helpful to friends who are interested in PHP tutorials.