sqlite_num_rows

SQLiteResult->numRows

(No version information available, might be only in CVS)

SQLiteResult->numRows — Returns the number of rows in a buffered result set

说明

int sqlite_num_rows ( resource $result )

Object oriented style (method):

SQLiteResult

int numRows ( void )

Returns the number of rows in the buffered result set.

参数

result: The SQLite result resource. This parameter is not required when using the object-oriented method.

Note: 本函数不能用于未缓冲的结果句柄。

范例

Example#1 Procedural example


<?php
$db = sqlite_open('mysqlitedb');
$result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'");
$rows = sqlite_num_rows($result);

echo "Number of rows: $rows";
?>

Example#2 Object-oriented example


<?php
$db = new SQLiteDatabase('mysqlitedb');
$result = $db->query("SELECT * FROM mytable WHERE name='John Doe'");
$rows = $result->numRows();

echo "Number of rows: $rows";
?>


	PHP5中文手册 sqlite_num_fields sqlite_open SQLite PHP Manual sqlite_num_rows SQLiteResult->numRows (No version information available, might be only in CVS) SQLiteResult->numRows — Returns the number of rows in a buffered result set 说明 int sqlite_num_rows ( resource `$result` ) Object oriented style (method): SQLiteResult int numRows ( void ) Returns the number of rows in the buffered `result` set. 参数 `result` The SQLite result resource. This parameter is not required when using the object-oriented method. Note: 本函数不能用于未缓冲的结果句柄。范例 Example#1 Procedural example `<?php $db = sqlite_open('mysqlitedb'); $result = sqlite_query($db, "SELECT * FROM mytable WHERE name='John Doe'"); $rows = sqlite_num_rows($result); echo "Number of rows: $rows"; ?>` Example#2 Object-oriented example `<?php $db = new SQLiteDatabase('mysqlitedb'); $result = $db->query("SELECT * FROM mytable WHERE name='John Doe'"); $rows = $result->numRows(); echo "Number of rows: $rows"; ?>` 参见 sqlite_changes() sqlite_query() sqlite_num_fields() sqlite_num_fields sqlite_open SQLite PHP Manual

sqlite_num_rows

SQLiteResult->numRows

说明

参数

范例

参见