PHP连接ACCESS
来源:互联网 发布:mac media player加速 编辑:程序博客网 时间:2024/06/05 11:39
- <?PHP
- $conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("student.mdb");
- $conn->Open($connstr);
- ?>
- <table>
- <tr>
- <td>ID</td>
- <td>NAME</td>
- <td>text</td>
- </tr>
- <?php
- $id1="中";
- $id= iconv("UTF-8","GBK",$id1);
- $sql="select * from s where s_name like '%".$id."%'";
- $rs = @new COM("ADODB.RecordSet");
- $rs->Open($sql,$conn,1,3);
- while(!$rs->eof)
- {
- ?>
- <tr>
- <td><?php echo $rs->Fields["s_id"];?></td>
- <td><?php echo $rs->Fields["s_name"];?></td>
- <td></td>
- <td></td>
- </tr>
- <?php
- $rs->Movenext();
- }
- $rs->close;
- ?>
- </table>