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

13 votes130 views6 answers
Named route with parameter laravel
PHP Laravel
24 votes141 views6 answers
Laravel create model
PHP Laravel
0 vote130 views1 answer
Laravel migration add date of birth column
PHP Laravel
0 vote125 views1 answer
Laravel search user details by specific role
PHP Laravel
0 vote139 views1 answer
Create or update laravel 5.8 stackoverflow
PHP Laravel
2 votes140 views3 answers
Laravel model particular column
PHP Laravel
2 votes159 views1 answer
Laravel middleware
PHP Laravel
5 votes145 views2 answers
Laravel group by with where clause
PHP Laravel
0 vote144 views1 answer
Laravel env asset_url
PHP Laravel
15 votes155 views3 answers
Get id user login laravel
PHP Laravel