tflori/orm

» API Reference » ORM\QueryBuilder\ExecutesQueries

ORM\QueryBuilder\ExecutesQueries

Table of Contents

• Abstract
• Methods
  • $executesQueries->all - Get all rows from the query result
  • $executesQueries->delete - Execute a delete statement on the current table with current where conditions
  • $executesQueries->insert - Execute an insert statement on the current table
  • $executesQueries->one - Get the next row from the query result
  • $executesQueries->reset - Reset the position of the cursor to the first row
  • $executesQueries->setFetchMode - Proxy to PDOStatement::setFetchMode()
  • $executesQueries->update - Execute an update statement for the current query

Abstract

Trait ExecutesQueries for QueryBuilder

Hold all methods required from the query builder to execute queries.

Methods

ORM\QueryBuilder\ExecutesQueries::all

public function all(): array<int,mixed>

Get all rows from the query result

Please note that this will execute the query - further modifications will not have any effect.

If the query fails you should get an exception. Anyway if we couldn’t get a result or there are no rows it returns an empty array.

ORM\QueryBuilder\ExecutesQueries::all

↑ top

ORM\QueryBuilder\ExecutesQueries::delete

public function delete(): int

Execute a delete statement on the current table with current where conditions

ORM\QueryBuilder\ExecutesQueries::delete

↑ top

ORM\QueryBuilder\ExecutesQueries::insert

public function insert(array $rows): int

Execute an insert statement on the current table

Parameters

ORM\QueryBuilder\ExecutesQueries::insert

↑ top

ORM\QueryBuilder\ExecutesQueries::one

public function one(): mixed|null

Get the next row from the query result

Please note that this will execute the query - further modifications will not have any effect.

If the query fails you should get an exception. Anyway if we couldn’t get a result or there are no more rows it returns null.

ORM\QueryBuilder\ExecutesQueries::one

↑ top

ORM\QueryBuilder\ExecutesQueries::reset

public function reset(): $this

Reset the position of the cursor to the first row

ORM\QueryBuilder\ExecutesQueries::reset

↑ top

ORM\QueryBuilder\ExecutesQueries::setFetchMode

public function setFetchMode(
    int $mode, 
    int|string|object $classNameObject = null, 
    array $constructorArgs = null, 
): $this

Proxy to PDOStatement::setFetchMode()

Please note that this will execute the query - further modifications will not have any effect.

Parameters

See Also:

• PDOStatement::setFetchMode() - php manual

ORM\QueryBuilder\ExecutesQueries::setFetchMode

↑ top

ORM\QueryBuilder\ExecutesQueries::update

public function update(array $updates): int

Execute an update statement for the current query

NOTE: not all drivers support UPDATE with JOIN (or FROM). Has to be implemented in the database abstraction layer.

$updates should be an array which columns to update with what value. Use expressions to bypass escaping.

Parameters

ORM\QueryBuilder\ExecutesQueries::update

↑ top