Annotation of embedaddon/php/ext/oci8/tests/fetch_all5.phpt, revision 1.1
1.1 ! misho 1: --TEST--
! 2: Test 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:
! 8: require(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:
! 20: oci8_test_sql_execute($c, $stmtarray);
! 21:
! 22: // Run Test
! 23:
! 24: echo "Test 1\n";
! 25:
! 26: $s = oci_parse($c, "select * from fetch_all5_tab order by 1");
! 27: oci_execute($s);
! 28: $r = oci_fetch_all($s, $res, 0, -1);
! 29: var_dump($r);
! 30: var_dump($res);
! 31:
! 32: echo "Test 1\n";
! 33:
! 34: $s = oci_parse($c, "select * from fetch_all5_tab order by 1");
! 35: oci_execute($s);
! 36: $r = oci_fetch_all($s, $res, 0, 0);
! 37: var_dump($r);
! 38: var_dump($res);
! 39:
! 40: echo "Test 3\n";
! 41:
! 42: $s = oci_parse($c, "select * from fetch_all5_tab order by 1");
! 43: oci_execute($s);
! 44: $r = oci_fetch_all($s, $res, -1, 0);
! 45: var_dump($r);
! 46: var_dump($res);
! 47:
! 48: // Clean up
! 49:
! 50: $stmtarray = array(
! 51: "drop table fetch_all5_tab"
! 52: );
! 53:
! 54: oci8_test_sql_execute($c, $stmtarray);
! 55:
! 56: oci_close($c);
! 57:
! 58: ?>
! 59: ===DONE===
! 60: <?php exit(0); ?>
! 61: --EXPECTF--
! 62: Test 1
! 63: int(3)
! 64: array(2) {
! 65: [%u|b%"MYCOL1"]=>
! 66: array(3) {
! 67: [0]=>
! 68: %unicode|string%(1) "1"
! 69: [1]=>
! 70: %unicode|string%(1) "2"
! 71: [2]=>
! 72: %unicode|string%(1) "3"
! 73: }
! 74: [%u|b%"MYCOL2"]=>
! 75: array(3) {
! 76: [0]=>
! 77: %unicode|string%(3) "abc"
! 78: [1]=>
! 79: %unicode|string%(3) "def"
! 80: [2]=>
! 81: %unicode|string%(3) "ghi"
! 82: }
! 83: }
! 84: Test 1
! 85: int(3)
! 86: array(2) {
! 87: [%u|b%"MYCOL1"]=>
! 88: array(3) {
! 89: [0]=>
! 90: %unicode|string%(1) "1"
! 91: [1]=>
! 92: %unicode|string%(1) "2"
! 93: [2]=>
! 94: %unicode|string%(1) "3"
! 95: }
! 96: [%u|b%"MYCOL2"]=>
! 97: array(3) {
! 98: [0]=>
! 99: %unicode|string%(3) "abc"
! 100: [1]=>
! 101: %unicode|string%(3) "def"
! 102: [2]=>
! 103: %unicode|string%(3) "ghi"
! 104: }
! 105: }
! 106: Test 3
! 107: int(0)
! 108: array(0) {
! 109: }
! 110: ===DONE===
FreeBSD-CVSweb <freebsd-cvsweb@FreeBSD.org>