PHP访问Access数据库

//使用微软的ADODB数据库驱动

 

Demo:

$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("db1.mdb");
$conn=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
$query=odbc_do($conn,"select * from users");
while(odbc_fetch_row($query)){
        echo  odbc_result($query,2);
        echo "<br>";
 
}