php man page for cubrid_num_rows

Query: cubrid_num_rows

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

CUBRID_NUM_ROWS(3)							 1							CUBRID_NUM_ROWS(3)

cubrid_num_rows - Get the number of rows in the result set

SYNOPSIS
int cubrid_num_rows (resource $result)
DESCRIPTION
The cubrid_num_rows(3) 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 statement. When you want to know such value for INSERT, UPDATE, or DELETE query, you have to use the cubrid_affected_rows(3) func- tion. Note: The cubrid_num_rows(3) function can only be used for synchronous query; it returns 0 when it is used for asynchronous query.
PARAMETERS
o $result -$result comes from a call to cubrid_execute(3), cubrid_query(3) and cubrid_prepare(3)
RETURN VALUES
Number of rows, when process is successful. 0 when the query was done in async mode. -1, if SQL statement is not SELECT. FALSE when process is unsuccessful.
EXAMPLES
Example #1 cubrid_num_rows(3) 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 Column Num: %d ", $row_num, $col_num); cubrid_disconnect($conn); ?> The above example will output: Row Num: 6 Column Num: 2
SEE ALSO
cubrid_execute(3), cubrid_num_cols(3), cubrid_affected_rows(3). PHP Documentation Group CUBRID_NUM_ROWS(3)
Related Man Pages
cubrid_lob2_export(3) - php
cubrid_prepare(3) - php
cubrid_lob2_bind(3) - php
cubrid_query(3) - php
cubrid_set_drop(3) - php
Similar Topics in the Unix Linux Community
Optimizing query
If statement not working
Generating file from sqlplus
How to print multiple rows from database query?
Replace First Column and First Row Data