<?php //读取mdb数据库例程 $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb"); $conn->Open($connstr); $rs = new com("ADODB.RecordSet"); $rs->Open("select * from userinfo",$conn,1,1); while(! $rs->eof) { $f = $rs->Fields(1); echo $f->value; echo " ". $rs->Fields(2)->value; $rs->MoveNext(); } ?> 2、PHP一般数据写入方法: <?php $connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("../chen416/mydata.mdb"); $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC); $issuetime=date("Y-m-d H:i:s"); $sql="insert into userinfo (username,userword,email) values('u2','w2','uw@163.com')"; $result=odbc_exec($connid,$sql); if($result) echo "successful"; else echo "failed"; ?> 3、PHP一般数据读取方法: <?php //读取mdb数据库例程 $conn=new COM("ADODB.Connection"); $dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("../mydata.mdb").";"; //Uid=Admin; Pwd=BDC2002Data; $conn->open($dsn); $sql="select * from userinfo"; $rs=$conn->Execute($sql); $row="0"; while(!$rs->EOF) { $string =""; for ($i=0;$iFields->count;$i++) { if ($i==0) { $string.=$rs->Fields($i)->Value; continue; } $string.='|'.$rs->Fields($i)->Value; } $string.="/n"; if ($row==300) { break; } $row++; echo "
"; echo $string; $rs->MoveNext(); } ?> 4、PHP删除数据方法: <?php $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb"); $conn->Open($connstr); $query = "delete from userinfo where uid=1"; $result =$conn->Execute($query); if($result) echo "删除成功"; else echo "删除失败"; ?> 5、PHP更新数据方法: <?php $conn = new com("ADODB.Connection"); $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb"); $conn->Open($connstr); $query = "update userinfo set username='ganjun' where uid=2"; $result =$conn->Execute($query); if($result) echo "更新数据成功"; else echo "更新数据失败"; ?>
php access实例下载,PHP+ACCESS 实例
最新推荐文章于 2022-07-22 16:34:59 发布