//ODBC连接数据库 $cnx=odbc_connect("program","",""); if(!$cnx){ error_handler("ODBC_connect连接有错误",$cnx); } $cur=odbc_exec($cnx,"select * from diary"); if (!$cur){ error_hander("Odbc_exec运行有错,没有指针传回",$cur); } //取出成功的数据 $cur=odbc_exec($cnx,"select * from diary order by id desc"); while(odbc_fetch_row($cur)) { $title=odbc_result($cur,2); $id=odbc_result($cur,1); $content=odbc_result($cur,4); $date=odbc_result($cur,5); $images=odbc_result($cur,3); }
$cnx=odbc_connect("program","","");
if(!$cnx){
error_handler("ODBC_connect连接有错误",$cnx);
}
$cur=odbc_exec($cnx,"select * from diary");
if (!$cur){
error_hander("Odbc_exec运行有错,没有指针传回",$cur);
}
//取出成功的数据
$cur=odbc_exec($cnx,"select * from diary order by id desc");
while(odbc_fetch_row($cur))
{
$title=odbc_result($cur,2);
$id=odbc_result($cur,1);
$content=odbc_result($cur,4);
$date=odbc_result($cur,5);
$images=odbc_result($cur,3);
}
这里要绝对路径
改为
$connstr = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("database/mydb.mdb");