pg_free_result(3) [php man page]

PG_FREE_RESULT(3)														 PG_FREE_RESULT(3)

pg_free_result - Free result memory

SYNOPSIS

       bool pg_free_result (resource  $result)

DESCRIPTION

       pg_free_result(3) 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 auto-
       matically freed when the script ends.

       Note

	       This function used to be called pg_freeresult(3).

PARAMETERS

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

RETURN VALUES

	Returns TRUE on success or FALSE on failure.

EXAMPLES

       Example #1

	      pg_free_result(3) example

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

	      $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, "
";

	      pg_free_result($res);
	      ?>

	      The above example will output:

	      First field in the second row is: 2

SEE ALSO

       pg_query(3), pg_query_params(3), pg_execute(3).

PHP Documentation Group 													 PG_FREE_RESULT(3)

PG_FETCH_RESULT(3)														PG_FETCH_RESULT(3)

pg_fetch_result - Returns values from a result resource

SYNOPSIS

       string pg_fetch_result (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       string pg_fetch_result (resource  $result, mixed  $field)

       pg_fetch_result(3) returns the value of a particular row and field (column) in a PostgreSQL result resource.

       Note

	       This function used to be called pg_result(3).

PARAMETERS

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

	      o $row
		- Row number in result to fetch. Rows are numbered from 0 upwards. If omitted, next row is fetched.

	      o $field
		-  A  string representing the name of the field (column) to fetch, otherwise an int representing the field number to fetch. Fields
		are numbered from 0 upwards.

RETURN VALUES

	Boolean is returned as "t" or "f". All other types, including arrays are returned as strings formatted in the same default PostgreSQL man-
       ner that you would see in the psql program. Database NULL values are returned as NULL.

       FALSE is returned if $row exceeds the number of rows in the set, or on any other error.

EXAMPLES

       Example #1

	      pg_fetch_result(3) example

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

	      $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, "
";
	      ?>

	      The above example will output:

	      First field in the second row is: 2

SEE ALSO

       pg_query(3), pg_fetch_array(3).

PHP Documentation Group 													PG_FETCH_RESULT(3)