php读取access数据库

时间：2022-02-20 00:03:33
<?php

//读取mdb数据库

$conn = new com("ADODB.Connection");

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

$conn->Open($connstr);

$rs = new com("ADODB.RecordSet");

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

while(! $rs->eof) {

  $f = $rs->Fields(1);

  echo $f->value;

  echo " 　". $rs->Fields(2)->value;

  $rs->MoveNext();

}

?>

相关文章