php读取access数据库 php access编程一则

This is list.php

<?php //读取mdb数据库例程 

$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("mydb.mdb");
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from testtable",$conn,1,1);
while(!$rs->eof){
$f = $rs->Fields(1);
echo $f->value."<br />";
$g=$rs->Fields(2);
echo $g->value;
$rs->MoveNext();
}
?>

then create a access db file named mydb.mdb.