Select
in package
Class Select
Usage:
$result = DB::select(array('*', '*', 'schlumpf, nase, dumm', array('eins', 'zwei', 'drei'), array(array('nana'), 'bla')), DB::tab('foodDelivery_restaurants_locations'));
Tags
Table of Contents
- $leftJoin : array<string|int, mixed>
- $limit : int
- $params : array<string|int, mixed>
- $selectColumns : string|array<string|int, mixed>
- $table : string
- $where : string
- __construct() : mixed
- Select constructor.
- bindParams() : mixed
- execute() : array<string|int, mixed>
- leftJoin() : mixed
- limit() : mixed
- oneRow() : mixed
- where() : static
- getStatement() : string
- processSelectColumns() : string
Properties
$leftJoin
private
array<string|int, mixed>
$leftJoin
= array()
$limit
private
int
$limit
$params
private
array<string|int, mixed>
$params
= array()
$selectColumns
private
string|array<string|int, mixed>
$selectColumns
$table
private
string
$table
$where
private
string
$where
= ''
Methods
__construct()
Select constructor.
public
__construct(string|array<string|int, mixed> $selectColumns, string $table) : mixed
Parameters
- $selectColumns : string|array<string|int, mixed>
- $table : string
Return values
mixed —bindParams()
public
bindParams(string|int|array<string|int, mixed> ...$params) : mixed
Parameters
- $params : string|int|array<string|int, mixed>
Return values
mixed —execute()
public
execute([int $fetch_style = PDO::FETCH_ASSOC ]) : array<string|int, mixed>
Parameters
- $fetch_style : int = PDO::FETCH_ASSOC
Return values
array<string|int, mixed> —leftJoin()
public
leftJoin(string $rightTable, string $rightTableColumn[, string $leftTableColumn = null ][, string $leftTable = null ]) : mixed
Parameters
- $rightTable : string
- $rightTableColumn : string
- $leftTableColumn : string = null
- $leftTable : string = null
Return values
mixed —limit()
public
limit(int $limit) : mixed
Parameters
- $limit : int
Return values
mixed —oneRow()
public
oneRow([int $fetch_style = PDO::FETCH_ASSOC ][, int $cursor_orientation = PDO::FETCH_ORI_NEXT ]) : mixed
Parameters
- $fetch_style : int = PDO::FETCH_ASSOC
- $cursor_orientation : int = PDO::FETCH_ORI_NEXT
Return values
mixed —where()
public
where(string $where[, string $relation = null ]) : static
Parameters
- $where : string
- $relation : string = null
Return values
static —getStatement()
private
getStatement() : string
Return values
string —processSelectColumns()
private
processSelectColumns(string|array<string|int, mixed> $selectColumns, int $key, int $depth) : string
Parameters
- $selectColumns : string|array<string|int, mixed>
- $key : int
- $depth : int