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

1 vote212 views1 answer
Create resources laravel
PHP Laravel
0 vote236 views1 answer
Delete folder laravel
PHP Laravel
0 vote230 views1 answer
Laravel Upsert always inserting
PHP Laravel
1 vote267 views1 answer
--prefer-dist what is use in laravel
PHP Laravel
13 votes242 views5 answers
Laravel add item to array
PHP Laravel
2 votes229 views1 answer
Laravel clear everything
PHP Laravel
2 votes250 views3 answers
How get file size in laravel
PHP Laravel
0 vote252 views1 answer
Filter from taggable laravel
PHP Laravel
42 votes242 views6 answers
Laravel cache remember
PHP Laravel
0 vote228 views1 answer
Pass variable in laravel ancher tag laravel 8
PHP Laravel