Return to bind_query.phpt CVS log

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

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

1.1     ! misho       1: --TEST--
        !             2: Bind with various WHERE conditions
        !             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 bind_query_tab",
        !            14:        "create table bind_query_tab (empno number(4), ename varchar2(10), sal number(7,2))",
        !            15:        "insert into bind_query_tab values (7934, 'MILLER', 1300)",
        !            16:        "insert into bind_query_tab values (7902, 'FORD', 3000)"
        !            17: );
        !            18: 
        !            19: oci8_test_sql_execute($c, $stmtarray);
        !            20: 
        !            21: // Run Test
        !            22: 
        !            23: echo "Test 1\n";
        !            24: 
        !            25: $e = 7934;
        !            26: 
        !            27: $s = oci_parse($c, "select ename from bind_query_tab where empno = :eno");
        !            28: oci_bind_by_name( $s, ":eno", $e, -1, SQLT_INT);
        !            29: oci_execute($s);
        !            30: var_dump(oci_fetch_row($s));
        !            31: 
        !            32: echo "Test 2\n";
        !            33: 
        !            34: $v = 1000;
        !            35: $s = oci_parse($c, 'select ename from bind_query_tab where sal > :v order by ename');
        !            36: oci_bind_by_name( $s, ":v", $v);
        !            37: oci_define_by_name($s, "ENAME", $ename, 20);
        !            38: oci_execute($s);
        !            39: while (oci_fetch($s)) {
        !            40:     var_dump($ename);
        !            41: }
        !            42: 
        !            43: 
        !            44: echo "Test 3\n";
        !            45: 
        !            46: $s = oci_parse($c, 'select ename from bind_query_tab where sal > :v order by ename');
        !            47: oci_bind_by_name( $s, ":v", $v);
        !            48: $v = 2000;
        !            49: oci_define_by_name($s, "ENAME", $ename, 20);
        !            50: oci_execute($s);
        !            51: while (oci_fetch($s)) {
        !            52:     var_dump($ename);
        !            53: }
        !            54: 
        !            55: 
        !            56: // Clean up
        !            57: 
        !            58: $stmtarray = array(
        !            59:        "drop table bind_query_tab"
        !            60: );
        !            61: 
        !            62: oci8_test_sql_execute($c, $stmtarray);
        !            63: 
        !            64: ?>
        !            65: ===DONE===
        !            66: <?php exit(0); ?>
        !            67: --EXPECTF--
        !            68: Test 1
        !            69: array(1) {
        !            70:   [0]=>
        !            71:   string(6) "MILLER"
        !            72: }
        !            73: Test 2
        !            74: string(4) "FORD"
        !            75: string(6) "MILLER"
        !            76: Test 3
        !            77: string(4) "FORD"
        !            78: ===DONE===