Question

如果用php连接ACCESS数据库后该如何读取

要php代码

Answer 1

<?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();
}
?>

Answer 2

<?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();
}
?>