Php access Database code

Php connection to access database tutorial code below provides three php connection to access database methods, one is to use php pdo, one is odbc, com interface to connect to access database Oh. * Use pdo to connect to the access database $ pathf: font; $ connnewpdo (sqlite: $ path); if ($ conn) {echo (connecti

Php connection to access database tutorial code below provides three php connection to access database methods, one is to use php pdo, one is odbc, com interface to connect to access database Oh. * // Use pdo to connect to the access database $ path = f: font; $ conn = new pdo (sqlite: $ path); if ($ conn) {echo ('connecti

Php connection to access database tutorial code

The following three methods are provided to connect php to the access Database: one is using php's pdo, and the other is using odbc and com interfaces to connect to the access database.

*/

// Use pdo to connect to the access Database

$ Path = "f: font ";

$ 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

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