pg_free_result

(PHP 4 >= 4.2.0, PHP 5, PHP 7, PHP 8)

pg_free_result — Free result memory

Açıklama

pg_free_result(PgSql\Result $result): bool

pg_free_result() frees the memory and data associated with the specified PgSql\Result instance.

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().

Bağımsız Değişkenler

result: pg_query(), pg_query_params() veya pg_execute() işlevinden dönen PgSql\Result nesnesi.

Dönen Değerler

Başarı durumunda true, başarısızlık durumunda false döner.

Sürüm Bilgisi

Sürüm:	Açıklama
8.1.0	`sonuç` bağımsız değişkeni artık PgSql\Result nesnesi kabul ediyor, evvelce bir özkaynak kabul ederdi.

Örnekler

Örnek 1 pg_free_result() example

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

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

$val = pg_fetch_result($res, 1, 0);

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
pg_result_memory_size() - Returns the amount of memory allocated for a query result

Improve This Page

Learn How To Improve This Page • Submit a Pull Request • Report a Bug

＋add a note

User Contributed Notes 1 note

down

Stefan W ¶

11 years 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

＋add a note