access数据库名为data.mdb,里面有一个数据表test,代码运行成功,希望对要使用PHP+Access做php程序的人有所帮助,实例代码如下:
- <?php
- $connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data.mdb");
- $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
- $issuetime=date("Y-m-d H:i:s");
- $sql="insert into test values("","",...)";
- $result=odbc_exec($connid,$sql);
- if($result) echo "successful";
- else echo "failed";
- ?>
|