- 帖子
- 212
- 主题
- 189
- 精华
- 0
- 积分
- 1452
- 贡献
- 1134
- 激情
- 1349
- 阅读权限
- 100
- 最后登录
- 2018-6-13
|
- <?php
- //读取mdb数据库例程
- $conn = new com("ADODB.Connection");
- $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./SpiderResult.mdb");
- $conn->Open($connstr);
- $rs = new com("ADODB.RecordSet");
- $rs->Open("select * from Content",$conn,1,1);
- while(! $rs->eof)
- {
- echo $rs->Fields(1)->value;
- echo "<br>";
- echo $rs->Fields(2)->value;
- echo "<br>";
- echo $rs->Fields(3)->value;
- echo "<br>";
- echo "<hr>";
- $rs->MoveNext();
- }
- ?>
复制代码
# c. I2 T8 @- z! o! B
4 h! v# v' `* K+ f5 n/ ^1. PHP一般数据读取方法:
" r* H0 Z$ k$ E% G. f a) g0 o/ P+ T* o
- <?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();
- }
- ?>
复制代码 / E/ s; i/ l" T
# d/ c+ G5 L6 g
: J6 I9 @. t. o; j2. PHP一般数据写入方法:. j& E* x `3 N1 k7 @
4 N4 d% n! r* S- @
/ R5 d9 x% Y# u- <?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";
- ?>
复制代码
7 B9 T& B! b4 [ h( V: p" `/ W T. X& M
" V5 E8 ?3 n# \& a3、PHP一般数据读取方法:
4 k& S% P) r1 x! f$ T9 n$ L
- O& |5 _' `# T9 N2 |* i# Y3 B. R. A w e4 P- {- v
- <?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;$i<$rs->Fields->count;$i++)
- {
- if ($i==0)
- {
- $string.=$rs->Fields($i)->Value;
- continue;
- }
- $string.='|'.$rs->Fields($i)->Value;
- }
- $string.="\n";
- if ($row==300)
- {
- break;
- }
- $row++;
- echo "<br>";
- echo $string;
- $rs->MoveNext();
- }
- ?>
复制代码
7 A% {0 Q5 y6 g9 ^- W7 b
/ P6 Y: g# c( L5 N' s% f, ]* | U0 a+ e
4、PHP删除数据方法:6 N' \% V( L; t d Z8 ^0 q, u
6 i2 Z7 F/ |+ X8 b8 t& N9 n4 c/ B, Y2 u# [; e0 c
- <?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 "删除失败";
- ?>
复制代码
4 U0 m, g* c& e% h0 M! F
4 l7 x7 R5 j# [
1 Q" w6 X: H% I5、PHP更新数据方法:
1 @, h$ v7 m( B. U' V* D x4 y: r& s& F! ?! P
- <?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 "更新数据失败";
- ?>
复制代码 : E, Y) o. V$ S
' u" Y" A/ F ^, w' T
0 r L: G5 e/ t' x' b! J参考: http://blog.csdn.net/goodnew/article/details/19757485 |
|