Query: sqlite_num_rows
OS: php
Section: 3
Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar
SQLITE_NUM_ROWS(3) SQLITE_NUM_ROWS(3) sqlite_num_rows - Returns the number of rows in a buffered result setSYNOPSISint sqlite_num_rows (resource $result)DESCRIPTIONObject oriented style (method): int SQLiteResult::numRows (void ) Returns the number of rows in the buffered $result set.PARAMETERSo $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.RETURN VALUESReturns the number of rows, as an integer.EXAMPLESExample #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"; ?>SEE ALSOsqlite_changes(3), sqlite_query(3), sqlite_num_fields(3). PHP Documentation Group SQLITE_NUM_ROWS(3)