pg_field_is_null(3) [php man page]

PG_FIELD_IS_NULL(3)													       PG_FIELD_IS_NULL(3)

pg_field_is_null - Test if a field is SQL NULL

SYNOPSIS

       int pg_field_is_null (resource  $result, int  $row, mixed  $field)

DESCRIPTION

       int pg_field_is_null (resource  $result, mixed  $field)

       pg_field_is_null(3) tests if a field in a PostgreSQL result resource is SQL NULL or not.

       Note

	       This function used to be called pg_fieldisnull(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, current row is fetched.

	      o $field
		- Field number (starting from 0) as an integer or the field name as a string.

RETURN VALUES

	Returns 1 if the field in the given row is SQL NULL, 0 if not.	FALSE is returned if the row is out of range, or upon any other error.

EXAMPLES

       Example #1

	      pg_field_is_null(3) example

	      <?php
		$dbconn = pg_connect("dbname=publisher") or die ("Could not connect");
		$res = pg_query($dbconn, "select * from authors where author = 'Orwell'");
		if ($res) {
		    if (pg_field_is_null($res, 0, "year") == 1) {
			echo "The value of the field year is null.
";
		    }
		    if (pg_field_is_null($res, 0, "year") == 0) {
			echo "The value of the field year is not null.
";
		  }
	       }
	      ?>

PHP Documentation Group 												       PG_FIELD_IS_NULL(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)