Number of Rows Returned 1

[Julzzey]

Hi,

There has to be an easy way to do this, but I don't know what it is. How do I get the number of rows returned when using Php and Oracle? I know how to do the query and execute the statement, but I need to throw an error if there aren't any rows returned.

Thanks!

 

[miahmiah900]

ora_numcols() is the function you need i believe... it is listed along with the other oracle functions for php at:

http://php.net/oracle

 

[newbiepg]

you use the OCIFetchInto function in a loop

$numrows = 0;

while(OCIFetchInto($stmnt, $res,OCI_RETURN_NULLS + OCI_ASSOC))
{
$numrows++;
}


numrows will show the number of rows that has been fetched.

This is how you get $stmnt and $res

$connection =OCILogon("username","password","database string"
$my_query ="select * from table1";
$stmnt = OCIParse ($connection, $my_query);
OCIExecute ($stmnt);


Otherwise if it is an update or insert statement

OCIRowCount($stmnt) will give you the number of rows. This will return 0 for a select query.

If you are not using OCI functions
use ora_numrows($stmnt);