sqlite_num_rows
(PHP 5)
sqlite_num_rows
(no version information, might be only in CVS)
SQLiteResult->numRows -- Returns the number of rows in a buffered result set
Description
int
sqlite_num_rows ( resource result )
Object oriented style (method):
class
SQLiteResult {
int
numRows ( void )
}
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 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";
?>
|
|