Public Member Functions | |
| __construct ($result, $connection) | |
| Constructor. | |
| affected_rows () | |
| Return num of affected rows from insert/delete/update query. | |
| fetch_array () | |
| Return resultset as assoc array. | |
| fetch_object () | |
| Return resultset as object. | |
| fetch_row () | |
| Return resultset as numeric array. | |
| field ($field) | |
| Return record from select query. | |
| flush () | |
| Free resultset memory - destroy resultset object. | |
| num_fields () | |
| Return num fields from select query. | |
| num_rows () | |
| Return num rows from select query - MUST be used with "select count(*)". | |
| result () | |
| Return resultset object. | |
Definition at line 15 of file sqlite3Resultset.php.
| __construct | ( | $ | result, | |
| $ | connection | |||
| ) |
Constructor.
public
| mixed | $result | |
| mixed | $connection |
Definition at line 56 of file sqlite3Resultset.php.
{
$this->objConnection = $connection;
$this->objResult = $result;
}
| affected_rows | ( | ) |
Return num of affected rows from insert/delete/update query.
public
Definition at line 68 of file sqlite3Resultset.php.
{
if ( $this->objResult )
return $this->objConnection->changes();
}
| fetch_array | ( | ) |
Return resultset as assoc array.
public
Definition at line 80 of file sqlite3Resultset.php.
{
if ( $this->objResult )
{
$this->objRecord = $this->objResult->fetchArray( SQLITE3_ASSOC );
return ( $this->objRecord !== false );
}
}
| fetch_object | ( | ) |
Return resultset as object.
public
Definition at line 96 of file sqlite3Resultset.php.
{
trigger_error( '<p>SQLite3 does not support FETCH_OBJECT. You must use the SQLite or PDO extension!</p>', E_USER_WARNING );
return false;
}
| fetch_row | ( | ) |
Return resultset as numeric array.
public
Definition at line 108 of file sqlite3Resultset.php.
{
if ( $this->objResult )
{
$this->objRecord = $this->objResult->fetchArray( SQLITE3_NUM );
return ( $this->objRecord !== false );
}
}
| field | ( | $ | field | ) |
Return record from select query.
public
| mixed | $field |
Definition at line 125 of file sqlite3Resultset.php.
{
if ( $this->objResult )
{
if ( get_magic_quotes_runtime() )
return stripslashes( $this->objRecord[$field] );
else
return $this->objRecord[$field];
}
}
| flush | ( | ) |
Free resultset memory - destroy resultset object.
public
Definition at line 141 of file sqlite3Resultset.php.
{
if ( $this->objResult )
{
unset( $this->objConnection );
$this->objRecord = array();
return ( $this->objResult->finalize() ) ? true : false;
}
}
| num_fields | ( | ) |
Return num fields from select query.
public
Definition at line 158 of file sqlite3Resultset.php.
{
if ( $this->objResult )
return $this->objResult->numColumns();
}
| num_rows | ( | ) |
Return num rows from select query - MUST be used with "select count(*)".
public
Definition at line 170 of file sqlite3Resultset.php.
{
if ( $this->objResult )
{
while ( $row = $this->objResult->fetchArray( SQLITE3_NUM ) )
return $row[0];
}
}
| result | ( | ) |
Return resultset object.
public
Definition at line 185 of file sqlite3Resultset.php.
{
return $this->objResult;
}
1.7.1