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; ?>