class TableUpdate implements Executable (View source)

Class TableUpdate

Methods

bind(array $placeholder_values)

Bind update query parameters

execute()

Executes the update statement.

limit(int $rows)

Set the maximum number of records or documents update.

orderby(?string|?string[] ...$orderby_expr)

Sets the sorting criteria.

set(string $table_field, string $expression_or_literal)

Updates the column value on records in a table.

where(string $where_expr)

Set the search condition to filter.

Details

TableUpdate bind(array $placeholder_values)

Bind update query parameters

Parameters

array $placeholder_values

The name of the placeholder, and the value to bind, defined as a JSON array.

Return Value

TableUpdate

Result execute()

Executes the update statement.

Return Value

Result

TableUpdate limit(int $rows)

Set the maximum number of records or documents update.

Parameters

int $rows

Return Value

TableUpdate

TableUpdate orderby(?string|?string[] ...$orderby_expr)

Sets the sorting criteria.

Parameters

?string|?string[] ...$orderby_expr

The expressions that define the order by criteria. Can be an array with one or more expressions, or a string.

Return Value

TableUpdate

TableUpdate set(string $table_field, string $expression_or_literal)

Updates the column value on records in a table.

Parameters

string $table_field
string $expression_or_literal

Return Value

TableUpdate

TableUpdate where(string $where_expr)

Set the search condition to filter.

Parameters

string $where_expr

Return Value

TableUpdate