PHP Australia Conference 2015

pg_free_result

(PHP 4 >= 4.2.0, PHP 5)

pg_free_resultFree result memory

Açıklama

bool pg_free_result ( resource $result )

pg_free_result() frees the memory and data associated with the specified PostgreSQL query result resource.

This function need only be called if memory consumption during script execution is a problem. Otherwise, all result memory will be automatically freed when the script ends.

Bilginize:

This function used to be called pg_freeresult().

Değiştirgeler

result

PostgreSQL query result resource, returned by pg_query(), pg_query_params() or pg_execute() (among others).

Dönen Değerler

Başarı durumunda TRUE, başarısızlık durumunda FALSE döner.

Örnekler

Örnek 1 pg_free_result() example

<?php
$db 
pg_connect("dbname=users user=me") || die();

$res pg_query($db"SELECT 1 UNION ALL SELECT 2");

$val pg_fetch_result($res10);

echo 
"First field in the second row is: "$val"\n";

pg_free_result($res);
?>

Yukarıdaki örneğin çıktısı:

First field in the second row is: 2

Ayrıca Bakınız

  • pg_query() - Execute a query
  • pg_query_params() - Submits a command to the server and waits for the result, with the ability to pass parameters separately from the SQL command text.
  • pg_execute() - Sends a request to execute a prepared statement with given parameters, and waits for the result.

add a note add a note

User Contributed Notes 1 note

up
1
Stefan W
1 year ago
You do NOT need to call pg_free_result() on every result resource you create.
When result resources go out of scope, they are garbage collected just like everything else.
Unless you're hoarding your results somewhere, you can basically ignore this function.

Here's a little test you can run to confirm this: http://pastebin.com/ghw1PHuE
To Top