php ADO组件连接access数据库的例子

3. /*

4. * 创建ADO连接
5. */
6. $conn = new COM("ADODB.Connection") or die ("ADO Connection faild.");
7. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("test.mdb");
8. $conn->open($connstr);
9. /*
10. * 创建记录集
11. */
12. $rs = new COM("ADODB.RecordSet");
13. $rs->open("select * from lhl",$conn,1,3);
14. /*
15. * 循环读取数据
16. */
17. while(!$rs->eof){
18. echo $rs->fields['G_date']->Value;
19. echo "
    ";
20. $rs->movenext(); //将记录集指针下移
21. }
22. $rs->close();

23. //ADO组件实例学习 by bbs.it-home.org

24. ?>

复制代码