PHP 通过 ADODB 连接 Access 的一个实例~~~~
<?php
include(‘tohtml.inc.php’); // load code common to ADODB
include(‘adodb.inc.php’); // load code common to ADODB
$db = &ADONewConnection(“ado_access”);
print “<h1>Connecting $db->databaseType…</h1>”;
$access = ‘test.mdb’;
$myDSN = ‘PROVIDER=Microsoft.Jet.OLEDB.4.0;’.’DATA SOURCE=’. $access . ‘;’;.’USER ID=;PASSWORD=;’;
if (@$db->PConnect($myDSN, “”, “”, “”)) {
print “ADO version=”.$db->_connectionID->version.”<br />”;
$sql = ‘select name, group1 from experts’;
$rs = $db->Execute($sql);
rs2html($rs,’border=2 cellpadding=3′,array(‘Customer Name’,’Customer ID’));
} else print “ERROR: Access test requires a Access database $access”.'<br />’.$db->ErrorMsg();
?>
//下面是今晚我自己的测试代码.
<?php
include(“adodb.inc.php”);
$db=&ADONewConnection(“ado_access”); //设定以ADO_ACCESS方式连接数据库.
$access = “d:\\WWW\\test\\test.mdb”; //设定ACCESS数据库的路径. PHP可以用 _FILE_ _DIR_ 常量来获取吧?? 忘记了./:D 注意路径用 双 \ ,调试中走了些弯路.
$myDSN=”Provider=Microsoft.Jet.OLEDB.4.0;”.”DATA SOURCE=”.$access.”;”.” USER ID=;PASSWORD=;”; //连接 字串
if(@$db->Connect($myDSN,””,””,””)){ // 如果连接成功的话,
$sql=”SELECT * FROM USER“; //设置SQL语句
$rs=$db->Execute($sql); //运行 SQL语句查询
while($rs->MoveNext()){ //循环整个 RecordSet
for($i=0;$i<count($rs->fields);$i++) echo “$i is :”.$rs->fields[$i].”<br />”; //输出 每个字段的值.
}
// 上面这段是 Select 查询
$sql=”UPDATE USER SET Id=’14’ WHERE Id=’13′”;
$rs=$db->Execute($sql);
//上面这段是 Update 查询
$sql=”INSERT INTO USER (Id,Domains,Ftpuser,Ftppass,ChangePassword,HomeDir,RelPaths,AlwaysAllowLogin,DiskQuota,TimeOut,Access1) VALUES (’15’,’Domain1′,’Shelly’,’Shelly’,’1′,’F:\’,’1′,’1′,’14400′,’300′,’F:\|RWL’)”;
$rs=$db->Execute($sql);
// 上面这段是 Insert into 查询
}
else die (“Connect error”.$db->ErrorMsg()); //如果连接出错,就给出出错信息.
$db->Close(); //关闭连接.
上面就是关于用 PHP 调用ADODB 类库 对Access 数据库操作的实例. 希望对您有用. /:D 有其它论坛记得 TrackBack Me…..