1. class
  2. Nette
  3. \
  4. Database
  5. \
  6. ResultSet

ResultSet

class ResultSet implements Iterator, IRowContainer

Represents a database result set.

Methods

__construct(Connection $connection, string $queryString, array $params, Closure|null $normalizer = null)

No description

Connection
getConnection() deprecated

No description

PDOStatement|null
getPdoStatement()

No description

string
getQueryString()

No description

array
getParameters()

No description

int|null
getColumnCount()

No description

int|null
getRowCount()

No description

array
getColumnTypes()

No description

float
getTime()

No description

array
normalizeRow(array $row)

No description

void
dump()

Displays result set as HTML table.

void
rewind()

No description

Row|false|null
current()

No description

int
key()

No description

void
next()

No description

bool
valid()

No description

array|null
fetchAssoc(string|null $path = null)

Returns the next row as an associative array, or null if there are no more rows.

Row|null
fetch()

Returns the next row as a Row object or null if there are no more rows.

mixed
fetchField()

Returns the first field of the next row or null if there are no more rows.

array|null
fetchList()

Returns the next row as indexed array or null if there are no more rows.

array|null
fetchFields()

Alias for fetchList().

array
fetchPairs(string|int|Closure|null $keyOrCallback = null, string|int|null $value = null)

No description

array
fetchAll()

Returns all remaining rows as array of Row objects.

Details

at line 34
__construct(Connection $connection, string $queryString, array $params, Closure|null $normalizer = null)

No description

Parameters

Connection $connection
string $queryString
array $params
Closure|null $normalizer

at line 70
Connection getConnection() deprecated

deprecated

No description

Return Value

Connection

at line 77
PDOStatement|null getPdoStatement()

internal  
 

No description

Return Value

PDOStatement|null

at line 83
string getQueryString()

No description

Return Value

string

at line 90
array getParameters()

No description

Return Value

array

at line 96
int|null getColumnCount()

No description

Return Value

int|null

at line 102
int|null getRowCount()

No description

Return Value

int|null

at line 109
array getColumnTypes()

No description

Return Value

array

at line 120
float getTime()

No description

Return Value

float

at line 131
array normalizeRow(array $row)

internal  
 

No description

Parameters

array $row

Return Value

array

at line 145
void dump()

Displays result set as HTML table.

Return Value

void

at line 154
void rewind()

No description

Return Value

void

at line 162
Row|false|null current()

No description

Return Value

Row|false|null

at line 168
int key()

No description

Return Value

int

at line 174
void next()

No description

Return Value

void

at line 180
bool valid()

No description

Return Value

bool

at line 198
array|null fetchAssoc(string|null $path = null)

Returns the next row as an associative array, or null if there are no more rows.

When $path is given, fetches all rows and restructures them using Arrays::associate().

Parameters

string|null $path

Return Value

array|null

at line 221
Row|null fetch()

Returns the next row as a Row object or null if there are no more rows.

Return Value

Row|null

at line 236
mixed fetchField()

Returns the first field of the next row or null if there are no more rows.

Return Value

mixed

at line 247
array|null fetchList()

Returns the next row as indexed array or null if there are no more rows.

Return Value

array|null

at line 258
array|null fetchFields()

Alias for fetchList().

Return Value

array|null

at line 271
array fetchPairs(string|int|Closure|null $keyOrCallback = null, string|int|null $value = null)

No description

Parameters

string|int|Closure|null $keyOrCallback
string|int|null $value

Return Value

array

at line 281
array fetchAll()

Returns all remaining rows as array of Row objects.

Return Value

array