select()

select(\Laravel\Database\Query  $query) : string

Compile a SQL SELECT statement from a Query instance.

Parameters

Returns

insert()

insert(\Laravel\Database\Query  $query, array  $values) : string

Compile a SQL INSERT statement from a Query instance.

This method handles the compilation of single row inserts and batch inserts.

Parameters

Returns

insert_get_id()

insert_get_id(\Laravel\Database\Query  $query, array  $values, string  $column) : string

Compile a SQL INSERT and get ID statement from a Query instance.

Parameters

Returns

update()

update(\Laravel\Database\Query  $query, array  $values) : string

Compile a SQL UPDATE statement from a Query instance.

Parameters

Returns

delete()

delete(\Laravel\Database\Query  $query) : string

Compile a SQL DELETE statement from a Query instance.

Parameters

Returns

shortcut()

shortcut(string  $sql, array  $bindings) : string

Transform an SQL short-cuts into real SQL for PDO.

Parameters

Returns

__construct()

__construct(\Laravel\Database\Connection  $connection) : void

Create a new database grammar instance.

Parameters

wrap_table()

wrap_table(string  $table) : string

Wrap a table in keyword identifiers.

Parameters

Returns

wrap()

wrap(string  $value) : string

Wrap a value in keyword identifiers.

Parameters

Returns

parameterize()

parameterize(array  $values) : string

Create query parameters from an array of values.

Returns "?, ?, ?", which may be used as PDO place-holders $parameters = $grammar->parameterize(array(1, 2, 3));

// Returns "?, "Taylor"" since an expression is used
$parameters = $grammar->parameterize(array(1, DB::raw('Taylor')));

Parameters

Returns

parameter()

parameter(mixed  $value) : string

Get the appropriate query parameter string for a value.

// Returns a "?" PDO place-holder $value = $grammar->parameter('Taylor Otwell');

// Returns "Taylor Otwell" as the raw value of the expression
$value = $grammar->parameter(DB::raw('Taylor Otwell'));

Parameters

Returns

columnize()

columnize(array  $columns) : string

Create a comma-delimited list of wrapped column names.

// Returns ""Taylor", "Otwell"" when the identifier is quotes $columns = $grammar->columnize(array('Taylor', 'Otwell'));

Parameters

Returns

components()

components(\Laravel\Database\Query  $query) : array

Generate the SQL for every component of the query.

Parameters

Returns

concatenate()

concatenate(array  $components) : string

Concatenate an array of SQL segments, removing those that are empty.

Parameters

Returns

selects()

selects(\Laravel\Database\Query  $query) : string

Compile the SELECT clause for a query.

Parameters

Returns

aggregate()

aggregate(\Laravel\Database\Query  $query) : string

Compile an aggregating SELECT clause for a query.

Parameters

Returns

from()

from(\Laravel\Database\Query  $query) : string

Compile the FROM clause for a query.

Parameters

Returns

joins()

joins(\Laravel\Database\Query  $query) : string

Compile the JOIN clauses for a query.

Parameters

Returns

wheres()

wheres(\Laravel\Database\Query  $query) : string

Compile the WHERE clause for a query.

Parameters

Returns

where_nested()

where_nested(array  $where) : string

Compile a nested WHERE clause.

Parameters

Returns

where()

where(array  $where) : string

Compile a simple WHERE clause.

Parameters

Returns

where_in()

where_in(array  $where) : string

Compile a WHERE IN clause.

Parameters

Returns

where_not_in()

where_not_in(array  $where) : string

Compile a WHERE NOT IN clause.

Parameters

Returns

where_between()

where_between(array  $where) : string

Compile a WHERE BETWEEN clause

Parameters

Returns

where_not_between()

where_not_between(array  $where) : string

Compile a WHERE NOT BETWEEN clause

Parameters

Returns

where_null()

where_null(array  $where) : string

Compile a WHERE NULL clause.

Parameters

Returns

where_not_null()

where_not_null(array  $where) : string

Compile a WHERE NULL clause.

Parameters

Returns

where_raw()

where_raw(array  $where) : string

Compile a raw WHERE clause.

Parameters

Returns

groupings()

groupings(\Laravel\Database\Query  $query) : string

Compile the GROUP BY clause for a query.

Parameters

Returns

havings()

havings(\Laravel\Database\Query  $query) : string

Compile the HAVING clause for a query.

Parameters

Returns

orderings()

orderings(\Laravel\Database\Query  $query) : string

Compile the ORDER BY clause for a query.

Parameters

Returns

limit()

limit(\Laravel\Database\Query  $query) : string

Compile the LIMIT clause for a query.

Parameters

Returns

offset()

offset(\Laravel\Database\Query  $query) : string

Compile the OFFSET clause for a query.

Parameters

Returns

wrap_value()

wrap_value(string  $value) : string

Wrap a single string value in keyword identifiers.

Parameters

Returns