1--TEST-- 2Test oci_fetch_all with 0 and -1 skip & maxrows 3--SKIPIF-- 4<?php if (!extension_loaded('oci8')) die ("skip no oci8 extension"); ?> 5--FILE-- 6<?php 7 8require(dirname(__FILE__).'/connect.inc'); 9 10// Initialization 11 12$stmtarray = array( 13 "drop table fetch_all5_tab", 14 "create table fetch_all5_tab (mycol1 number, mycol2 varchar2(20))", 15 "insert into fetch_all5_tab values (1, 'abc')", 16 "insert into fetch_all5_tab values (2, 'def')", 17 "insert into fetch_all5_tab values (3, 'ghi')" 18); 19 20oci8_test_sql_execute($c, $stmtarray); 21 22// Run Test 23 24echo "Test 1\n"; 25 26$s = oci_parse($c, "select * from fetch_all5_tab order by 1"); 27oci_execute($s); 28$r = oci_fetch_all($s, $res, 0, -1); 29var_dump($r); 30var_dump($res); 31 32echo "Test 1\n"; 33 34$s = oci_parse($c, "select * from fetch_all5_tab order by 1"); 35oci_execute($s); 36$r = oci_fetch_all($s, $res, 0, 0); 37var_dump($r); 38var_dump($res); 39 40echo "Test 3\n"; 41 42$s = oci_parse($c, "select * from fetch_all5_tab order by 1"); 43oci_execute($s); 44$r = oci_fetch_all($s, $res, -1, 0); 45var_dump($r); 46var_dump($res); 47 48// Clean up 49 50$stmtarray = array( 51 "drop table fetch_all5_tab" 52); 53 54oci8_test_sql_execute($c, $stmtarray); 55 56oci_close($c); 57 58?> 59===DONE=== 60<?php exit(0); ?> 61--EXPECTF-- 62Test 1 63int(3) 64array(2) { 65 ["MYCOL1"]=> 66 array(3) { 67 [0]=> 68 string(1) "1" 69 [1]=> 70 string(1) "2" 71 [2]=> 72 string(1) "3" 73 } 74 ["MYCOL2"]=> 75 array(3) { 76 [0]=> 77 string(3) "abc" 78 [1]=> 79 string(3) "def" 80 [2]=> 81 string(3) "ghi" 82 } 83} 84Test 1 85int(3) 86array(2) { 87 ["MYCOL1"]=> 88 array(3) { 89 [0]=> 90 string(1) "1" 91 [1]=> 92 string(1) "2" 93 [2]=> 94 string(1) "3" 95 } 96 ["MYCOL2"]=> 97 array(3) { 98 [0]=> 99 string(3) "abc" 100 [1]=> 101 string(3) "def" 102 [2]=> 103 string(3) "ghi" 104 } 105} 106Test 3 107int(0) 108array(0) { 109} 110===DONE=== 111
