git.m6w6.name Git - m6w6/ext-pq/blob - tests/bound002.phpt

   1 --TEST--
   2 fetch bound
   3 --SKIPIF--
   4 <?php
   5 include "_skipif.inc";
   6 if (!pq\Types::DEFINED) {
   7         die("skip pq\Types::DEFINED == false");
   8 }
   9 ?>
  10 --FILE--
  11 <?php
  12 echo "Test\n";
  13
  14 include "_setup.inc";
  15
  16 $c = new pq\Connection(PQ_DSN);
  17 $r = $c->exec("select 1*a,2*a,3*a from generate_series(2,3) a");
  18 $r->bind(0, $a);
  19 $r->bind(1, $b);
  20 $r->bind(2, $c);
  21 while ($s = $r->fetchBound()) {
  22         var_dump($s,$a,$b,$c);
  23 }
  24 ?>
  25 DONE
  26 --EXPECT--
  27 Test
  28 array(3) {
  29   [0]=>
  30   &int(2)
  31   [1]=>
  32   &int(4)
  33   [2]=>
  34   &int(6)
  35 }
  36 int(2)
  37 int(4)
  38 int(6)
  39 array(3) {
  40   [0]=>
  41   &int(3)
  42   [1]=>
  43   &int(6)
  44   [2]=>
  45   &int(9)
  46 }
  47 int(3)
  48 int(6)
  49 int(9)
  50 DONE