Three methods for connecting php to access database _ PHP Tutorial

Three methods for connecting php to the access database. One is to use php pdo, and the other is odbc and com interfaces to connect to the access database. The code for connecting to the access database using pdo is as follows: $ pathf: fontwww. jb51.netspiderresult. one is to connect to the access database using the pdo of php, the other is odbc and com interfaces.
Use pdo to connect to the access Database

The 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

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 );

Bytes. The code for connecting to the access database using pdo is as follows: $ path = "f: fontwww. jb51.netspiderresult...