Pear DB 新手入门指南2

<?phpPHPChina 开源社区门户v9W
bmoJ
x

  // Once you have a valid DB Result object
nw3H
nd
g]:Yu0
  ...PHPChina 开源社区门户j!S5c?%K4W

  // Get each row of data on each iteration untilPHPChina 开源社区门户^+G*\c#B

  // there is no more rows
+?z"nzgv	PED0
  while ($row = $result->fetchRow()) {PHPChina 开源社区门户%S3I
RRw7Z-V6P

      $id = $row[0];PHPChina 开源社区门户JbyNN*@

  }
'o#l-d0S(AU%DY_0
  ?>

<?php
kTIA:xG
E&n0
  ...PHPChina 开源社区门户9YMQ
x
C#l4_5{

  while ($result->fetchInto($row)) {
`}H}.`V9N
Uu;^v0
      $id = $row[0];PHPChina 开源社区门户RCl#CPO5Z U

  }PHPChina 开源社区门户8MB9b1V+P1@)k2o

  ?>

<?php
-s,BVP	Sa*q8@{0
  $res = $db->query('select id, name, email from users');
't0XU_ c'C,Jt0K0
  $row = $res->fetchRow($mode);
8@g_D$OV$p.t0
  
5|$eCu@k(zv0
  //With $mode = DB_FETCHMODE_ORDERED
6F:wa E:]!_Li"P
W0
  //The default behavīor is to return an ordered array.PHPChina 开源社区门户+|C*Gs'R&Ea	^v

  $row = array (
;t.sq+W:l
p0
      0 => <column "id" data>,
-n)f$V!TM|+}&[0
      1 => <column "name" data>,
9},~{w1wV['ix0
      2 => <column "email" data>
_8y3Nz!_Y)z
Vc
?0
  );
%Z$GM{	k#`.B0
  
&X,XzPSo^0
  $id = $row[0];PHPChina 开源社区门户4]%e*ns#h

  
oJ7ci1J@8yzP0
  //With $mode = DB_FETCHMODE_ASSOC
+e;Aqx1u3E/O!s!k-d0
  //Returns an associative array with column names as array keys:PHPChina 开源社区门户t9RC(z0q/zR-\
D

  $row = array (
Y
]IZL:O(y0
      'id'    => <column "id" data>,PHPChina 开源社区门户9fM&g{ N2Q%]

      'name'  => <column "name" data>,
1^#l-y(t4sd&n4m,}L0
      'email' => <column "email" data>PHPChina 开源社区门户V7P5^z4a!g x

  );

|l4y[4n eXz0c0
  PHPChina 开源社区门户C-H
x#O:}AE	A

  $id = $row['id'];
Uq0y/p+X7L0
  
O vV{"o6K2a+MD0
  //With $mode = DB_FETCHMODE_OBJECTPHPChina 开源社区门户#C6S[-o2m3gK;z

  //Returns a DB_row object with column names as properties:PHPChina 开源社区门户6~mm8TWQ3m	wBB

  $row = db_row Object 
Q
\M/e'v
t;@0
  (
/]8\2TyTixL0
      [id]    => <column "id" data>,
U-^
Q-h9qU	z
]x0
      [name]  => <column "name" data>,PHPChina 开源社区门户1NP\/F8Ax"@x6VD2V

      [email] => <column "email" data>PHPChina 开源社区门户sJ6I+R7G Aj%w

  )PHPChina 开源社区门户0Kz8X^F!M(FT3`\

  PHPChina 开源社区门户Z|T8T5{!@
YTB

  $id = $row->id;PHPChina 开源社区门户6e[sA4gAo;s0X
N

  ?>

<?php
Wx
]yc'}c,H*n0
  ...PHPChina 开源社区门户1}8Ot+@d/F`

  // 1) Set the mode per call:PHPChina 开源社区门户~RRT B}U.r

  while ($row = $result->fetchRow(DB_FETCHMODE_ASSOC)) {PHPChina 开源社区门户,u]#]:@$yLE

      [..]
6D}B4{U9v0
  }
 Ia)x9CR4e0
  while ($result->fetchInto($row, DB_FETCHMODE_ASSOC)) {
:zE!lC7b0
      [..]
"W	cJV,hSh!dO
o9^s"g0
  }
D4VD-K.~;~:yP0
  PHPChina 开源社区门户'VgH(^K)EV.U

  // 2) Set the mode for all calls:PHPChina 开源社区门户/l
eWv'BM4v&\

  $db = DB::connect($dsn);
&s?z?1Eo?[;m0
  // this will set a default fetchmode for this Pear DB instance
L+AN?Kyspn0
  // (for all queries)
ojM+T4t8[0
  $db->setFetchMode(DB_FETCHMODE_ASSOC);
;US#dv"G+f~0
  $result = $db->query(...);PHPChina 开源社区门户*J1M(iX7S6jSp*Jr

  while ($row = $result->fetchRow()) {PHPChina 开源社区门户3c3Uj-V%pVl3Y
i

      $id = $row['id'];PHPChina 开源社区门户qr8s
g7T3A!N9f*m

  }PHPChina 开源社区门户5d,L6O9FMV

  ?>

<?phpPHPChina 开源社区门户UL(U+q;U;w

  ...
;?I'Sf._y'x0
  // the row to start fetching
*vn3~Hi;}~,X0
  $from = 50;PHPChina 开源社区门户-Dz;n7p0ZV]8G

  // how many results per pagePHPChina 开源社区门户*rPu{ BD(rEG

  $res_per_page = 10;
Z-PUJN8gu0
  // the last row to fetch for this page
JV_7o
P}U0
  $to = $from + $res_per_page;
	q	?YA
Q9V
vwt0
  foreach (range($from, $to) as $rownum) {PHPChina 开源社区门户lZ?	X3f
Q-rzXz

      if (!$row = $res->fetchrow($fetchmode, $rownum)) {
x3mz`%Q5vo)h0
          break;
:m wpsX]| qDR4\7B0
      }PHPChina 开源社区门户6GOlzh
z
K5kp

      $id = $row[0];
DqP1_-pT9R8q5m%W0
      ....PHPChina 开源社区门户;YE+s?	n+I

  }PHPChina 开源社区门户LG c`:ak3d$D

  ?>

<?php
	bcG1RDH&g%}0
  ...PHPChina 开源社区门户Jj-n`,C+gH*S

  $result = $db->query('SELECT * FROM clients');PHPChina 开源社区门户,sPCykXs"h

  while ($row = $result->fetchRow()) {
j%ZR}+f'Gcwu1Q%H0
      ...PHPChina 开源社区门户lm$E oB.aDQL6n

  }PHPChina 开源社区门户~UFt:n"ts$l[

  $result->free();PHPChina 开源社区门户,caTiC3a%j

  ?>