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