Return to odbc_exec_002.phpt CVS log

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

Annotation of embedaddon/php/ext/odbc/tests/odbc_exec_002.phpt, revision 1.1

1.1     ! misho       1: --TEST--
        !             2: odbc_exec(): Getting data from query
        !             3: --SKIPIF--
        !             4: <?php include 'skipif.inc'; ?>
        !             5: --FILE--
        !             6: <?php
        !             7: 
        !             8: include 'config.inc';
        !             9: 
        !            10: $conn = odbc_connect($dsn, $user, $pass);
        !            11: 
        !            12: odbc_exec($conn, 'CREATE DATABASE odbcTEST');
        !            13: 
        !            14: odbc_exec($conn, 'CREATE TABLE FOO (TEST INT)');
        !            15: 
        !            16: odbc_exec($conn, 'INSERT INTO FOO VALUES (1)');
        !            17: odbc_exec($conn, 'INSERT INTO FOO VALUES (2)');
        !            18: 
        !            19: $res = odbc_exec($conn, 'SELECT * FROM FOO');
        !            20: 
        !            21: var_dump(odbc_fetch_row($res));
        !            22: var_dump(odbc_result($res, 'test'));
        !            23: var_dump(odbc_fetch_array($res));
        !            24: 
        !            25: odbc_exec($conn, 'DROP TABLE FOO');
        !            26: 
        !            27: odbc_exec($conn, 'DROP DATABASE odbcTEST');
        !            28: 
        !            29: ?>
        !            30: --EXPECTF--
        !            31: bool(true)
        !            32: string(1) "1"
        !            33: array(1) {
        !            34:   ["TEST"]=>
        !            35:   string(1) "2"
        !            36: }