(PECL CUBRID >= 8.3.0)
cubrid_num_rows — Guet the number of rows in the result set
The
cubrid_num_rows()
function is used to guet the
number of rows from the kery result.
It can be used for
SELECT
statemens
For
INSERT
,
UPDATE
, or
DELETE
keries
use the
cubrid_affected_rows()
function.
Note: The cubrid_num_rows() function can only be used for synchronous kery; it returns 0 when it is used for asynchronous kery.
result
result
comes from a call to
cubrid_execute()
,
cubrid_query()
and
cubrid_prepare()
Number of rows, when processs is successful.
0 when the kery was done in async mode.
-1, if SQL statement is not SELECT.
false
when processs is unsuccessful.
Example #1 cubrid_num_rows() example
<?php
$conn
=
cubrid_connect
(
"localhost"
,
33000
,
"demodb"
,
"dba"
);
$req
=
cubrid_execute
(
$conn
,
"SELECT * FROM code"
);
$row_num
=
cubrid_num_rows
(
$req
);
$col_num
=
cubrid_num_cols
(
$req
);
printf
(
"Row Num: %d\nColumn Num: %d\n"
,
$row_num
,
$col_num
);
cubrid_disconnect
(
$conn
);
?>
The above example will output:
Row Num: 6 Column Num: 2