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

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===