oci_num_rows(ocirowcount) is always showing 0 records in PHP with Oracle

mahmoodtyagi

oci_num_rows(ocirowcount) is always showing 0 records(while having more rows) in PHP with Oracle to fetch total no of records.
Code wrote as follows:

$qry2="select * from USER";
$smt2=ociparse($conn,$qry2);
$r=ociexecute($smt2);
echo 'Total Rows='.ocirowcount($smt2);

Output show always: Total Rows=0

ronverdonk

Quote:

Originally Posted by PHP manual

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*() functions.

Should be the reason.

Ronald

oci_num_rows(ocirowcount) is always showing 0 records in PHP with Oracle

re: oci_num_rows(ocirowcount) is always showing 0 records in PHP with Oracle

/bytes/development

/bytes/it

/bytes/about