php代码 mdb管理,php链接MDB数据库代码示例

?>

例四：

try{

$path2="D:/myenv/Apache24/htdocs/www/xiongmaoxueyuan/xiongmaoxueyuan.accdb";

$db = new PDO("odbc:driver={microsoft access driver ( *.accdb)};dbq=".$path2);

echo "Connected success\n";

} catch (Exception $e) {

echo "Failed:".iconv('GB2312', 'UTF-8', $e->getMessage());

}

$rs = $db->query('select * from test');

print "

";

print_r($rs->fetchAll());

print "

";

例五：

$conn = new com("ADODB.Connection");

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("data/db.mdb");

$conn->Open($connstr);

$rs = new com("ADODB.RecordSet");

$rs->Open("select * from szd_t",$conn,1,1);

while(! $rs->eof) {

$f = $rs->Fields(1);

echo $f->value;

$rs->MoveNext();

}

?>

例六：

提供已知的几种连接方式：

1.

$conn = new com("ADODB.Connection");

$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("test.mdb");

$conn->Open($connstr);

2.

$conn=new com("ADODB.connection");

$connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=".realpath("test.mdb");

$conn->open($connstr);

3.

$connection = odbc_connect("Driver={Microsoft Access Driver (*.mdb)};Dbq=$mdbFilename", $user, $password);

在ThinkPhp的controller中由于存在命名空间，所以要使用“$conn = new \com("ADODB.Connection");”