pg_field_is_null(3) php man page | unix.com

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)