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

0 vote195 views2 answers
Laravel: customize or extend notifications - database model
PHP Laravel
1 vote202 views1 answer
Laravel long description text string
PHP Laravel
6 votes192 views3 answers
Previous url laravel
PHP Laravel
0 vote189 views1 answer
How can we check in the table in comma separated values in laravel
PHP Laravel
0 vote222 views1 answer
Laravel - Add conditional where clause in query
PHP Laravel
0 vote186 views1 answer
Laravel carbon first day of month
PHP Laravel
6 votes207 views4 answers
Laravel previous url
PHP Laravel
0 vote201 views1 answer
2 days left format in laravel
PHP Laravel
0 vote186 views1 answer
Laravel 8 date difference in days
PHP Laravel
15 votes187 views4 answers
Change existing migration laravel
PHP Laravel