Three methods for connecting php to access database

One is to use php pdo, and the other is odbc and com interfaces to connect to the access database.
Use pdo to connect to the access Database
 Copy codeThe Code is as follows:
$ Path = "f: fontwww. jb51.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
 Copy codeThe 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 );