1--TEST-- 2odbc_free_result(): Basic test 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 NOT NULL)'); 15odbc_exec($conn, 'ALTER TABLE FOO ADD PRIMARY KEY (TEST)'); 16 17odbc_exec($conn, 'INSERT INTO FOO VALUES (1)'); 18odbc_exec($conn, 'INSERT INTO FOO VALUES (2)'); 19 20$res = odbc_exec($conn, 'SELECT * FROM FOO'); 21 22var_dump(odbc_fetch_row($res)); 23var_dump(odbc_result($res, 'test')); 24var_dump(odbc_free_result($res)); 25try { 26 var_dump(odbc_free_result($conn)); 27} catch (TypeError $e) { 28 echo $e->getMessage(), "\n"; 29} 30try { 31 var_dump(odbc_fetch_row($res)); 32} catch (TypeError $e) { 33 echo $e->getMessage(), "\n"; 34} 35try { 36 var_dump(odbc_result($res, 'test')); 37} catch (TypeError $e) { 38 echo $e->getMessage(), "\n"; 39} 40?> 41--CLEAN-- 42<?php 43require 'config.inc'; 44$conn = odbc_connect($dsn, $user, $pass); 45odbc_exec($conn, 'DROP TABLE FOO'); 46odbc_exec($conn, 'DROP DATABASE odbcTEST'); 47?> 48--EXPECT-- 49bool(true) 50string(1) "1" 51bool(true) 52odbc_free_result(): supplied resource is not a valid ODBC result resource 53odbc_fetch_row(): supplied resource is not a valid ODBC result resource 54odbc_result(): supplied resource is not a valid ODBC result resource 55