cubrid_num_rows
(PECL CUBRID >= 8.3.0)
cubrid_num_rows — Is used to get the number of rows
Description
int cubrid_num_rows
( resource $req_identifier
)
The cubrid_num_rows() function is used to get the number of rows from the query result. You can use it only when the query executed is a select sentence. When you want to know such value for INSERT, UPDATE, or DELETE query, you have to use the cubrid_affected_rows() function.
Note: The cubrid_num_rows() function can only be used for synchronous query; it returns 0 when it is used for asynchronous query.
Parameters
- req_identifier
-
Request identifier.
Return Values
Number of rows, when process is successful.
0 when the query was done in async mode.
-1, if SQL sentence is not SELECT.
Examples
Example #1 cubrid_num_rows() example
<?php
$req = cubrid_execute ($con, "select * from member");
if ($req) {
$rows_count = cubrid_num_rows ($req);
$cols_count = cubrid_num_cols ($req);
echo "result set rows count : $rows\n";
echo "result set columns count : $cols\n";
cubrid_close_request ($req);
}
?>
See Also
- cubrid_execute() - Is used to execute the given SQL sentence.
- cubrid_num_cols() - Is used to get the number of columns
- cubrid_affected_rows() - Get number of affected rows in previous Cubrid operation