php 连接ACCESS数据库成功后 如何读取数据库数据
<?php//读取mdb数据库的值 $connstr="DRIVER={MicrosoftAccessDriver(*.mdb)}...
<?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); ?>上面的代码已经能够连接到数据库了,请问怎么才能遍历读取数据库里的数据呢
展开
展开全部
$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";
$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";
参考资料: http://www.1lou.net
推荐律师服务:
若未解决您的问题,请您详细描述您的问题,通过百度律临进行免费专业咨询