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_result(3) - php
pg_field_num(3) - php
pg_field_size(3) - php
pg_free_result(3) - php
pg_result_error_field(3) - php
Similar Topics in the Unix Linux Community
unix
getting value from field dynamically
Sending one email for every row as per sql result
Averaging each row with null values
Extract row grater than 3 from previous value of a field