mini\Database\DatabaseInterface::update()
Method
public
abstract
Signature
public abstract function update(mini\Database\Query|mini\Database\PartialQuery $query, array|string $set, array $params = array (
)): intParameters
| Name | Type | Default | Description |
|---|---|---|---|
$query |
mini\Database\Query|mini\Database\PartialQuery |
required | Documentation missing |
$set |
array|string |
required | Documentation missing |
$params |
array |
array (
)
|
Documentation missing |
Returns
int
Documentation
Update rows matching a query
Respects WHERE clauses and LIMIT from the query. Ignores SELECT, ORDER BY, and OFFSET.
Use string for raw SQL expressions:
db()->update($query, 'login_count = login_count + 1')
db()->update($query, 'last_seen = ?, status = ?', [$now, 'active'])
Use array for simple assignments (values passed as-is):
db()->update($query, ['status' => 'archived', 'updated_at' => date('Y-m-d H:i:s')])
WARNING: Values are NOT converted automatically. You must handle conversion yourself (dates to strings, objects to JSON, etc).