This article provides three methods for connecting php to the access Database: Using pdo of php, and using odbc and com interfaces to connect to the access database.
Use pdo to connect to the access Database
The Code is as follows:
$ Path = "f: fontwww. php. netspiderresult. mdb ";
$ Conn = new pdo ("sqlite: $ path ");
If ($ conn)
{
Echo ('Connection pdo success ');
}
Else
{
Echo ('cnnection pdo fail, plase check database server! ');
}
Use odbc_connect to connect to the database
The Code is as follows:
$ Conn = odbc_connect ("dbdsn", "admin", "123"); // connect to the data source
$ Doquery = odbc_exec ($ conn, "select * from table name where condition"); // execute the query
Use the com interface to connect to the access Database
$ Conn = new com ("adodb. connection ");
$ Dsn = "driver = {microsoft access driver (*. mdb)}; dbq =". realpath ("path/db1.mdb ");
$ Conn-> open ($ dsn );