Question

php 连接ACCESS数据库成功后 如何读取数据库数据

<?php//读取mdb数据库的值    $connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("data/admin.mdb");     $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);      $sql="select * from admin";      $result=odbc_exec($connid,$sql);   ?>上面的代码已经能够连接到数据库了，请问怎么才能遍历读取数据库里的数据呢

Answer 1

$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";

Answer 2

用ADO行不行