git.m6w6.name Git - m6w6/ext-pq/blob - tests/bound001.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 == true");
   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   &string(1) "2"
  31   [1]=>
  32   &string(1) "4"
  33   [2]=>
  34   &string(1) "6"
  35 }
  36 string(1) "2"
  37 string(1) "4"
  38 string(1) "6"
  39 array(3) {
  40   [0]=>
  41   &string(1) "3"
  42   [1]=>
  43   &string(1) "6"
  44   [2]=>
  45   &string(1) "9"
  46 }
  47 string(1) "3"
  48 string(1) "6"
  49 string(1) "9"
  50 DONE