Home >Backend Development >PHP Tutorial >PHP adodb connection with password access database instance, test successful
<? include('./class/adodb/adodb.inc.php'); //实例化db类,链接 $db = ADONewConnection('ado_access'); $access = realpath('./rs.mdb'); $myDSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;'.'DATA SOURCE='. $access . ';'."Jet OLEDB:Database Password=123456;"; $db->Connect($myDSN); $recordSet = $db->Execute('select * from tt'); if (!$recordSet) print $db->ErrorMsg(); else while (!$recordSet->EOF) { print $recordSet->fields[0].' '.$recordSet->fields[1].'<BR>'; $recordSet->MoveNext(); } $recordSet->Close(); # 选择性执行 $db->Close(); # 选择性执行 ?>
For more php adodb connection with password access database examples, please pay attention to PHP Chinese website for related articles about successful test!