- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
- <title>通过ADO方式连接ACCESS数据库 - www.cxybl.com</title>
- <link rel="stylesheet" type="text/css" href="style.css">
- <style type="text/css">
- <!--
- .STYLE1 {color: #FFFFFF}
- -->
- </style>
- </head>
- <?php
- include_once("conn.php");
- ?>
- <body topmargin="0" leftmargin="0" bottommargin="0">
- <table width="300" border="0" align="center" cellpadding="0" cellspacing="0">
- <tr>
- <td height="25" bgcolor="#0099CC"><div align="center" class="STYLE1">图书信息</div></td>
- </tr>
- <tr>
- <td bgcolor="#0099CC"><table width="300" height="50" border="0" align="center"
- cellpadding="0" cellspacing="1">
- <tr>
- <td width="167" height="25" bgcolor="#FFFFFF"><div align="center">书名</div></td>
- <td width="130" bgcolor="#FFFFFF"><div align="center">出版社</div></td>
- </tr>
- <?php
- $sql="select * from tb_book";
- $rs=new com("adodb.recordset");
- $rs->open($sql,$conn,1,3);
- while(!$rs->eof)
- {
- ?>
- <tr>
- <td height="25" bgcolor="#FFFFFF"><div align="center">
- <?php $fields=$rs->fields(bookname);echo $fields->value;?></div></td>
- <td height="25" bgcolor="#FFFFFF"><div align="center">
- <?php $fields=$rs->fields(pub);echo $fields->value;?></div></td>
- </tr>
- <?php
- $rs->movenext;
- }
- ?>
- </table></td>
- </tr>
- </table>
- </body>
- </html>
conn.php:
- <?php
- $conn = new com("adodb.connection");
- $connstr="driver={microsoft access driver (*.mdb)}; dbq=". realpath("data/db_database12_185.mdb");
- $conn->open($connstr);
- ?>
欢迎大家阅读《PHP通过ADO方式连接Access_php》,跪求各位点评,若觉得好的话请收藏本文，by 搞代码
搞代码网（gaodaima.com）提供的所有资源部分来自互联网，如果有侵犯您的版权或其他权益，请说明详细缘由并提供版权或权益证明然后发送到邮箱[email protected]，我们会在看到邮件的第一时间内为您处理，或直接联系QQ：872152909。本网站采用BY-NC-SA协议进行授权
转载请注明原文链接：PHP通过ADO方式连接Access_php
转载请注明原文链接：PHP通过ADO方式连接Access_php
