what if there is no record

jiehuang001

I have been using the following code to get result from an Oracle database:
$conn= //details omitted
$stmt = ociparse($conn,$query);
while (OCIFetch($stmt)) {
//do something
}

How can I print "sorry, no record" if there is no record?

Thanks.

Jie Huang

jweissig

<?

$conn= //details omitted 
$stmt = ociparse($conn,$query); 

// see php.net/ocirowcount

if (ocirowcount($stmt) < 1) {

echo "sorry, no records found";

} else {

while (ocifetch($stmt))
	{

	//do something

	}
}

?>

jiehuang001

this is the error message
Call to undefined function: ora_numrows() in ...

jweissig

you need to use ocirowcount() not ora_numrows(). my mistake see the code that i pasted above i have changed it.

thanks and sorry about that,
- justin

jiehuang001

ocirowcount($stmt) always is 0 if you call it before the while statement. So, there is always no result.

laserlight

From PHP manual:

OCIRowCount() returns the number of rows affected for eg update-statements. This function will not tell you the number of rows that a select will return!

OCIFetchStatement() fetches all the rows from a result into a user-defined array. OCIFetchStatement() returns the number of rows fetched.