Question

在php众如何从access数据库读取一条记录

请举个具体点的例子，我是新手！谢谢了……

Answer 1

<?php //读取mdb数据库例程
$conn = new com("ADODB.Connection");
$connstr = "DRIVER=; 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();
}
?>

追问

谢谢您的回答，不过我使用ODBC连接数据库的，该怎么读取数据啊？

追答

以下是用odbc连接数据库的例子：

open($db_connstr);
$rs = $db_connection->execute("SELECT EmpNameLocal, EmpPosLocal FROM tbl_Employee WHERE ID='$IDNo'");
$rs_fld0 = $rs->Fields(0);
$rs_fld1 = $rs->Fields(1);
while (!$rs->EOF) {
$empNameLoc = $rs_fld0->value;
$empWPPos = $rs_fld1->value;
$rs->MoveNext();
}

$rs->Close();
$db_connection->Close();
?>

Answer 2

新手就php+mysql啊，怎么用access？