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

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: }