The method of calling Access database through ADO in PHP fails the test_PHP tutorial

After I read the article "How to call Asscess database and COM program through ADO in PHP", I immediately tested it and the result failed. Sad isn't it.

What to do? I had no choice but to go to the PHP official website for help. God paid off, and finally I found the answer -

The specific solution is as follows:
(1) Download the corresponding ZIP package; the same as MICROSOFT's ADO , this stuff uses PHP to implement ADO to deal with various databases (great, all types of databases can be processed).
(2) Unpack, there are many files in it, but the only ones that are useful are ohtml.inc.php and adodb.inc.php (this is not the case after my test). Copy them to the corresponding directory (or install php4 In the default directory c:php4peer, or in the current running program directory, depending on the include() function);
(3) Then in the c:myphp directory of the local machine (set under iis through http:// localhost/jhk to access), created an access library named test.mdb, and created an experts table in it... In order to access it through DSN, I named the ACCESS library just now test in the DSN.
(4) Run. After looking at the instructions, I created such a program:
dbtest.php, the content is as follows:

Copy the code The code is as follows:

< ;?php
include('tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$conn = &ADONewConnection('access'); // create a connection
$conn->PConnect('test');// connect to MySQL, agora db
$sql = 'select name, group1 from experts' ;
$rs = $conn->Execute($sql);
rs2html($rs,'border=2 cellpadding=3',array('Customer Name','Customer ID'));
$rs->Close(); // optional
$conn->Close(); // optional
?>

Then, type in IE ：http://localhost/jhk/dbtest.php
Alas! The results are out. Basically satisfactory! !

(5) Then, I thought: I still need to set up DSN, don’t you bother me! How to bypass DSN? Because in asp, I am used to using conn.open("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.Mappath("../nydatabase.mdb")) to handle the mdb library, which is fast ah!
? ...I thought about it again and again, and looked at it again and again...

Look around,..., hehe, I finally found the answer in testdatabases.inc.php! I adapted the program just now:

Copy the code The code is as follows:

include(' tohtml.inc.php'); // load code common to ADODB
include('adodb.inc.php'); // load code common to ADODB
$db = &ADONewConnection("ado_access");
print "

Connecting $db->databaseType...

";
$access = 'test.mdb';
$myDSN = 'PROVIDER=Microsoft.Jet. OLEDB.4.0;'.'DATA SOURCE='. $access . ';';.'USER ID=;PASSWORD=;';

if (@$db->PConnect($myDSN, " ", "", "")) {
print "ADO version=".$db->_connectionID->version."
";
$sql = 'select name, group1 from experts ';
$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();
?>

Run.
All done! (After my test, it actually does not solve the problem), you can read the next article and you will know

http://www.bkjia.com/PHPjc/317513.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/317513.htmlTechArticleAfter I read the article "How to call Asscess database and COM program through ADO in PHP", I immediately made Tested and failed. Sad isn't it. what to do? I had to go to the PHP official website...