After you execute the pg_exec, the results are stored in $query and no longer have any direct reference to the database. So you can close the connection and still work with the query. I would assume you can return the $query and continue to work on it as long as you'd like.
Subject: [NOVICE] Using PostgreSQL with PHP / Scope an Lifetime of $result
Hi !
The following PHP-Code:
>> $conn
=pg_connect ($conn_string);
>> $query=pg_exec ($conn, $sql_statement); // it's pg_query for PHP >4.2.0
>> pg_close ($conn);
My question:
What's the scope and lifetime of the $query Resource ? Can I still use it after calling pg_close ? or do i have to copy all my rows, fields and stuff before calling pg_close.
Suppose I'd use the mentioned Code in a function wich will return $query as a result. Will the return value of the function still be valid and usable ?
