PDO Connect Access Database Tutorial code
PHP Tutorial. ini needs to be open:
Extension=php_pdo.dll
Extension=php_pdo_odbc.dll
Database is acc.mdb, to prevent malicious download, change to acc.php
try{
$DB = new PDO ("Odbc:driver={microsoft Access Driver (*.mdb)};d bq=". GETCWD (). " \acc.php ", ' aaa ', ' 123456 '); The GETCWD () function is to get the current path
echo "Connectedn";
Date_default_timezone_set (' Asia/shanghai '); GMT
$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"); Choose
while ($row = $rs->fetch ()) {
echo $row [id]. " -". $row [topic]."
";
};
} catch (Exception $e) {
echo "failed:". $e->getmessage ();
}
http://www.bkjia.com/PHPjc/630841.html www.bkjia.com true http://www.bkjia.com/PHPjc/630841.html techarticle PDO connect Access database Tutorial Code//php Tutorial. ini Required Open://extension=php_pdo.dll//extension=php_pdo_odbc.dll//database for Acc.mdb, to prevent malicious downloads , instead of acc.php t ...