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
mysqli_affected_rows(3) - php
fbsql_num_rows(3) - php
maxdb_num_rows(3) - php
mysqli_num_rows(3) - php
sqlite_array_query(3) - php
Similar Topics in the Unix Linux Community
Script to convert rows to 1 record with delimter
how to add if data in rows
Split single rows to multiple rows ..
Moving or copying first rows and last rows into another file
Columns to rows