PHP如何连接Access数据库

PHP代码:

1. <?php
2. $connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" .realpath("data.mdb");
3. $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
4. $issuetime=date("Y-m-d H:i:s");
5. $sql="insert into test values("","",...)";
6. $result=odbc_exec($connid,$sql);
7. if($result) echo "successful";
8. else echo "failed";
9. ?>

之二：

1. <?PHP
2. //创建ADO连接
3. $conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
4. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" .realpath("temp/TempData.mdb");
5. $conn->Open($connstr);
6.  
7. //创建记录集查询
8. $rs = @new COM("ADODB.RecordSet");
9. $rs->Open("select * from blog_Content",$conn,1,3);
10. echo $rs->Fields["log_Title"]->Value;    //输出log_Title字段
11. echo "<br/>";
12. $rs->Movenext();    //将记录集指针下移
13. echo $rs->Fields["log_Title"]->Value;
14. $rs->close();
15. ?>

转载于:https://www.cnblogs.com/aliyunjishu/p/4819538.html