Return to null_byte_3.phpt CVS log

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

Annotation of embedaddon/php/ext/oci8/tests/null_byte_3.phpt, revision 1.1.1.1

1.1       misho       1: --TEST--
                      2: Null bytes in SQL statements
                      3: --SKIPIF--
                      4: <?php if (!extension_loaded('oci8')) die ("skip no oci8 extension"); ?>
                      5: --INI--
                      6: display_errors = On
                      7: error_reporting = E_WARNING
                      8: --FILE--
                      9: <?php
                     10: 
                     11: require(dirname(__FILE__).'/connect.inc');
                     12: 
                     13: // Run Test
                     14: 
                     15: echo "Test 1: Invalid use of a null byte\n";
                     16: 
                     17: $s = oci_parse($c, "select * from du\0al");
                     18: oci_execute($s);
                     19: 
                     20: echo "Test 2: Using a null byte in a bind variable value causing WHERE clause to fail\n";
                     21: 
                     22: $s = oci_parse($c, "select * from dual where :bv = 'abc'");
                     23: $bv = 'abc\0abc';
                     24: oci_bind_by_name($s, ":bv", $bv);
                     25: oci_execute($s);
                     26: oci_fetch_all($s, $res);
                     27: var_dump($res);
                     28: 
                     29: ?>
                     30: ===DONE===
                     31: <?php exit(0); ?>
                     32: --EXPECTF--
                     33: Test 1: Invalid use of a null byte
                     34: 
                     35: Warning: oci_execute(): ORA-00942: %s in %snull_byte_3.php on line %d
                     36: Test 2: Using a null byte in a bind variable value causing WHERE clause to fail
                     37: array(1) {
                     38:   ["DUMMY"]=>
                     39:   array(0) {
                     40:   }
                     41: }
                     42: ===DONE===