php讀取acc

<?PHP

/*

創建ADO連接

*/

$conn = @new COM("ADODB.Connection") or die ("ADO Connection faild.");

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("DATUM/cnbt.mdb");

$conn->Open($connstr);

/*

創建記錄集查詢

*/

$rs = @new COM("ADODB.RecordSet");

$rs->Open("select * from dbo_dirs",$conn,1,3);

/*

循環讀取數據

*/

while(!$rs->eof){

?echo "$rs->Fields["title"]->Value;

?echo "<br/>";

?$rs->Movenext(); //將記錄集指針下移

}

$rs->close();

?>