UpdateQuery
in package
implements
IQuery
uses
Log, SQLBuilder
Table of Contents
Interfaces
Properties
- $colIndexes : array<string|int, mixed>
- $table : string
- $values : array<string|int, mixed>
- $where : array<string|int, mixed>
Methods
- __construct() : mixed
- addWhere() : mixed
- execute() : IResultSet|bool
- setValues() : mixed
- sqlOrderBy() : string
- sqlWhere() : mixed
- sqlColumns() : string
- sqlDeleteQuery() : string
- sqlInsertQuery() : string
- sqlJoins() : string
- sqlSelectQuery() : string
- sqlUpdateQuery() : string
Properties
$colIndexes
protected
array<string|int, mixed>
$colIndexes
= []
$table
protected
string
$table
$values
protected
array<string|int, mixed>
$values
= []
$where
protected
array<string|int, mixed>
$where
= []
Methods
__construct()
public
__construct(mysqli $dbc, string $table[, array<string|int, mixed> $where = [] ]) : mixed
Parameters
- $dbc : mysqli
- $table : string
- $where : array<string|int, mixed> = []
addWhere()
public
addWhere(string $where) : mixed
Parameters
- $where : string
execute()
public
execute() : IResultSet|bool
Return values
IResultSet|boolsetValues()
public
setValues(array<string|int, mixed> $values) : mixed
Parameters
- $values : array<string|int, mixed>
sqlOrderBy()
public
sqlOrderBy(array<string|int, mixed> $orderColumns) : string
Parameters
- $orderColumns : array<string|int, mixed>
Return values
stringsqlWhere()
public
sqlWhere(array<string|int, mixed> $where) : mixed
Parameters
- $where : array<string|int, mixed>
sqlColumns()
protected
sqlColumns(array<string|int, mixed> $tableColumns) : string
Parameters
- $tableColumns : array<string|int, mixed>
-
[$table => [ $column, ... ], ...]
Return values
stringsqlDeleteQuery()
protected
sqlDeleteQuery(string $table, string $where) : string
Parameters
- $table : string
- $where : string
-
condition
Return values
stringsqlInsertQuery()
protected
sqlInsertQuery(array<string|int, mixed> $values, string $table) : string
Parameters
- $values : array<string|int, mixed>
-
[$field => $value, ...]
- $table : string
Return values
stringsqlJoins()
protected
sqlJoins(array<string|int, mixed> $joins) : string
Parameters
- $joins : array<string|int, mixed>
Return values
stringsqlSelectQuery()
protected
sqlSelectQuery(array<string|int, mixed> $columns, string $table, array<string|int, mixed> $joins, array<string|int, mixed> $where, array<string|int, mixed> $orderColumns) : string
Parameters
- $columns : array<string|int, mixed>
-
[$table => [ $column, ... ], ...]
- $table : string
- $joins : array<string|int, mixed>
-
array of sql joins
- $where : array<string|int, mixed>
-
array of where clauses joined with AND
- $orderColumns : array<string|int, mixed>
-
array of order clauses joined with ,
Return values
stringsqlUpdateQuery()
protected
sqlUpdateQuery(array<string|int, mixed> $values, string $table, string $where) : string
Parameters
- $values : array<string|int, mixed>
- $table : string
- $where : string
-
condition