$7.49 .com domain with free InstantPage Website Builder$1.99 Web Hosting   捷飞网络官方淘宝店   Godaddy 优惠码
返回列表 发帖
分享到:




[PHP 语言] PHP读取access 数据库的部分方法实例

  1. <?php
  2. //读取mdb数据库例程
  3. $conn = new com("ADODB.Connection");
  4. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("./SpiderResult.mdb");

  5. $conn->Open($connstr);
  6. $rs = new com("ADODB.RecordSet");
  7. $rs->Open("select * from Content",$conn,1,1);
  8. while(! $rs->eof)
  9. {
  10. echo $rs->Fields(1)->value;
  11. echo "<br>";
  12. echo $rs->Fields(2)->value;
  13. echo "<br>";
  14. echo $rs->Fields(3)->value;
  15. echo "<br>";
  16. echo "<hr>";
  17. $rs->MoveNext();
  18. }
  19. ?>
复制代码

5 ]1 u' W2 H* L  y8 m, D) W% q% b1 ~9 }8 M7 b* S
1. PHP一般数据读取方法:7 \( h+ r4 I2 A' e" C% P; ~6 f
' i* \; o/ N  N) Q4 b  r( F7 I' \
  1. <?php //读取mdb数据库例程
  2. $conn = new com("ADODB.Connection");
  3. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb");
  4. $conn->Open($connstr);
  5. $rs = new com("ADODB.RecordSet");
  6. $rs->Open("select * from userinfo",$conn,1,1);
  7. while(! $rs->eof) {
  8. $f = $rs->Fields(1);
  9. echo $f->value;
  10. echo "  ". $rs->Fields(2)->value;
  11. $rs->MoveNext();
  12. }
  13. ?>
复制代码

! |" m: \0 p  i& u
4 R* `% E, |0 g( ^1 C5 A9 U( P/ o: ^1 k2 k5 [6 q
2. PHP一般数据写入方法:1 q, r; b$ n1 z/ ?5 y7 n. n1 c
+ ]$ _% T. s: n; y, ?  E/ l2 M
3 M- A4 L; \( _# e0 x
  1. <?php
  2. $connstr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("../chen416/mydata.mdb");
  3. $connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC);
  4. $issuetime=date("Y-m-d H:i:s");
  5. $sql="insert into userinfo (username,userword,email) values('u2','w2','uw@163.com')";
  6. $result=odbc_exec($connid,$sql);
  7. if($result) echo "successful";
  8. else echo "failed";
  9. ?>
复制代码
7 L, I: k. v& R0 K* c' g$ u% X+ l

' n( z! `/ A# l, P& c1 h: v1 b! G- s; p  k1 Z5 A" i* |
3、PHP一般数据读取方法:
4 u, l6 G3 d2 q2 o$ l4 {9 l: O" C6 e! {1 {# k( [

6 B. `) k! l. q8 Z- G! H) k/ b8 D
  1. <?php //读取mdb数据库例程
  2. $conn=new COM("ADODB.Connection");
  3. $dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("../mydata.mdb").";";
  4. //Uid=Admin; Pwd=BDC2002Data;
  5. $conn->open($dsn);
  6. $sql="select * from userinfo";
  7. $rs=$conn->Execute($sql);
  8. $row="0";
  9. while(!$rs->EOF)
  10. {
  11. $string ="";
  12. for ($i=0;$i<$rs->Fields->count;$i++)
  13. {
  14. if ($i==0)
  15. {
  16. $string.=$rs->Fields($i)->Value;
  17. continue;
  18. }
  19. $string.='|'.$rs->Fields($i)->Value;
  20. }
  21. $string.="\n";
  22. if ($row==300)
  23. {
  24. break;
  25. }
  26. $row++;
  27. echo "<br>";
  28. echo $string;
  29. $rs->MoveNext();
  30. }
  31. ?>
复制代码

0 b) M+ a' t, P: X9 |& Q; {- @6 G
! v" t* F, w6 Z, b- @# ^6 ~+ P, ?& ^# ^4 a" l
4、PHP删除数据方法:
- d/ ^, a- T7 s& x% e3 e
$ G" o6 y: h4 }- ~0 n& ]+ e" s  m8 }+ Z/ q! R1 G7 q
  1. <?php
  2. $conn = new com("ADODB.Connection");
  3. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb");
  4. $conn->Open($connstr);

  5. $query = "delete from userinfo where uid=1";
  6. $result =$conn->Execute($query);

  7. if($result)
  8. echo "删除成功";
  9. else
  10. echo "删除失败";

  11. ?>
复制代码

8 P: x+ O3 F& Z7 k' T) r) _
1 j4 V. v4 w- \4 e2 i6 c' `& a! [0 w* `3 f7 J; `7 _9 H) s: \: j8 f
5、PHP更新数据方法:
5 ~; D# {6 x) f$ s: ^8 s
/ H5 L6 g% e# W* G) u4 ^: \
  1. <?php
  2. $conn = new com("ADODB.Connection");
  3. $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("../mydata.mdb");
  4. $conn->Open($connstr);

  5. $query = "update userinfo set username='ganjun' where uid=2";
  6. $result =$conn->Execute($query);

  7. if($result)
  8. echo "更新数据成功";
  9. else
  10. echo "更新数据失败";

  11. ?>
复制代码
0 o9 {3 I/ e; z  \# @

3 g$ K/ g. i4 _  x# u* F6 ~0 {* o9 q# s  f/ ~7 w% A3 E% ^
参考: http://blog.csdn.net/goodnew/article/details/19757485

美国VPS、域名代购:http://tu8l.taobao.com

返回列表
Namecheap
Namecheap.com - Cheap domain name registration, renewal and transfers - Free SSL Certificates - Web Hosting
互联网安全