Class Result

Summary

Fully Qualified Name: CodeIgniter\Database\SQLite3\Result
Extends: BaseResult
Implements: ResultInterface

Description

Result for SQLite3

Methods

Name Description Defined By
__construct() Constructor BaseResult
dataSeek() Moves the internal pointer to the desired offset. This is called internally before fetching results to make sure the result set starts at zero. Result
freeResult() Frees the current result. Result
getCustomResultObject() Returns the results as an array of custom objects. BaseResult
getCustomRowObject() Returns a row as a custom class instance. BaseResult
getFieldCount() Gets the number of fields in the result set. Result
getFieldData() Generates an array of objects representing field meta-data. Result
getFieldNames() Generates an array of column names in the result set. Result
getFirstRow() Returns the "first" row of the current results. BaseResult
getLastRow() Returns the "last" row of the current results. BaseResult
getNextRow() Returns the "next" row of the current results. BaseResult
getPreviousRow() Returns the "previous" row of the current results. BaseResult
getResult() Retrieve the results of the query. Typically an array of individual data rows, which can be either an 'array', an 'object', or a custom class name. BaseResult
getResultArray() Returns the results as an array of arrays. BaseResult
getResultObject() Returns the results as an array of objects. BaseResult
getRow() Wrapper object to return a row as either an array, an object, or a custom class. BaseResult
getRowArray() Returns a single row from the results as an array. BaseResult
getRowObject() Returns a single row from the results as an object. BaseResult
getUnbufferedRow() Returns an unbuffered row and move the pointer to the next row. BaseResult
setRow() Assigns an item into a particular column slot. BaseResult

Method Details

__construct()

Constructor

Parameter Name Type Description
$connID object|resource
$resultID object|resource

Returns:

dataSeek()

Moves the internal pointer to the desired offset. This is called internally before fetching results to make sure the result set starts at zero.

Parameter Name Type Description
$n int

Returns: mixed

freeResult()

Frees the current result.

Returns: void

getCustomResultObject()

Returns the results as an array of custom objects.

Parameter Name Type Description
$className string The

Returns: mixed

getCustomRowObject()

Returns a row as a custom class instance.

If row doesn't exists, returns null.

Parameter Name Type Description
$n int
$className string

Returns: mixed

getFieldCount()

Gets the number of fields in the result set.

Returns: int

getFieldData()

Generates an array of objects representing field meta-data.

Returns: array

getFieldNames()

Generates an array of column names in the result set.

Returns: array

getFirstRow()

Returns the "first" row of the current results.

Parameter Name Type Description
$type string

Returns: mixed

getLastRow()

Returns the "last" row of the current results.

Parameter Name Type Description
$type string

Returns: mixed

getNextRow()

Returns the "next" row of the current results.

Parameter Name Type Description
$type string

Returns: mixed

getPreviousRow()

Returns the "previous" row of the current results.

Parameter Name Type Description
$type string

Returns: mixed

getResult()

Retrieve the results of the query. Typically an array of individual data rows, which can be either an 'array', an 'object', or a custom class name.

Parameter Name Type Description
$type string The

Returns: array

getResultArray()

Returns the results as an array of arrays.

If no results, an empty array is returned.

Returns: array

getResultObject()

Returns the results as an array of objects.

If no results, an empty array is returned.

Returns: array

getRow()

Wrapper object to return a row as either an array, an object, or a custom class.

If row doesn't exist, returns null.

Parameter Name Type Description
$n mixed The
$type string The

Returns: mixed

getRowArray()

Returns a single row from the results as an array.

If row doesn't exist, returns null.

Parameter Name Type Description
$n int

Returns: mixed

getRowObject()

Returns a single row from the results as an object.

If row doesn't exist, returns null.

Parameter Name Type Description
$n int

Returns: mixed

getUnbufferedRow()

Returns an unbuffered row and move the pointer to the next row.

Parameter Name Type Description
$type string

Returns: mixed

setRow()

Assigns an item into a particular column slot.

Parameter Name Type Description
$key mixed
$value mixed

Returns: mixed

Top