SQLite3Stmt::reset
fetchArray() will return bool(false) in case of 0 rows.
The SQLite3Result class
Introduction
A class that handles result sets for the SQLite 3 extension.
Class synopsis
SQLite3Result
{
/* Methods */
}Table of Contents
- SQLite3Result::columnName — Returns the name of the nth column
- SQLite3Result::columnType — Returns the type of the nth column
- SQLite3Result::fetchArray — Fetches a result row as an associative or numerically indexed array or both
- SQLite3Result::finalize — Closes the result set
- SQLite3Result::numColumns — Returns the number of columns in the result set
- SQLite3Result::reset — Resets the result set back to the first row
add a note
User Contributed NotesSQLite3Result
claudiu at virtuamagic dot com
08-Mar-2010 11:34
08-Mar-2010 11:34
jonscully at gmail dot com
30-Nov-2009 10:35
30-Nov-2009 10:35
Since SQLite3Result::numRows is unavailable, use:
<?php
if ($res->numColumns() && $res->columnType(0) != SQLITE3_NULL) {
// have rows
} else {
// zero rows
}
?>
Because when there are zero rows:
* SQLite3Result::fetchArray will return '1'
* SQLite3Result::numColumns will return '1'
* Column type for column '0' will be SQLITE3_NULL