Explorer
class Explorer
Provides high-level database layer with ActiveRow pattern.
Methods
No description
No description
No description
No description
Executes callback inside a transaction.
No description
No description
No description
No description
Creates an ActiveRow instance, using the configured row mapping class if available.
Executes SQL query and returns the first row, or null if no rows were returned.
Executes SQL query and returns the first row as an associative array, or null.
Executes SQL query and returns the first field of the first row, or null.
Executes SQL query and returns the first row as an indexed array, or null.
Executes SQL query and returns the first row as an indexed array, or null.
No description
Executes SQL query and returns all rows as an array of Row objects.
Creates SQL literal value.
Details
at line 24
__construct(Connection $connection, IStructure $structure, Conventions|null $conventions = null, Storage|null $cacheStorage = null)
No description
at line 34
void
beginTransaction()
No description
at line 40
void
commit()
No description
at line 46
void
rollBack()
No description
at line 56
mixed
transaction(callable $callback)
Executes callback inside a transaction.
at line 62
string
getInsertId(string|null $sequence = null)
No description
at line 72
ResultSet
query(string $sql, mixed ...$params)
Generates and executes SQL query.
at line 83
ResultSet
queryArgs(string $sql, array $params)
deprecated
deprecated
No description
at line 93
Selection
table(string $table)
Returns table selection.
at line 99
Connection
getConnection()
No description
at line 105
IStructure
getStructure()
No description
at line 111
Conventions
getConventions()
No description
at line 122
ActiveRow
createActiveRow(array $data, Selection $selection)
Creates an ActiveRow instance, using the configured row mapping class if available.
at line 133
GroupedSelection
createGroupedSelection(Selection $refSelection, string $table, string $column)
| internal |
No description
at line 150
Row|null
fetch(string $sql, mixed ...$params)
Executes SQL query and returns the first row, or null if no rows were returned.
at line 161
array|null
fetchAssoc(string $sql, mixed ...$params)
Executes SQL query and returns the first row as an associative array, or null.
at line 171
mixed
fetchField(string $sql, mixed ...$params)
Executes SQL query and returns the first field of the first row, or null.
at line 182
array|null
fetchList(string $sql, mixed ...$params)
Executes SQL query and returns the first row as an indexed array, or null.
at line 193
array|null
fetchFields(string $sql, mixed ...$params)
Executes SQL query and returns the first row as an indexed array, or null.
at line 204
array
fetchPairs(string $sql, mixed ...$params)
No description
at line 215
array
fetchAll(string $sql, mixed ...$params)
Executes SQL query and returns all rows as an array of Row objects.
at line 224
static SqlLiteral
literal(string $value, mixed ...$params)
Creates SQL literal value.