class Result implements IDataSource

Query result.

Properties

int read-only $rowCount

Methods

__construct(ResultDriver $driver, bool $normalize = true)

No description

void
free()

Frees the resources allocated for this result set.

getResultDriver()

Safe access to property $driver.

bool
seek(int $row)

Moves cursor position without fetching row.

int
count()

Required by the Countable interface.

int
getRowCount()

Returns the number of rows in a result set.

getIterator()

Required by the IteratorAggregate interface.

int
getColumnCount()

Returns the number of columns in a result set.

setRowClass(string|null $class)

Set fetched object class. This class should extend the Row class.

string|null
getRowClass()

Returns fetched object class name.

setRowFactory(callable $callback)

Set a factory to create fetched object instances. These should extend the Row class.

mixed
fetch()

Fetches the row at current position, process optional type conversion.

mixed
fetchSingle()

Like fetch(), but returns only first field.

array
fetchAll(int|null $offset = null, int|null $limit = null)

Fetches all records from table.

array
fetchAssoc(string $assoc)

Fetches all records from table and returns associative tree.

array
fetchPairs(string|null $key = null, string|null $value = null)

Fetches all records from table like $key => $value pairs.

setType(string $column, string|null $type)

Define column type.

string|null
getType(string $column)

Returns column type.

array
getTypes()

Returns columns type.

setFormat(string $type, string|null $format)

Sets type format.

setFormats(array $formats)

Sets type formats.

string|null
getFormat(string $type)

Returns data format.

getInfo()

Returns a meta information about the current result set.

array
getColumns()

No description

void
dump()

Displays complete result set as HTML or text table for debug purposes.

Details

at line 37
__construct(ResultDriver $driver, bool $normalize = true)

No description

Parameters

ResultDriver $driver
bool $normalize

at line 49
final void free()

Frees the resources allocated for this result set.

Return Value

void

at line 62
final ResultDriver getResultDriver()

Safe access to property $driver.

Return Value

ResultDriver

Exceptions

RuntimeException

at line 79
final bool seek(int $row)

Moves cursor position without fetching row.

Parameters

int $row

Return Value

bool

Exceptions

Exception

at line 90
final int count()

Required by the Countable interface.

Return Value

int

at line 99
final int getRowCount()

Returns the number of rows in a result set.

Return Value

int

at line 108
final ResultIterator getIterator()

Required by the IteratorAggregate interface.

Return Value

ResultIterator

at line 117
final int getColumnCount()

Returns the number of columns in a result set.

Return Value

int

at line 129
Result setRowClass(string|null $class)

Set fetched object class. This class should extend the Row class.

Parameters

string|null $class

Return Value

Result

at line 139
string|null getRowClass()

Returns fetched object class name.

Return Value

string|null

at line 148
Result setRowFactory(callable $callback)

Set a factory to create fetched object instances. These should extend the Row class.

Parameters

callable $callback

Return Value

Result

at line 159
final mixed fetch()

Fetches the row at current position, process optional type conversion.

and moves the internal cursor to the next position

Return Value

mixed

at line 182
final mixed fetchSingle()

Like fetch(), but returns only first field.

Returns value on success, null if no next record

Return Value

mixed

at line 199
final array fetchAll(int|null $offset = null, int|null $limit = null)

Fetches all records from table.

Parameters

int|null $offset
int|null $limit

Return Value

array

at line 231
final array fetchAssoc(string $assoc)

Fetches all records from table and returns associative tree.

Examples:

  • associative descriptor: col1[]col2->col3 builds a tree: $tree[$val1][$index][$val2]->col3[$val3] = {record}
  • associative descriptor: col1|col2->col3=col4 builds a tree: $tree[$val1][$val2]->col3[$val3] = val4

Parameters

string $assoc

Return Value

array

Exceptions

InvalidArgumentException

at line 372
final array fetchPairs(string|null $key = null, string|null $value = null)

Fetches all records from table like $key => $value pairs.

Parameters

string|null $key
string|null $value

Return Value

array

Exceptions

InvalidArgumentException

at line 524
final Result setType(string $column, string|null $type)

Define column type.

Parameters

string $column
string|null $type

use constant Type::*

Return Value

Result

at line 534
final string|null getType(string $column)

Returns column type.

Parameters

string $column

Return Value

string|null

at line 543
final array getTypes()

Returns columns type.

Return Value

array

at line 552
final Result setFormat(string $type, string|null $format)

Sets type format.

Parameters

string $type
string|null $format

Return Value

Result

at line 562
final Result setFormats(array $formats)

Sets type formats.

Parameters

array $formats

Return Value

Result

at line 572
final string|null getFormat(string $type)

Returns data format.

Parameters

string $type

Return Value

string|null

at line 584
Result getInfo()

Returns a meta information about the current result set.

Return Value

Result

at line 595
final array getColumns()

No description

Return Value

array

at line 607
final void dump()

Displays complete result set as HTML or text table for debug purposes.

Return Value

void