PHP Manual
Prev |  | Next

# 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"; ?>`

## See Also

sqlite_changes()
sqlite_query()
sqlite_num_fields()

Prev | Home | Next
sqlite_num_fields | Up | sqlite_open