Pdo connection to access database code _ PHP Tutorial

Code for connecting to the access database with pdo. Pdo connection access database tutorial code php Tutorial. ini needs to be opened: extensionphp_pdo.dllextensionphp_pdo_odbc.dll database is acc. mdb. to prevent malicious download, change to acc. phpt pdo connection access database tutorial code
// Php Tutorial. ini needs to be opened:
// Extension = php_pdo.dll
// Extension = php_pdo_odbc.dll
// The database is acc. mdb. to prevent malicious downloads, change to acc. php.

Try {
$ Db = new pdo ("odbc: driver = {microsoft access driver (*. mdb)}; dbq = ". getcwd (). "\ acc. php ", 'AAA', '123'); // The getcwd () function is used to obtain the current path.
// Echo "connectedn ";

Date_default_timezone_set ('Asia/Shanghai'); // Beijing time
$ V = "test". date ("y-m-d h: I: s"). "added content ";
$ Db-> exec ("insert into table1 (topic) values ('$ V')"); // insert
// Echo $ db-> lastinsertid (); // not supported
$ Rs = $ db-> query ("select * from table1"); // select
While ($ row = $ rs-> fetch ()){
Echo $ row [id]. "-". $ row [topic]."
";
};

} Catch (exception $ e ){
// Echo "failed:". $ e-> getmessage ();
}

Tutorial // php Tutorial. ini needs to be opened: // extension = php_pdo.dll // extension = php_pdo_odbc.dll // The database is acc. mdb. to prevent malicious downloads, change to acc. php t...