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 NULLSYNOPSISbool oci_field_is_null (resource $statement, mixed $field)DESCRIPTIONChecks if the given $field from the current row of $statement is NULL.PARAMETERSo $statement - A valid OCI statement identifier. o $field - Can be the field's index (1-based) or name.RETURN VALUESReturns TRUE if $field is NULL, FALSE otherwise.EXAMPLESExample #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); ?>NOTESNote 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_fetch_object(3) - php |
oci_fetch_row(3) - php |
oci_field_scale(3) - php |
oci_num_rows(3) - php |
oci_result(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 |