mini\Database\DatabaseInterface::query()
Method
public
abstract
Signature
public abstract function query(string $sql, array $params = array (
)): mini\Database\QueryParameters
| Name | Type | Default | Description |
|---|---|---|---|
$sql |
string |
required | Documentation missing |
$params |
array |
array (
)
|
Documentation missing |
Returns
Documentation
Execute a SELECT query and return a composable Query
Returns a Query that can be iterated, further composed, or used for updates/deletes (if single-table). Rows are returned as stdClass objects.
Example:
// Iterate directly
foreach (db()->query('SELECT * FROM users WHERE active = ?', [1]) as $row) {
echo $row->name;
}
// Compose further
$admins = db()->query('SELECT * FROM users')
->eq('role', 'admin')
->order('name')
->limit(10);
// Use for delete (single-table queries only)
db()->delete(db()->query('SELECT * FROM users')->eq('status', 'inactive'));