Laravel print builder

// query builder
$query = DB::table('table_name')->where('id', 1);
// binding replaced
$rawQuery = str_replace_array('?', $query->getBindings(), $query->toSql());
// for laravel 5.8^
$rawQuery = Str::replaceArray('?', $query->getBindings(), $query->toSql());
 
dd($rawSql); // "select * from `table_name` where `id` = 1";

Source: stackoverflow.com

Similar codes

12 votes358 views5 answers
Laravel run single migration
PHP Laravel
1 vote388 views1 answer
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'laravel_api.sessions' doesn't exist (SQL: select * from `sessions` where `id` = sXWuwluhxC2HlCzzq7jDyPGJFriLGdxQj8bPtcgC limit 1)
PHP Laravel
0 vote398 views1 answer
Passing parameters with route keyword in blade laravel
PHP Laravel
1 vote462 views1 answer
Autoload file in laravel
PHP Laravel
0 vote400 views3 answers
Embed the site when you click on the link laravel
PHP Laravel
1 vote329 views1 answer
How make exception laravel if operation does not work
PHP Laravel
1 vote356 views3 answers
Create new laravel project with specific version
PHP Laravel
2 votes386 views1 answer
Laravel schema default string length
PHP Laravel
0 vote397 views1 answer
User order by role spatie laravel
PHP Laravel
6 votes373 views3 answers
Previous url laravel
PHP Laravel