4 <?php include "_skipif.inc"; ?>
11 $con = new pq\Connection(PQ_DSN);
12 $res = $con->exec("SELECT 1 as one, 2 as two from generate_series(1,2)");
14 var_dump($res->status == pq\Result::TUPLES_OK);
15 var_dump($res->numRows);
16 var_dump($res->numCols);
17 var_dump(count($res) == $res->count(), $res->numRows == count($res));
19 foreach ($res as $rowNum => $rowData) {
20 printf("%d.0 => %d\n", $rowNum, $rowData[0]);
21 printf("%d.1 => %d\n", $rowNum, $rowData[1]);
23 $res->fetchType = pq\Result::FETCH_ASSOC;
24 foreach ($res as $rowNum => $rowData) {
25 printf("%d.0 => %d\n", $rowNum, $rowData["one"]);
26 printf("%d.1 => %d\n", $rowNum, $rowData["two"]);
28 $res->fetchType = pq\Result::FETCH_OBJECT;
29 foreach ($res as $rowNum => $rowData) {
30 printf("%d.0 => %d\n", $rowNum, $rowData->one);
31 printf("%d.1 => %d\n", $rowNum, $rowData->two);