给分吧
<?php //读取mdb数据库例程
$conn = new com("ADODB.Connection");
$connstr = 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ='c:\db1.mdb'; $conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from player",$conn,1,1);
while(! $rs->eof) {
$f = $rs->Fields(1);
echo $f->value;
$rs->MoveNext();
} ?>
<?php //读取mdb数据库例程
$conn = new com("ADODB.Connection");
$connstr = 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ='c:\db1.mdb'; $conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from player",$conn,1,1);
while(! $rs->eof) {
$f = $rs->Fields(1);
echo $f->value;
$rs->MoveNext();
} ?>
$connstr = 'DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=c:\db1.mdb';
$conn=odbc_connect("数据源名","用户名","密码");
$query="select field1,field2,field3 from test";
$result_id=odbc_do($conn,$query);
while (odbc_fetch_row($result_id))
{
$value1=odbc_result($result_id,1);
$value2=odbc_result($result_id,2);
$value3=odbc_result($result_id,3);
}
名称:db1(随便)
驱动程序:Microsoft Access Driver (*.MDB)代码:
...
$Conn = odbc_connect("db1","",""); //连接数据源
$Doquery=odbc_exec($Conn,"select * from 表名 where 条件");//执行查询
同上
...
第二种方式是ADO
...
$conn=new COM("ADODB.Connection");
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("path/db1.mdb");
$conn->open($dsn);
$sql="select * from 表名 where 条件";
$ru=$conn->Execute($sql);……
来点分吧,我要变两颗星:)