fbsql_num_rows

(PHP 4 >= 4.0.6, PHP 5, PHP 7)

fbsql_num_rows — Get number of rows in result

说明

fbsql_num_rows ( resource $result ) : int

Gets the number of rows in the given result set.

This function is only valid for SELECT statements. To retrieve the number of rows returned from a INSERT, UPDATE or DELETE query, use fbsql_affected_rows().

参数

result: 由 fbsql_query() 或 fbsql_db_query() 返回的结果标识符。

返回值

Returns the number of rows returned by the last SELECT statement.

范例

Example #1 fbsql_num_rows() example

 <?php

$link = fbsql_connect("localhost", "username", "password");
fbsql_select_db("database", $link);

$result = fbsql_query("SELECT * FROM table1;", $link);
$num_rows = fbsql_num_rows($result);

echo "$num_rows Rows\n";

?>

参见

fbsql_affected_rows() - Get number of affected rows in previous FrontBase operation
fbsql_connect() - Open a connection to a FrontBase Server
fbsql_select_db() - Select a FrontBase database
fbsql_query() - Send a FrontBase query

php cubrid 函数 get the number of rows in the result set php frontbase 函数 get number of affected rows in previous frontbase operation php frontbase 函数 get the length of each output in a result php frontbase 函数 fetch a result row as an object php frontbase 函数 get a result row as an enumerated array php frontbase 函数 move the internal result pointer to the next result php frontbase 函数 get number of fields in result php frontbase 函数 get number of rows in result php frontbase 函数 get the number of rows affected by the last statement php ingres 函数 get the number of rows affected or returned by a query php maxdb 函数 gets the number of rows in a result php maxdb 函数 return the number of rows in statements result set php msql 函数 get number of rows in result php mssql 函数 gets the number of rows in result php odbc 函数 number of rows in a result php postgresql 函数 fetches all rows in a particular result column as an array php sqlite 函数 returns the number of rows in a buffered result set php sqlsrv 函数 retrieves the number of rows in a result set php sybase 函数 get number of rows in a result set php solrquery specifies the maximum number of rows to return in the result