php man page for sqlite_num_rows

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 set

SYNOPSIS
int sqlite_num_rows (resource $result)
DESCRIPTION
Object oriented style (method): int SQLiteResult::numRows (void ) Returns the number of rows in the buffered $result set.
PARAMETERS
o $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 VALUES
Returns the number of rows, as an integer.
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"; ?>
SEE ALSO
sqlite_changes(3), sqlite_query(3), sqlite_num_fields(3). PHP Documentation Group SQLITE_NUM_ROWS(3)
Related Man Pages
maxdb_stmt_num_rows(3) - php
mysqli_stmt_num_rows(3) - php
pg_num_rows(3) - php
sqlite_array_query(3) - php
sqlite_fetch_single(3) - php
Similar Topics in the Unix Linux Community
sum of all matching rows using awk
how to add if data in rows
Split single rows to multiple rows ..
How do i add horizontally??
Columns to rows