PHP与ACCESS数据操作

首先，数据库连接。以下语句为示例语句，请根据实际情况修改
$conn = @new COM(“ADODB.Connection”) or die (“ADO Connection faild.”);
$connstr = “DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=” . realpath(“data.mdb”);
$conn->Open($connstr);

数据查询
$rs = @new COM(“ADODB.RecordSet”);
$rs->Open(“select * from user”,$conn,1,3);
/* 循环读取数据 */
while(!$rs->eof){
echo $rs->Fields["username"];
echo “<br/>”;
$rs->Movenext();
}

数据更新
$rs = @new COM(“ADODB.RecordSet”);
$username = “xefan.cn”;
$password = www.xefan.cn;
$rs->Open(“update user set username=’$username’,password=’$password’ where id=15″,$conn,1,3);

数据插入
$rs = @new COM(“ADODB.RecordSet”);
$username = “xefan.cn”;
$password = www.xefan.cn;
$rs->Open(“insert into user (username,password) values (‘$username’,'$password’)”,$conn,1,1);

数据删除
$rs = @new COM(“ADODB.RecordSet”);
$rs->Open(“delete from user where id=13″,$conn,1,1);

关闭连接
$conn->close();