Revised version of calling Access database through ADODB library in PHP Original_PHP Tutorial

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. It is best to include all of them, not just ohtml.inc.php and adodb.inc.php
You only need to quote these two

Copy 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...

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

What about the database, ordinary access database, and normal The same, no need to pay attention to anything
The test passed. If you have any better suggestions, please point them out in the comments

http://www.bkjia.com/PHPjc/317511.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/317511.htmlTechArticleThe main download address, please read the previous article first. http://adodb.sourceforge.net/#download Local download Download this file After decompressing this file, place it in the adodb directory, preferably all...