php oledb access,PHP与Oledb

您可以在PHP-Win中使用ActiveX数据对象(Microsoft的OLEDB ActiveX层),而不需要任何第三方扩展：

$conn = new COM("ADODB.Connection") or die("Cannot start ADO");

// Microsoft Access connection string.

$conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\inetpub\wwwroot\php\mydb.mdb");

// SQL statement to build recordset.

$rs = $conn->Execute("SELECT myfield FROM mytable");

echo "

Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.

";

// Display all the values in the records set

while (!$rs->EOF) {

$fv = $rs->Fields("myfield");

echo "Value: ".$fv->value."
\n";

$rs->MoveNext();

}

$rs->Close();