PHP与Oledb [英] PHP with Oledb
本文介绍了PHP与Oledb的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以将PHP与Oledb连接一起使用吗?
Can I use PHP with Oledb connection?
据我所知,PHP扩展提供的数据库连接都是odbc.
As far as I know database connection as provided by PHP extension are all odbc.
推荐答案
您可以在PHP-Win中使用ActiveX数据对象(Microsoft的OLEDB ActiveX层),而无需任何第三方扩展,例如:
You can use ActiveX Data Objects (Microsoft's OLEDB ActiveX layer) in PHP-Win without any third party extension as such:
$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 "<p>Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.</p>";
// Display all the values in the records set
while (!$rs->EOF) {
$fv = $rs->Fields("myfield");
echo "Value: ".$fv->value."<br>\n";
$rs->MoveNext();
}
$rs->Close();
这篇关于PHP与Oledb的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文