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