xref: /php-src/ext/pgsql/tests/pg_close_stmt.phpt (revision 1da352c3)
1--TEST--
2PostgreSQL pg_close_stmt
3--EXTENSIONS--
4pgsql
5--SKIPIF--
6<?php include("inc/skipif.inc");
7if (!function_exists("pg_close_stmt")) die("skip pg_close_stmt unsupported");
8?>
9--FILE--
10<?php
11include('inc/config.inc');
12
13
14$query = 'SELECT $1::text IS NULL;';
15$params_null = [null];
16
17$db = pg_connect($conn_str);
18$res = pg_prepare($db, 'test', $query);
19
20$res = pg_execute($db, 'test', $params_null);
21$res = pg_close_stmt($db, 'test');
22var_dump($res !== false);
23var_dump(pg_result_status($res) === PGSQL_COMMAND_OK);
24pg_prepare($db, 'test', $query);
25$res = pg_execute($db, 'test', $params_null);
26pg_free_result($res);
27
28pg_close($db);
29
30?>
31--EXPECT--
32bool(true)
33bool(true)
34