php连接access
php 连接 access 的 demo:<?
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
// Microsoft Access connection string.
$conn->Open("DRIVER={Microsoft Access Driver(*.mdb)};DBQ=C:\\inetpub\\wwwroot\\php\\mydb.mdb");
//SQL statement to build recordset.
$rs = $conn->Execute("SELECT myfield FROM mytable");
echo "<p>Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.</p>";
//Display all the valus in the records set
while(!$rs->EOF){
$fv = $rs->Fields("myfield");
echo "Value:".$fv->value."<br>\n";
$rs->MoveNext();
}
$rs->Close();
?>
转自:http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/123709
页:
[1]