Jelix 1.6.40

sqlite3DbResultSet extends jDbResultSet
in package

Couche d'encapsulation des resultset sqlite.

Tags
subpackage

db_driver

Table of Contents

$_currentRecord  : mixed
$_fetchMode  : mixed
$_fetchModeCtoArgs  : mixed
$_fetchModeParam  : mixed
$_idResult  : mixed
$_recordIndex  : mixed
$buffer  : mixed
contains all unreaded records when rowCount() have been called
$ended  : mixed
when reaching the end of a result set, sqlite3 api do a rewind we don't want this behavior, to mimic the behavior of other drivers this property indicates that we reached the end.
$modifier  : array<string|int, callable>
a callback function which will modify on the fly record's value
$numRows  : mixed
number of rows
__construct()  : mixed
__destruct()  : mixed
addModifier()  : mixed
bindColumn()  : mixed
not implemented
bindParam()  : mixed
not implemented
bindValue()  : mixed
not implemented
columnCount()  : mixed
not implemented
current()  : mixed
execute()  : mixed
not implemented
fetch()  : object|bool
fetch a result. The result is returned as an object.
fetchAll()  : array<string|int, object>
Return all results in an array. Each result is an object.
getAttribute()  : mixed
not implemented
id()  : mixed
key()  : mixed
next()  : mixed
rewind()  : mixed
rowCount()  : mixed
setAttribute()  : mixed
not implemented
setFetchMode()  : mixed
set the fetch mode.
unescapeBin()  : string
valid()  : mixed
_fetch()  : mixed
_free()  : mixed
_rewind()  : mixed
applyModifiers()  : mixed

Properties

$buffer

contains all unreaded records when rowCount() have been called

protected mixed $buffer = array()

$ended

when reaching the end of a result set, sqlite3 api do a rewind we don't want this behavior, to mimic the behavior of other drivers this property indicates that we reached the end.

protected mixed $ended = alse

$modifier

a callback function which will modify on the fly record's value

protected array<string|int, callable> $modifier = array()
Tags
since
1.1.6

Methods

__construct()

public __construct(mixed $idResult) : mixed
Parameters
$idResult : mixed
Return values
mixed

addModifier()

public addModifier(callable $function) : mixed
Parameters
$function : callable

a callback function the function should accept in parameter the record, and the resulset object

Tags
since
1.1.6
Return values
mixed

bindColumn()

not implemented

public bindColumn(mixed $column, mixed &$param[, mixed $type = null ]) : mixed
Parameters
$column : mixed
$param : mixed
$type : mixed = null
Return values
mixed

bindParam()

not implemented

public bindParam(mixed $parameter, mixed &$variable[, mixed $data_type = null ][, mixed $length = null ][, mixed $driver_options = null ]) : mixed
Parameters
$parameter : mixed
$variable : mixed
$data_type : mixed = null
$length : mixed = null
$driver_options : mixed = null
Return values
mixed

bindValue()

not implemented

public bindValue(mixed $parameter, mixed $value, mixed $data_type) : mixed
Parameters
$parameter : mixed
$value : mixed
$data_type : mixed
Return values
mixed

execute()

not implemented

public execute([mixed $parameters = null ]) : mixed
Parameters
$parameters : mixed = null
Return values
mixed

fetch()

fetch a result. The result is returned as an object.

public fetch() : object|bool
Return values
object|bool

result object or false if there is no more result

fetchAll()

Return all results in an array. Each result is an object.

public fetchAll() : array<string|int, object>
Return values
array<string|int, object>

getAttribute()

not implemented

public getAttribute(mixed $attr) : mixed
Parameters
$attr : mixed
Return values
mixed

setAttribute()

not implemented

public setAttribute(mixed $attr, mixed $value) : mixed
Parameters
$attr : mixed
$value : mixed
Return values
mixed

setFetchMode()

set the fetch mode.

public setFetchMode(int $fetchmode[, string|object $param = null ][, array<string|int, mixed> $ctoargs = null ]) : mixed
Parameters
$fetchmode : int

FETCH_OBJ, FETCH_CLASS or FETCH_INTO

$param : string|object = null

class name if FETCH_CLASS, an object if FETCH_INTO. else null.

$ctoargs : array<string|int, mixed> = null

arguments for the constructor if FETCH_CLASS

Return values
mixed

unescapeBin()

public unescapeBin(string $text) : string
Parameters
$text : string

a binary string to unescape

Tags
since
1.1.6
Return values
string

the unescaped string

applyModifiers()

protected applyModifiers(mixed $result) : mixed
Parameters
$result : mixed
Return values
mixed

Search results