windows系统中如何用php操作Access数据库?
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\\oa\\access\\test.mdb";
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from news",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields["title"]->value."
";
$rs->MoveNext();
}
?>
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=d:\\oa\\access\\test.mdb";
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from news",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields["title"]->value."
";
$rs->MoveNext();
}
?>
文章来源:http://myslan.bokee.com/538714.html