$datetime
$datetime : string
The format for properly saving a DateTime.
$connection : \Laravel\Database\Connection
The database connection instance for the grammar.
select(\Laravel\Database\Query $query) : string
Compile a SQL SELECT statement from a Query instance.
LaravelDatabaseQuery | $query |
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.
LaravelDatabaseQuery | $query | |
array | $values |
insert_get_id(\Laravel\Database\Query $query, array $values, string $column) : string
Compile a SQL INSERT and get ID statement from a Query instance.
LaravelDatabaseQuery | $query | |
array | $values | |
string | $column |
update(\Laravel\Database\Query $query, array $values) : string
Compile a SQL UPDATE statement from a Query instance.
LaravelDatabaseQuery | $query | |
array | $values |
delete(\Laravel\Database\Query $query) : string
Compile a SQL DELETE statement from a Query instance.
LaravelDatabaseQuery | $query |
__construct(\Laravel\Database\Connection $connection) : void
Create a new database grammar instance.
LaravelDatabaseConnection | $connection |
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')));
array | $values |
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'));
mixed | $value |
components(\Laravel\Database\Query $query) : array
Generate the SQL for every component of the query.
LaravelDatabaseQuery | $query |
selects(\Laravel\Database\Query $query) : string
Compile the SELECT clause for a query.
LaravelDatabaseQuery | $query |
aggregate(\Laravel\Database\Query $query) : string
Compile an aggregating SELECT clause for a query.
LaravelDatabaseQuery | $query |
from(\Laravel\Database\Query $query) : string
Compile the FROM clause for a query.
LaravelDatabaseQuery | $query |
joins(\Laravel\Database\Query $query) : string
Compile the JOIN clauses for a query.
LaravelDatabaseQuery | $query |
wheres(\Laravel\Database\Query $query) : string
Compile the WHERE clause for a query.
LaravelDatabaseQuery | $query |
groupings(\Laravel\Database\Query $query) : string
Compile the GROUP BY clause for a query.
LaravelDatabaseQuery | $query |
havings(\Laravel\Database\Query $query) : string
Compile the HAVING clause for a query.
LaravelDatabaseQuery | $query |
orderings(\Laravel\Database\Query $query) : string
Compile the ORDER BY clause for a query.
LaravelDatabaseQuery | $query |
limit(\Laravel\Database\Query $query) : string
Compile the LIMIT clause for a query.
LaravelDatabaseQuery | $query |
offset(\Laravel\Database\Query $query) : string
Compile the OFFSET clause for a query.
LaravelDatabaseQuery | $query |
Documentation created by phpDocumentor