mirror of
https://github.com/php/pecl-database-ibm_db2.git
synced 2026-03-23 23:02:16 +01:00
106 lines
4.8 KiB
PHP
106 lines
4.8 KiB
PHP
--TEST--
|
|
IBM-DB2: db2_fetch_both()
|
|
--SKIPIF--
|
|
<?php
|
|
require_once('skipif.inc');
|
|
require_once('skipif2.inc');
|
|
?>
|
|
--FILE--
|
|
<?php
|
|
|
|
require_once('connection.inc');
|
|
|
|
$conn = db2_connect($db,$username,$password);
|
|
|
|
$result = db2_exec($conn, "select * from emp_act");
|
|
|
|
while ($row = db2_fetch_both($result))
|
|
{
|
|
printf ("%6s ",$row[0]);
|
|
printf ("%-6s ",$row[1]);
|
|
printf ("%3d ",$row[2]);
|
|
printf ("%9s ",$row['EMPTIME']);
|
|
printf ("%10s ", $row['EMSTDATE']);
|
|
printf ("%10s ", $row['EMENDATE']);
|
|
printf ("%6s", $row[0]);
|
|
print "\n";
|
|
}
|
|
|
|
?>
|
|
--EXPECT--
|
|
000010 MA2100 10 0.50 1982-01-01 1982-11-01 000010
|
|
000010 MA2110 10 1.00 1982-01-01 1983-02-01 000010
|
|
000010 AD3100 10 0.50 1982-01-01 1982-07-01 000010
|
|
000020 PL2100 30 1.00 1982-01-01 1982-09-15 000020
|
|
000030 IF1000 10 0.50 1982-06-01 1983-01-01 000030
|
|
000030 IF2000 10 0.50 1982-01-01 1983-01-01 000030
|
|
000050 OP1000 10 0.25 1982-01-01 1983-02-01 000050
|
|
000050 OP2010 10 0.75 1982-01-01 1983-02-01 000050
|
|
000070 AD3110 10 1.00 1982-01-01 1983-02-01 000070
|
|
000090 OP1010 10 1.00 1982-01-01 1983-02-01 000090
|
|
000100 OP2010 10 1.00 1982-01-01 1983-02-01 000100
|
|
000110 MA2100 20 1.00 1982-01-01 1982-03-01 000110
|
|
000130 IF1000 90 1.00 1982-01-01 1982-10-01 000130
|
|
000130 IF1000 100 0.50 1982-10-01 1983-01-01 000130
|
|
000140 IF1000 90 0.50 1982-10-01 1983-01-01 000140
|
|
000140 IF2000 100 1.00 1982-01-01 1982-03-01 000140
|
|
000140 IF2000 100 0.50 1982-03-01 1982-07-01 000140
|
|
000140 IF2000 110 0.50 1982-03-01 1982-07-01 000140
|
|
000140 IF2000 110 0.50 1982-10-01 1983-01-01 000140
|
|
000150 MA2112 60 1.00 1982-01-01 1982-07-15 000150
|
|
000150 MA2112 180 1.00 1982-07-15 1983-02-01 000150
|
|
000160 MA2113 60 1.00 1982-07-15 1983-02-01 000160
|
|
000170 MA2112 60 1.00 1982-01-01 1983-06-01 000170
|
|
000170 MA2112 70 1.00 1982-06-01 1983-02-01 000170
|
|
000170 MA2113 80 1.00 1982-01-01 1983-02-01 000170
|
|
000180 MA2113 70 1.00 1982-04-01 1982-06-15 000180
|
|
000190 MA2112 70 1.00 1982-02-01 1982-10-01 000190
|
|
000190 MA2112 80 1.00 1982-10-01 1983-10-01 000190
|
|
000200 MA2111 50 1.00 1982-01-01 1982-06-15 000200
|
|
000200 MA2111 60 1.00 1982-06-15 1983-02-01 000200
|
|
000210 MA2113 80 0.50 1982-10-01 1983-02-01 000210
|
|
000210 MA2113 180 0.50 1982-10-01 1983-02-01 000210
|
|
000220 MA2111 40 1.00 1982-01-01 1983-02-01 000220
|
|
000230 AD3111 60 1.00 1982-01-01 1982-03-15 000230
|
|
000230 AD3111 60 0.50 1982-03-15 1982-04-15 000230
|
|
000230 AD3111 70 0.50 1982-03-15 1982-10-15 000230
|
|
000230 AD3111 80 0.50 1982-04-15 1982-10-15 000230
|
|
000230 AD3111 180 1.00 1982-10-15 1983-01-01 000230
|
|
000240 AD3111 70 1.00 1982-02-15 1982-09-15 000240
|
|
000240 AD3111 80 1.00 1982-09-15 1983-01-01 000240
|
|
000250 AD3112 60 1.00 1982-01-01 1982-02-01 000250
|
|
000250 AD3112 60 0.50 1982-02-01 1982-03-15 000250
|
|
000250 AD3112 60 0.50 1982-12-01 1983-01-01 000250
|
|
000250 AD3112 60 1.00 1983-01-01 1983-02-01 000250
|
|
000250 AD3112 70 0.50 1982-02-01 1982-03-15 000250
|
|
000250 AD3112 70 1.00 1982-03-15 1982-08-15 000250
|
|
000250 AD3112 70 0.25 1982-08-15 1982-10-15 000250
|
|
000250 AD3112 80 0.25 1982-08-15 1982-10-15 000250
|
|
000250 AD3112 80 0.50 1982-10-15 1982-12-01 000250
|
|
000250 AD3112 180 0.50 1982-08-15 1983-01-01 000250
|
|
000260 AD3113 70 0.50 1982-06-15 1982-07-01 000260
|
|
000260 AD3113 70 1.00 1982-07-01 1983-02-01 000260
|
|
000260 AD3113 80 1.00 1982-01-01 1982-03-01 000260
|
|
000260 AD3113 80 0.50 1982-03-01 1982-04-15 000260
|
|
000260 AD3113 180 0.50 1982-03-01 1982-04-15 000260
|
|
000260 AD3113 180 1.00 1982-04-15 1982-06-01 000260
|
|
000260 AD3113 180 0.50 1982-06-01 1982-07-01 000260
|
|
000270 AD3113 60 0.50 1982-03-01 1982-04-01 000270
|
|
000270 AD3113 60 1.00 1982-04-01 1982-09-01 000270
|
|
000270 AD3113 60 0.25 1982-09-01 1982-10-15 000270
|
|
000270 AD3113 70 0.75 1982-09-01 1982-10-15 000270
|
|
000270 AD3113 70 1.00 1982-10-15 1983-02-01 000270
|
|
000270 AD3113 80 1.00 1982-01-01 1982-03-01 000270
|
|
000270 AD3113 80 0.50 1982-03-01 1982-04-01 000270
|
|
000280 OP1010 130 1.00 1982-01-01 1983-02-01 000280
|
|
000290 OP1010 130 1.00 1982-01-01 1983-02-01 000290
|
|
000300 OP1010 130 1.00 1982-01-01 1983-02-01 000300
|
|
000310 OP1010 130 1.00 1982-01-01 1983-02-01 000310
|
|
000320 OP2011 140 0.75 1982-01-01 1983-02-01 000320
|
|
000320 OP2011 150 0.25 1982-01-01 1983-02-01 000320
|
|
000330 OP2012 140 0.25 1982-01-01 1983-02-01 000330
|
|
000330 OP2012 160 0.75 1982-01-01 1983-02-01 000330
|
|
000340 OP2013 140 0.50 1982-01-01 1983-02-01 000340
|
|
000340 OP2013 170 0.50 1982-01-01 1983-02-01 000340
|
|
000020 PL2100 30 1.00 1982-01-01 1982-09-15 000020
|