php man page for pg_field_is_null

Query: pg_field_is_null

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

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)
Related Man Pages
pg_fetch_object(3) - php
pg_fetch_row(3) - php
pg_field_type(3) - php
pg_free_result(3) - php
pg_last_oid(3) - php
Similar Topics in the Unix Linux Community
help with this one please
getting value from field dynamically
To find the Row number
Averaging each row with null values
Replace values