php man page for oci_field_is_null

Query: oci_field_is_null

OS: php

Section: 3

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

OCI_FIELD_IS_NULL(3)													      OCI_FIELD_IS_NULL(3)

oci_field_is_null - Checks if a field in the currently fetched row is NULL

SYNOPSIS
bool oci_field_is_null (resource $statement, mixed $field)
DESCRIPTION
Checks if the given $field from the current row of $statement is NULL.
PARAMETERS
o $statement - A valid OCI statement identifier. o $field - Can be the field's index (1-based) or name.
RETURN VALUES
Returns TRUE if $field is NULL, FALSE otherwise.
EXAMPLES
Example #1 oci_field_name(3) example <?php // Create the table with: // CREATE TABLE mytab (c1 NUMBER); // INSERT INTO mytab VALUES (1); // INSERT INTO mytab VALUES (NULL); $conn = oci_connect("hr", "hrpwd", "localhost/XE"); if (!$conn) { $m = oci_error(); trigger_error(htmlentities($m['message']), E_USER_ERROR); } $stid = oci_parse($conn, "SELECT * FROM mytab"); oci_execute($stid); while (($row = oci_fetch_array($stid, OCI_RETURN_NULLS)) != false) { $ncols = oci_num_fields($stid); for ($col = 1; $col <= $ncols; $col++) { var_dump(oci_field_is_null($stid, $col)); } } // Outputs: // bool(false) // bool(true) oci_free_statement($stid); oci_close($conn); ?>
NOTES
Note In PHP versions before 5.0.0 you must use ocicolumnisnull(3) instead. This name still can be used, it was left as alias of oci_field_is_null(3) for downwards compatability. This, however, is deprecated and not recommended. PHP Documentation Group OCI_FIELD_IS_NULL(3)
Related Man Pages
oci_field_name(3) - php
oci_field_scale(3) - php
oci_field_size(3) - php
oci_num_rows(3) - php
oci_rollback(3) - php
Similar Topics in the Unix Linux Community
printing arrays
Assign variable for INSERT INTO statement
Extract row grater than 3 from previous value of a field