pg_free_result

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

    pg_free_result — Free result memory

    Description

    function 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.

    Note:

    This function used to be called pg_freeresult().

    Parameters

    result
    An PgSql\Result instance, returned by pg_query(), pg_query_params() or pg_execute()(among others).

    Return Values

    Returns true on success or false on failure.

    Changelog

    Version Description
    8.1.0 The result parameter expects an PgSql\Result instance now; previously, a resource was expected.

    Examples

    Example #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);
?>

    The above example will output:

    First field in the second row is: 2

    See Also

    • pg_query() - Executa uma consulta
    • pg_query_params() - Envia um comando ao servidor e aguarda o resultado, com a capacidade de passar parâmetros separadamente do texto do comando SQL
    • pg_execute() - Envia uma solicitação para executar uma instrução preparada com determinados parâmetros e aguarda o resultado
    • pg_result_memory_size() - Retorna a quantidade de memória alocada para um resultado de consulta

    Melhore Esta Página

    Aprenda Como Melhorar Esta Página • Envie uma Solicitação de Modificação • Reporte um Problema
    ＋adicionar nota

    Notas de Usuários 1 note

    up
    3
    Stefan W
    12 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
    ＋adicionar nota
    To Top