Overview

Namespaces

  • Laravel
    • Auth
      • Drivers
    • Cache
      • Drivers
    • CLI
      • Tasks
        • Bundle
          • Providers
        • Migrate
        • Session
        • Test
    • Database
      • Connectors
      • Eloquent
        • Relationships
      • Query
        • Grammars
      • Schema
        • Grammars
    • Profiling
    • Routing
    • Session
      • Drivers
  • None
  • PHP
  • Symfony
    • Component
      • Console
        • Command
        • Formatter
        • Helper
        • Input
        • Output
        • Tester
      • HttpFoundation
        • File
          • Exception
          • MimeType
        • Session
          • Attribute
          • Flash
          • Storage
            • Handler
            • Proxy

Classes

  • Grammar
  • MySQL
  • Postgres
  • SQLite
  • SQLServer
  • Overview
  • Namespace
  • Class
  • Tree
  • Deprecated

Class Grammar

Laravel\Database\Grammar
Extended by Laravel\Database\Query\Grammars\Grammar

Direct known subclasses

Laravel\Database\Query\Grammars\MySQL, Laravel\Database\Query\Grammars\Postgres, Laravel\Database\Query\Grammars\SQLite, Laravel\Database\Query\Grammars\SQLServer
Namespace: Laravel\Database\Query\Grammars
Located at laravel/database/query/grammars/grammar.php
Methods summary
public string
# select( Laravel\Database\Query $query )

Compile a SQL SELECT statement from a Query instance.

Compile a SQL SELECT statement from a Query instance.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
final protected array
# components( Laravel\Database\Query $query )

Generate the SQL for every component of the query.

Generate the SQL for every component of the query.

Parameters

$query
Laravel\Database\Query
$query

Returns

array
final protected string
# concatenate( array $components )

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

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

Parameters

$components
array
$components

Returns

string
protected string
# selects( Laravel\Database\Query $query )

Compile the SELECT clause for a query.

Compile the SELECT clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# aggregate( Laravel\Database\Query $query )

Compile an aggregating SELECT clause for a query.

Compile an aggregating SELECT clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# from( Laravel\Database\Query $query )

Compile the FROM clause for a query.

Compile the FROM clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# joins( Laravel\Database\Query $query )

Compile the JOIN clauses for a query.

Compile the JOIN clauses for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
final protected string
# wheres( Laravel\Database\Query $query )

Compile the WHERE clause for a query.

Compile the WHERE clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# where_nested( array $where )

Compile a nested WHERE clause.

Compile a nested WHERE clause.

Parameters

$where
array
$where

Returns

string
protected string
# where( array $where )

Compile a simple WHERE clause.

Compile a simple WHERE clause.

Parameters

$where
array
$where

Returns

string
protected string
# where_in( array $where )

Compile a WHERE IN clause.

Compile a WHERE IN clause.

Parameters

$where
array
$where

Returns

string
protected string
# where_not_in( array $where )

Compile a WHERE NOT IN clause.

Compile a WHERE NOT IN clause.

Parameters

$where
array
$where

Returns

string
protected string
# where_between( array $where )

Compile a WHERE BETWEEN clause

Compile a WHERE BETWEEN clause

Parameters

$where
array
$where

Returns

string
protected string
# where_not_between( array $where )

Compile a WHERE NOT BETWEEN clause

Compile a WHERE NOT BETWEEN clause

Parameters

$where
array
$where

Returns

string
protected string
# where_null( array $where )

Compile a WHERE NULL clause.

Compile a WHERE NULL clause.

Parameters

$where
array
$where

Returns

string
protected string
# where_not_null( array $where )

Compile a WHERE NULL clause.

Compile a WHERE NULL clause.

Parameters

$where
array
$where

Returns

string
final protected string
# where_raw( array $where )

Compile a raw WHERE clause.

Compile a raw WHERE clause.

Parameters

$where
array
$where

Returns

string
protected string
# groupings( Laravel\Database\Query $query )

Compile the GROUP BY clause for a query.

Compile the GROUP BY clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# havings( Laravel\Database\Query $query )

Compile the HAVING clause for a query.

Compile the HAVING clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# orderings( Laravel\Database\Query $query )

Compile the ORDER BY clause for a query.

Compile the ORDER BY clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# limit( Laravel\Database\Query $query )

Compile the LIMIT clause for a query.

Compile the LIMIT clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
protected string
# offset( Laravel\Database\Query $query )

Compile the OFFSET clause for a query.

Compile the OFFSET clause for a query.

Parameters

$query
Laravel\Database\Query
$query

Returns

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

Compile a SQL INSERT statement from a Query instance.

Compile a SQL INSERT statement from a Query instance.

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

Parameters

$query
Laravel\Database\Query
$query
$values
array
$values

Returns

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

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

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

Parameters

$query
Laravel\Database\Query
$query
$values
array
$values
$column
string
$column

Returns

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

Compile a SQL UPDATE statement from a Query instance.

Compile a SQL UPDATE statement from a Query instance.

Parameters

$query
Laravel\Database\Query
$query
$values
array
$values

Returns

string
public string
# delete( Laravel\Database\Query $query )

Compile a SQL DELETE statement from a Query instance.

Compile a SQL DELETE statement from a Query instance.

Parameters

$query
Laravel\Database\Query
$query

Returns

string
public string
# shortcut( string $sql, array & $bindings )

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

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

Parameters

$sql
string
$sql
$bindings
array
$bindings

Returns

string
Methods inherited from Laravel\Database\Grammar
__construct(), columnize(), parameter(), parameterize(), wrap(), wrap_table(), wrap_value()
Properties summary
public string $datetime 'Y-m-d H:i:s'
#

The format for properly saving a DateTime.

The format for properly saving a DateTime.
protected array $components array( 'aggregate', 'selects', 'from', 'joins', 'wheres', 'groupings', 'havings', 'orderings', 'limit', 'offset', )
#

All of the query components in the order they should be built.

All of the query components in the order they should be built.
Properties inherited from Laravel\Database\Grammar
$connection, $wrapper
Laravel 3.x API Documentation API documentation generated by ApiGen 2.8.0