The first method is to use ODBC to create a system data source for db1.mdb In the ODBC manager.
Name: dbdsn (set by yourself)
Driver: Microsoft Access Driver (*. mdb)
...
$ Conn = odbc_connect ("dbdsn", "admin", "123"); // connect to the data source
$ Doquery = odbc_exec ($ Conn, "select * from table name where condition"); // execute the query
...
The second method is ADO.
...
$ Conn = new COM ("ADODB. Connection ");
$ DSN = "driver = {Microsoft Access Driver (*. mdb)}; DBQ =". realpath ("path/db1.mdb ");
$ Conn-> open ($ DSN );
$ SQL = "select * from table name where condition ";
$ Ru = $ Conn-> execute ($ SQL );
...
Bytes --------------------------------------------------------------------------------------------
<? PHP
// Create An ADO connection
$ Conn = @ new COM ("ADODB. Connection") or die ("ADO connection failed! ");
$ Connstr = "driver = {Microsoft Access Driver (*. mdb)}; DBQ =". realpath ("db1.mdb ");
$ Conn-> open ($ connstr );
// Create a record set Query
$ Rs = @ new COM ("ADODB. recordset ");
$ RS-> open ("select * from Info", $ Conn, 1, 3 );
?>
<Table border = 1>
<Tr>
<TD> id </TD>
<TD> name </TD>
<TD> text </TD>
</Tr>
<? PHP
While (! $ RS-> EOF ){
?>
<Tr>
<TD> <? PHP echo $ RS-> fields ["ID"];?> </TD>
<TD> <? PHP echo $ RS-> fields ["name"];?> </TD>
<TD> <? PHP echo $ RS-> fields ["text"];?> </TD>
</Tr>
<? PHP
$ RS-> movenext ();
}
$ RS-> close ();
?>
</Table>