cubrid_num_rows

Description

The cubrid_num_rows() function is used to return the number of rows in the query result. This is available only with the SELECT statement. Use cubrid_affected_rows() if you want to know the results of INSERT, UPDATE and DELETE queries. cubrid_num_rows() can be used only with synchronous queries. It returns 0 if the query is asynchronous.

Syntax

int cubrid_num_rows (resource $request)

• request : Request that comes from a call to cubrid_execute()

Return Value

• Success : The number of rows
• Asynchronous query : 0
• Failure : FALSE

Example

<?php

$conn = cubrid_connect("localhost", 33000, "demodb");

$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

See Also

• cubrid_execute
• cubrid_num_cols
• cubrid_affected_rows