本文章提供一款php 连接 access数据库与修改删除增加数据实例哦，首页我们来告诉你利用php 连接 access数据库然后再增加，修改，编辑，显示删除以及数据的分页效果源码。
| 代码如下 |
复制代码 |
$conn = new com("adodb.connection");
$conn->open("driver={microsoft access driver (*.mdb)}; dbq=".db_path.";uid=;pwd=;"); $rs=new com("adodb.recordset");
$rs->open("select * from [article] order by [articleid]",$conn,1,3);
$rs->pagesize=5;
$page=trim($_get['page']);
if($page=="" || is_numeric(intval($page))<=0){$page=1;}else if(intval($page)>$rs->pagecount){$page=$rs->pagecount;}
$page=intval($page);
if(!$rs->eof||$rs->bof){
$rs->absolutepage=$page; $mypagesize=$rs->pagesize; $i=$rs->recordcount()-($page-1)*$rs->pagesize;
while(!$rs->eof && $mypagesize>0 && $i>=$rs->recordcount()-1-$rs->pagesize*$page){
$articleid = $rs->fields(0)->value;
$articletitle = $rs->fields(1)->value; ?>
<li><a href="detail.php?id=<? echo $articleid; ?>"><? echo $articletitle; ?></a><span><? echo $articlei; ?></span></li>
<? $rs->movenext; $mypagesize--; $i--; } } ?>
</ul>
</div>
</div>
<div id="page">
<a href="index.php?page=1">头页</a> <a href="index.php?page=<? if($page>1){echo $page-1;}else{echo 1;}?>">上页</a> <a href="index.php?page=<? if($page<$rs->pagecount){echo $page+1;}else{echo $rs->pagecount;}?>">下页</a> <a href="index.php?page=<? echo $rs->pagecount;?>">尾页</a> 共<? echo $rs->recordcount(); ?>篇文章，分<? echo $rs->pagecount;?>页显示，现在是第<? echo $page;?>页
</div>
<!-- |
源码下载
http://www.phprm.com
本文地址：http://www.phprm.com/database/35878.html
转载随意，但请附上文章地址:-)