Laravel get result toSql in QueryBuilder

Question

I'm using select method of laravel QB and I want to get MYSql command of that's created.

Laravel QB:

public function scopeiOS( $query ){
    $result = $query->select( DB::raw('count(`platform`) as iOS' ) )     ->where( 'platform' , '=', 'iOS' )      ->pluck('iOS');
}

toSql() is not member of that function.

that actually is your problem because toSql() is a method attributed to QueryBuilder object only.... none the less, with this rude attitude, good luck getting an answer from others too. — itachi
– itachi, Commented Apr 7, 2014 at 9:27

Efle Barsie · Accepted Answer · 2016-04-27 11:13:44Z

2

I don't know about toSql() but if you want to get the query created then you might want to look at the logs of the queries executed for that request.

$queries = DB::getQueryLog();
dd($queries);

Or get the last query executed:

$queries = DB::getQueryLog();
$last_query = end($queries);

Or maybe (warning untested code)

public function scopeiOS( Illuminate\Database\Query\Builder $query ){
    $result = $query->select( DB::raw('count(`platform`) as iOS' ) )
                    ->where( 'platform' , '=', 'iOS' )
                    ->pluck('iOS');
}

Check this for more information on toSql().

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

edited Apr 27, 2016 at 11:13

Efle Barsie

52 bronze badges

answered Apr 7, 2014 at 9:46

majidarif

20.4k18 gold badges97 silver badges137 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel get result toSql in QueryBuilder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related