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

2 votes196 views1 answer
Laravel model quard
PHP Laravel
0 vote166 views1 answer
Laravel sanctum Protecting routes
PHP Laravel
9 votes205 views5 answers
Laravel updateOrInsert
PHP Laravel
0 vote185 views1 answer
Laravel firstorcreate usage
PHP Laravel
1 vote219 views3 answers
Laravel JSON query
PHP Laravel
0 vote186 views2 answers
Laravel FileManager Display Blank pop up page
PHP Laravel
-4 votes191 views1 answer
Alert laravel 7
PHP Laravel
2 votes144 views1 answer
Laravel create txt file
PHP Laravel
0 vote203 views1 answer
Laravel access request in provider
PHP Laravel
10 votes202 views2 answers
Laravel collection toArray
PHP Laravel