Files
archived-pecl-database-ibm-db2/tests/test_159a_FetchAssocSeveralRows_02.phpt
2009-02-09 09:41:37 +00:00

43 lines
927 B
PHP

--TEST--
IBM-DB2: db2_fetch_assoc() - several rows 2
--SKIPIF--
<?php require_once('skipif.inc'); ?>
--FILE--
<?php
require_once('connection.inc');
$conn = db2_connect($db,$user,$password);
$result = db2_exec($conn, "select prstdate,prendate from project");
$i=1;
while ($row = db2_fetch_assoc($result))
{
printf ("%3d %10s %10s\n",$i, $row['PRSTDATE'], $row['PRENDATE']);
$i++;
}
?>
--EXPECT--
1 1982-01-01 1983-02-01
2 1982-01-01 1983-02-01
3 1982-01-01 1983-02-01
4 1982-01-01 1983-02-01
5 1982-01-01 1983-02-01
6 1982-01-01 1983-02-01
7 1982-01-01 1983-02-01
8 1982-01-01 1983-02-01
9 1982-01-01 1983-02-01
10 1982-01-01 1982-12-01
11 1982-01-01 1982-12-01
12 1982-02-15 1982-12-01
13 1982-01-01 1983-02-01
14 1982-01-01 1983-02-01
15 1982-01-01 1983-02-01
16 1982-01-01 1983-02-01
17 1982-01-01 1983-02-01
18 1982-01-01 1983-02-01
19 1982-01-01 1983-02-01
20 1982-01-01 1982-09-15