pg_free_result

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

    pg_free_result — Free result memory

    Опис

    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.

    Зауваження:

    This function used to be called pg_freeresult().

    Параметри

    result

    Примірник PgSql\Result, якого повертає одна з функцій pg_query(), pg_query_params() або pg_execute() (серед інших).

    Значення, що повертаються

    Повертає true у разі успіху або false в разі помилки.

    Журнал змін

    Версія Опис
    8.1.0 Тепер параметр result має бути примірником PgSql\Result. Раніше очікувався resource.

    Приклади

    Приклад #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);
    ?>

    Поданий вище приклад виведе:

    First field in the second row is: 2

    Прогляньте також

    • 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

    up
    3
    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
    To Top