Illuminate\Database\Query\Builder::toSql PHP Method

toSql() public method

Get the SQL representation of the query.
public toSql ( ) : string
return string
    public function toSql()
    {
        return $this->grammar->compileSelect($this);
    }

Usage Example

Exemplo n.º 1
11
 /**
  * Is used for quick selecting of big number of records from database without creating ORM objects
  * @param \Illuminate\Database\Query\Builder $query - Query Builder object
  * @return array $results - results of query
  */
 private static function getArrayFromQuery($query)
 {
     $sql = $query->toSql();
     foreach ($query->getBindings() as $binding) {
         $value = is_numeric($binding) ? $binding : "'" . $binding . "'";
         $sql = preg_replace('/\\?/', $value, $sql, 1);
     }
     $results = \DB::select($sql);
     return $results;
 }
All Usage Examples Of Illuminate\Database\Query\Builder::toSql