- 帖子
- 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();
- }
- ?>
复制代码 4 Y8 Z9 W; ~9 E# b* j
/ ~: r$ x5 G2 T8 [3 d8 C1. PHP一般数据读取方法:
9 q. s$ S" q0 {3 ^0 M2 q9 L- v$ x y4 A6 @ S
- <?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();
- }
- ?>
复制代码 & ]% w- C8 r0 V/ [8 c# v
1 R2 h7 Y8 }" F; ~5 ^" Y. q o4 {- y8 W( U _9 V
2. PHP一般数据写入方法:9 X8 d8 }, U4 I+ }
/ R+ O; V5 n' u4 A! n5 v5 U4 m6 q, \
- <?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','[email protected]')";
- $result=odbc_exec($connid,$sql);
- if($result) echo "successful";
- else echo "failed";
- ?>
复制代码
5 H2 D6 |6 u4 B1 l- m; I& t: p' _8 D6 L( a! H
$ `, I7 l: y3 y$ l
3、PHP一般数据读取方法:9 w y" C, R ]+ A8 ^3 ]$ i! G
8 X9 Q+ C+ x+ O$ [' R l8 n
( w2 _% z* g; I- <?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();
- }
- ?>
复制代码
9 b& V" D* L6 W2 ~9 X- I
; U3 v8 e7 _# [# ~3 z' h- l, b$ [ Z! c2 U" L2 z. {/ v
4、PHP删除数据方法:) K4 J \ a5 G; N2 }7 m. s' x7 Y
1 Q9 d* [' a4 N$ a+ n' V( ~% E' m v9 e
- <?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 "删除失败";
- ?>
复制代码 6 w( J/ p/ S9 F& \% F
' c4 P7 H+ A+ e2 n7 i( z& \' {8 `9 O! y; ~# ?' F
5、PHP更新数据方法:, A2 B) c& C* ]/ P3 {" h6 Q m
% F! t- [2 G2 L6 V- <?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 "更新数据失败";
- ?>
复制代码
* f2 C! @- s S! h3 L; c+ l3 r
, n6 i/ O. x% c
! }% D1 `6 T' ] W8 c参考: http://blog.csdn.net/goodnew/article/details/19757485 |
|