sqlite_num_rows(3) php man page | unix.com

Man Page: sqlite_num_rows

Operating Environment: php

Section: 3

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
ifx_affected_rows(3) - php
mysqli_num_rows(3) - php
pg_num_rows(3) - php
sqlite_fetch_array(3) - php
sqlite_num_rows(3) - php
Similar Topics in the Unix Linux Community
sum of all matching rows using awk
Counting rows in many files
how to add if data in rows
extract rows that have a specific name
How do i add horizontally??