Javascript debugger
Website design
↑
sqlite_num_rows
Returns the number of rows in a buffered result set
(PHP 5, PECL sqlite:1.0-1.0.3)
int sqlite_num_rows ( resource result )
Object oriented style (method):
SQLiteResult {
int numRows();
}Returns the number of rows in the buffered result set.
Parameters
- result
The SQLite result resource. This parameter is not required when using the object-oriented method.
Note:This function cannot be used with unbuffered result handles.
Examples
Example 2336. 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 2337. 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";
?>