TableSelect
class TableSelect implements Executable (View source)
Class TableSelect
Methods
Binds a value to a specific placeholder.
Sets a grouping criteria for the result set.
Sets a condition for records to consider in aggregate function operations.
Sets the maximum number of records or documents to return.
Execute a read operation with EXCLUSIVE LOCK. Only one lock can be active at a time.
Execute a read operation with SHARED LOCK. Only one lock can be active at a time.
Skip given number of rows in result.
Sets the order by criteria.
Sets the search condition to filter.
Details
TableSelect
bind(array $placeholder_values)
Binds a value to a specific placeholder.
Result
execute()
Execute the select statement by chaining it with the execute() method.
TableSelect
groupBy(mixed $sort_expr)
Sets a grouping criteria for the result set.
TableSelect
having(string $sort_expr)
Sets a condition for records to consider in aggregate function operations.
TableSelect
limit(int $rows)
Sets the maximum number of records or documents to return.
TableSelect
lockExclusive(int|null $lock_waiting_option)
Execute a read operation with EXCLUSIVE LOCK. Only one lock can be active at a time.
TableSelect
lockShared(int|null $lock_waiting_option)
Execute a read operation with SHARED LOCK. Only one lock can be active at a time.
TableSelect
offset(int $position)
Skip given number of rows in result.
TableSelect
orderby(string|string[] ...$sort_expr)
Sets the order by criteria.
TableSelect
where(string $where_expr)
Sets the search condition to filter.