Documentation

CanBuildQuery

Table of Contents

dbDelete()  : DeleteQuery
Create a new DeleteQuery instance for the CakePHP\Database Connection.
dbInsert()  : InsertQuery
Create a new InsertQuery instance for the CakePHP\Database Connection.
dbSelect()  : SelectQuery
Create a new SelectQuery instance for the CakePHP\Database Connection.
dbUpdate()  : UpdateQuery
Create a new UpdateQuery instance for the CakePHP\Database Connection.
getQueryBuilder()  : mixed

Methods

dbDelete()

Create a new DeleteQuery instance for the CakePHP\Database Connection.

public dbDelete([string|null $table = null ][, array<string|int, mixed> $conditions = [] ][, array<string, string> $types = [] ]) : DeleteQuery
Parameters
$table : string|null = null

The table to delete rows from.

$conditions : array<string|int, mixed> = []

Conditions to be set for the delete statement.

$types : array<string, string> = []

Associative array containing the types to be used for casting.

Return values
DeleteQuery —

dbInsert()

Create a new InsertQuery instance for the CakePHP\Database Connection.

public dbInsert([string|null $table = null ][, array<string|int, mixed> $values = [] ][, array<int|string, string> $types = [] ]) : InsertQuery
Parameters
$table : string|null = null

The table to insert rows into.

$values : array<string|int, mixed> = []

Associative array of column => value to be inserted.

$types : array<int|string, string> = []

Associative array containing the types to be used for casting.

Return values
InsertQuery —

dbSelect()

Create a new SelectQuery instance for the CakePHP\Database Connection.

public dbSelect([ExpressionInterface|callable|array<string|int, mixed>|string $fields = [] ][, array<string|int, mixed>|string $table = [] ][, array<string, string> $types = [] ]) : SelectQuery
Parameters
$fields : ExpressionInterface|callable|array<string|int, mixed>|string = []

fields to be added to the list.

$table : array<string|int, mixed>|string = []

The table or list of tables to query.

$types : array<string, string> = []

Associative array containing the types to be used for casting.

Return values
SelectQuery —

dbUpdate()

Create a new UpdateQuery instance for the CakePHP\Database Connection.

public dbUpdate([ExpressionInterface|string|null $table = null ][, array<string|int, mixed> $values = [] ][, array<string|int, mixed> $conditions = [] ][, array<string, string> $types = [] ]) : UpdateQuery
Parameters
$table : ExpressionInterface|string|null = null

The table to update rows of.

$values : array<string|int, mixed> = []

Values to be updated.

$conditions : array<string|int, mixed> = []

Conditions to be set for the update statement.

$types : array<string, string> = []

Associative array containing the types to be used for casting.

Return values
UpdateQuery —

getQueryBuilder()

public getQueryBuilder() : mixed
Return values
mixed —

Search results