Return to fetch_object_1.phpt CVS log

Up to [ELWIX - Embedded LightWeight unIX -] / embedaddon / php / ext / oci8 / tests

Annotation of embedaddon/php/ext/oci8/tests/fetch_object_1.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: oci_fetch_object()
        !             3: --SKIPIF--
        !             4: <?php
        !             5: $target_dbs = array('oracledb' => true, 'timesten' => false);  // test runs on these DBs
        !             6: require(dirname(__FILE__).'/skipif.inc');
        !             7: ?> 
        !             8: --FILE--
        !             9: <?php
        !            10: 
        !            11: require(dirname(__FILE__).'/connect.inc');
        !            12: 
        !            13: // Initialization
        !            14: 
        !            15: $stmtarray = array(
        !            16:     "drop table fetch_object_tab",
        !            17:     "create table fetch_object_tab (\"caseSensitive\" number, secondcol varchar2(20), anothercol char(15))",
        !            18:     "insert into fetch_object_tab values (123, '1st row col2 string', '1 more text')",
        !            19:     "insert into fetch_object_tab values (456, '2nd row col2 string', '2 more text')",
        !            20:     "insert into fetch_object_tab values (789, '3rd row col2 string', '3 more text')",
        !            21: );
        !            22: 
        !            23: oci8_test_sql_execute($c, $stmtarray);
        !            24: 
        !            25: // Run Test
        !            26: 
        !            27: echo "Test 1\n";
        !            28: 
        !            29: if (!($s = oci_parse($c, 'select * from fetch_object_tab'))) {
        !            30:     die("oci_parse(select) failed!\n");
        !            31: }
        !            32: 
        !            33: if (!oci_execute($s)) {
        !            34:     die("oci_execute(select) failed!\n");
        !            35: }
        !            36: 
        !            37: while ($row = oci_fetch_object($s)) {
        !            38:     var_dump($row);
        !            39: }
        !            40: 
        !            41: echo "Test 2\n";
        !            42: 
        !            43: if (!($s = oci_parse($c, 'select * from fetch_object_tab'))) {
        !            44:     die("oci_parse(select) failed!\n");
        !            45: }
        !            46: 
        !            47: if (!oci_execute($s)) {
        !            48:     die("oci_execute(select) failed!\n");
        !            49: }
        !            50: 
        !            51: while ($row = oci_fetch_object($s)) {
        !            52:     echo $row->caseSensitive . "\n";
        !            53:     echo $row->SECONDCOL . "\n";
        !            54:     echo $row->ANOTHERCOL . "\n";
        !            55: }
        !            56: 
        !            57: echo "Test 3\n";
        !            58: 
        !            59: if (!($s = oci_parse($c, 'select * from fetch_object_tab where rownum < 2 order by "caseSensitive"'))) {
        !            60:     die("oci_parse(select) failed!\n");
        !            61: }
        !            62: 
        !            63: if (!oci_execute($s)) {
        !            64:     die("oci_execute(select) failed!\n");
        !            65: }
        !            66: 
        !            67: $row = oci_fetch_object($s);
        !            68: echo $row->caseSensitive . "\n";
        !            69: echo $row->CASESENSITIVE . "\n";
        !            70: 
        !            71: // Clean up
        !            72: 
        !            73: $stmtarray = array(
        !            74:     "drop table fetch_object_tab"
        !            75: );
        !            76: 
        !            77: oci8_test_sql_execute($c, $stmtarray);
        !            78: 
        !            79: ?>
        !            80: ===DONE===
        !            81: <?php exit(0); ?>
        !            82: --EXPECTF--
        !            83: Test 1
        !            84: object(stdClass)#%d (3) {
        !            85:   ["caseSensitive"]=>
        !            86:   string(3) "123"
        !            87:   ["SECONDCOL"]=>
        !            88:   string(19) "1st row col2 string"
        !            89:   ["ANOTHERCOL"]=>
        !            90:   string(15) "1 more text    "
        !            91: }
        !            92: object(stdClass)#%d (3) {
        !            93:   ["caseSensitive"]=>
        !            94:   string(3) "456"
        !            95:   ["SECONDCOL"]=>
        !            96:   string(19) "2nd row col2 string"
        !            97:   ["ANOTHERCOL"]=>
        !            98:   string(15) "2 more text    "
        !            99: }
        !           100: object(stdClass)#%d (3) {
        !           101:   ["caseSensitive"]=>
        !           102:   string(3) "789"
        !           103:   ["SECONDCOL"]=>
        !           104:   string(19) "3rd row col2 string"
        !           105:   ["ANOTHERCOL"]=>
        !           106:   string(15) "3 more text    "
        !           107: }
        !           108: Test 2
        !           109: 123
        !           110: 1st row col2 string
        !           111: 1 more text    
        !           112: 456
        !           113: 2nd row col2 string
        !           114: 2 more text    
        !           115: 789
        !           116: 3rd row col2 string
        !           117: 3 more text    
        !           118: Test 3
        !           119: 123
        !           120: 
        !           121: Notice: Undefined property: stdClass::$CASESENSITIVE in %sfetch_object_1.php on line %d
        !           122: 
        !           123: ===DONE===