How does php connect to the access database?
I would like to share a php code for connecting to the access database. there are multiple methods for connecting the php code to access. you can use these methods through instances.
- */
- // Use pdo to connect to the access Database
- $ Path = "f: fontbbs. it-home.orgspiderresult.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
- $ 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 );
|
Access, database
