\
Omega
Application
Archive
Cache
Adapter
Exception
Factory
ServiceProvider
Config
ServiceProvider
Container
Exception
ServiceProvider
Database
Adapter
Command
Exception
Factory
Migration
Field
QueryBuilder
ServiceProvider
Environment
Command
Exception
Exceptions
Filesystem
Adapter
Amazon
Ftp
Local
Memory
Sftp
Contracts
Exception
Factory
ServiceProvider
Stream
Util
Http
ServiceProvider
Logging
Exception
Factory
ServiceProvider
Queue
Adapter
Command
Exception
Factory
ServiceProvider
Routing
ServiceProvider
Session
Exception
Factory
ServiceProvider
Storage
Support
Facade
Exception
Facades
Factory
Singleton
Exception
Validation
Exception
Rule
ServiceProvider
View
Engine
ServiceProvider

\Omega\Database\QueryBuilder QueryBuilderInterface

Abstract query builder class.

The AbstractQueryBuilder class provides a foundation for building SQL queries in an object-oriented manner. It supports various common SQL operations, including SELECT, INSERT, UPDATE, and DELETE queries. *

Summary

Methods
Constants
all()
getWhereValues()
prepare()
compileSelect()
compileLimit()
compileWheres()
compileInsert()
compileUpdate()
compileDelete()
first()
take()
from()
select()
insert()
where()
update()
getLastInsertId()
delete()
No public constants found

Methods

all()

all() : array<string,mixed>[]

Fetch all rows matching the current query.

Returns

array[] —

Returns an array containing all rows in the database.

getWhereValues()

getWhereValues() : array<string,mixed>

Get the values for the where clause placeholders.

Returns

array —

Return an array of result based on where clause.

prepare()

prepare() : \PdoStatement

Prepare a query against a particular connection.

Throws

\Omega\Database\Exception\QueryException

if unrecognized query type.

Returns

\PdoStatement —

Return an instance of PdoStatement.

compileSelect()

compileSelect(string  $query) : string

Add select clause to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled select clause.

compileLimit()

compileLimit(string  $query) : string

Add limit and offset clauses to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled limit clause.

compileWheres()

compileWheres(string  $query) : string

Add where clauses to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled where clause.

compileInsert()

compileInsert(string  $query) : string

Add insert clause to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled insert clause.

compileUpdate()

compileUpdate(string  $query) : string

Add update clause to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled update clause.

compileDelete()

compileDelete(string  $query) : string

Add delete clause to the query.

Parameters

string $query

Holds the query data.

Returns

string —

Return the compiled delete clause.

first()

first() : ?array<string,mixed>

Fetch the first row matching the current query.

Returns

?array —

Returns an array with the first row or null if no rows are found.

take()

take(int  $limit, int  $offset) : $this

Limit a set of query results to fetch a single or a limited batch of rows.

Parameters

int $limit

The limit for the set of query results.
int $offset

The offset.

Returns

$this —

from()

from(string  $table) : $this

Indicate which table the query is targeting.

Parameters

string $table

Holds the table name.

Returns

$this —

select()

select(mixed  $columns = '*') : $this

Indicate the query type is a "select" and remember which fields should be returned by the query.

Parameters

mixed $columns

Holds the column name.

Returns

$this —

insert()

insert(string[]  $columns, array  $values) : int|bool

Insert a row of data into the table specified in the query and return the number of affected rows.

Parameters

string[] $columns

Holds an array of columns.
array $values

Holds an array of values.

Returns

int|bool —

Return the number of affected rows.

where()

where(string  $column, mixed  $comparator, mixed  $value = null) : $this

Store where clause data for later queries.

Parameters

string $column

Holds the column name.
mixed $comparator

Holds the column comparator.
mixed $value

Holds the data to store or null.

Returns

$this —

update()

update(string[]  $columns, array  $values) : int|bool

Insert a row of data into the table specified in the query and return the number of affected rows.

Parameters

string[] $columns

Holds an array of columns.
array $values

Holds an array of values.

Returns

int|bool —

Return the number of affected rows.

getLastInsertId()

getLastInsertId() : string|false

Get the ID of the last row that was inserted.

Returns

string|false —

Return the last insert id.

delete()

delete() : int|bool

Delete a row from the database.

Returns

int|bool —