php man page for oci_num_rows

Query: oci_num_rows

OS: php

Section: 3

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

OCI_NUM_ROWS(3) 														   OCI_NUM_ROWS(3)

oci_num_rows - Returns number of rows affected during statement execution

SYNOPSIS
int oci_num_rows (resource $statement)
DESCRIPTION
Gets the number of rows affected during statement execution.
PARAMETERS
o $statement - A valid OCI statement identifier.
RETURN VALUES
Returns the number of rows affected as an integer, or FALSE on errors.
EXAMPLES
Example #1 oci_num_rows(3) example <?php $conn = oci_connect("hr", "hrpwd", "localhost/XE"); if (!$conn) { $m = oci_error(); trigger_error(htmlentities($m['message']), E_USER_ERROR); } $stid = oci_parse($conn, "create table emp2 as select * from employees"); oci_execute($stid); echo oci_num_rows($stid) . " rows inserted.<br /> "; oci_free_statement($stid); $stid = oci_parse($conn, "delete from emp2"); oci_execute($stid, OCI_DEFAULT); echo oci_num_rows($stid) . " rows deleted.<br /> "; oci_commit($conn); oci_free_statement($stid); $stid = oci_parse($conn, "drop table emp2"); oci_execute($stid); oci_free_statement($stid); oci_close($conn); ?>
NOTES
Note This function does not return number of rows selected! For SELECT statements this function will return the number of rows, that were fetched to the buffer with oci_fetch*(3) functions. Note In PHP versions before 5.0.0 you must use ocirowcount(3) instead. This name still can be used, it was left as alias of oci_num_rows(3) for downwards compatability. This, however, is deprecated and not recommended. PHP Documentation Group OCI_NUM_ROWS(3)
Related Man Pages
oci_fetch(3) - php
oci_fetch_row(3) - php
oci_field_precision(3) - php
oci_field_size(3) - php
oci_parse(3) - php
Similar Topics in the Unix Linux Community
return number of rows selected
syntax error on if statement
select data from oracle table and save the output as csv file
help with a bash script to create a html table
Help with a simple function