1. class
  2. GenericDatabase
  3. \
  4. Engine
  5. \
  6. OCI
  7. \
  8. Connection
  9. \
  10. Fetch
  11. \
  12. FetchHandler

FetchHandler

class FetchHandler extends AbstractFetch implements IFetch (View source)

Concrete implementation for OCI database

Properties

static protected IConnection $instance from  AbstractFetch
static protected IFetchStrategy $fetchStrategy from  AbstractFetch

Methods

__construct(IConnection $instance, IFetchStrategy $fetchStrategy)

Initialize fetch abstraction with connection and strategy

from  AbstractFetch
IFetchStrategy
getStrategy()

Get the current fetch strategy

from  AbstractFetch
IConnection
getInstance()

Get the database connection instance

from  AbstractFetch
object|false
internalFetchClass(array|null $constructorArguments = null, string|null $aClassOrObject = '\\stdClass')

Fetches a single row from the result set as an object

from  AbstractFetch
bool|array
internalFetchBoth()

Fetches the current row as both an associative and a numeric array.

from  AbstractFetch
array|null|false
internalFetchAssoc()

Fetches a single row from the result set as a numerically indexed array, converting all values to strings, or returns false if there are no more rows.

from  AbstractFetch
array|false|null
internalFetchNum()

Fetches the current row as a numeric array.

from  AbstractFetch
false|string
internalFetchColumn(int $columnIndex = 0)

Fetches a single value from the result set, or false if there are no more rows.

from  AbstractFetch
array
internalFetchAllAssoc()

Fetches all rows from the result set as an associative array, or an empty array if there are no more rows.

from  AbstractFetch
array
internalFetchAllNum()

Fetches all rows from the result set as a numerically indexed array of arrays, converting all values to strings, or an empty array if there are no more rows.

from  AbstractFetch
array
internalFetchAllBoth()

Fetches all rows from the result set as an array of arrays, where each row is both numerically and associatively indexed.

from  AbstractFetch
array
internalFetchAllColumn(int $columnIndex = 0)

Fetches all values of a single column from the result set as an array of strings.

from  AbstractFetch
array
internalFetchAllClass(array|null $constructorArguments = [], string|null $aClassOrObject = '\\stdClass')

Fetches all rows from the result set as an array of objects, each one being an instance of the provided class.

from  AbstractFetch
mixed
fetch(int|null $fetchStyle = null, mixed $fetchArgument = null, mixed $optArgs = null)

Fetches the next row from a result set

mixed
fetchAll(int|null $fetchStyle = null, mixed $fetchArgument = 0, mixed $optArgs = null)

Fetches all rows from a result set

Details

in AbstractFetch at line 63
__construct(IConnection $instance, IFetchStrategy $fetchStrategy)

Initialize fetch abstraction with connection and strategy

Parameters

IConnection $instance

Database connection instance
IFetchStrategy $fetchStrategy

Strategy for fetching results

in AbstractFetch at line 74
IFetchStrategy getStrategy()

Get the current fetch strategy

Return Value

IFetchStrategy

Current fetch strategy instance

in AbstractFetch at line 84
IConnection getInstance()

Get the database connection instance

Return Value

IConnection

Current database connection instance

in AbstractFetch at line 97
object|false internalFetchClass(array|null $constructorArguments = null, string|null $aClassOrObject = '\\stdClass')

Fetches a single row from the result set as an object

Parameters

array|null $constructorArguments

Arguments to pass to the class constructor.
string|null $aClassOrObject

Class name or object to hydrate.

Return Value

object|false

Exceptions

ReflectionException

in AbstractFetch at line 123
bool|array internalFetchBoth()

Fetches the current row as both an associative and a numeric array.

Return Value

bool|array

Returns an associative and numeric array if successful, false on failure.

in AbstractFetch at line 153
array|null|false internalFetchAssoc()

Fetches a single row from the result set as a numerically indexed array, converting all values to strings, or returns false if there are no more rows.

Return Value

array|null|false

A numerically indexed array of the row values as strings, false if no more rows, or null on error.

in AbstractFetch at line 174
array|false|null internalFetchNum()

Fetches the current row as a numeric array.

Return Value

array|false|null

Returns a numeric array if successful, null if no row was found, or false on failure.

in AbstractFetch at line 197
false|string internalFetchColumn(int $columnIndex = 0)

Fetches a single value from the result set, or false if there are no more rows.

Parameters

int $columnIndex

Index of the value to fetch. If not provided, fetches the first column.

Return Value

false|string

The value of the row at the specified index, false if no more rows, or null on error.

in AbstractFetch at line 222
array internalFetchAllAssoc()

Fetches all rows from the result set as an associative array, or an empty array if there are no more rows.

Return Value

array

An associative array of the row values as strings, or an empty array if no more rows, or null on error.

in AbstractFetch at line 238
array internalFetchAllNum()

Fetches all rows from the result set as a numerically indexed array of arrays, converting all values to strings, or an empty array if there are no more rows.

Return Value

array

A numerically indexed array of the row values as strings, or an empty array if no more rows, or null on error.

in AbstractFetch at line 259
array internalFetchAllBoth()

Fetches all rows from the result set as an array of arrays, where each row is both numerically and associatively indexed.

All values are converted to strings. If there are no more rows, an empty array is returned.

Return Value

array

An array of the row values as strings, with both numerical and associative indexes, or an empty array if no more rows, or null on error.

in AbstractFetch at line 287
array internalFetchAllColumn(int $columnIndex = 0)

Fetches all values of a single column from the result set as an array of strings.

Parameters

int $columnIndex

Index of the value to fetch. If not provided, fetches the first column.

Return Value

array

An array of the column values as strings, or an empty array if no more rows, or null on error.

in AbstractFetch at line 315
array internalFetchAllClass(array|null $constructorArguments = [], string|null $aClassOrObject = '\\stdClass')

Fetches all rows from the result set as an array of objects, each one being an instance of the provided class.

The class is created with the provided constructor arguments and properties are set with the values from the row. If there are no more rows, an empty array is returned.

Parameters

array|null $constructorArguments

Arguments to pass to the class constructor.
string|null $aClassOrObject

Class name or object to hydrate.

Return Value

array

An array of the row values as objects, or an empty array if no more rows, or null on error.

Exceptions

ReflectionException

at line 19
mixed fetch(int|null $fetchStyle = null, mixed $fetchArgument = null, mixed $optArgs = null)

Fetches the next row from a result set

Parameters

int|null $fetchStyle

The fetch style to use.
mixed $fetchArgument

The fetch argument to use.
mixed $optArgs

Additional options for the fetch operation.

Return Value

mixed

The query result.

Exceptions

ReflectionException

at line 38
mixed fetchAll(int|null $fetchStyle = null, mixed $fetchArgument = 0, mixed $optArgs = null)

Fetches all rows from a result set

Parameters

int|null $fetchStyle

The fetch style to use.
mixed $fetchArgument

The fetch argument to use.
mixed $optArgs

Additional options for the fetch operation.

Return Value

mixed

The query result.

Exceptions

ReflectionException