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 vote348 views1 answer
Laravel new project command doesn't create vendor
PHP Laravel
0 vote344 views2 answers
Concat in where clause laravel query builder
PHP Laravel
1 vote371 views1 answer
Laravel ErrorException Undefined variable: _SESSION
PHP Laravel
1 vote383 views1 answer
Laravel hasone users relations
PHP Laravel
0 vote336 views1 answer
Update function laravel 7
PHP Laravel
2 votes407 views1 answer
Add to url anchor tag laravel with variable
PHP Laravel
0 vote398 views1 answer
Laravel nova field required
PHP Laravel
5 votes359 views2 answers
Created_at default value laravel
PHP Laravel
0 vote301 views1 answer
Refresh laravel model
PHP Laravel
2 votes357 views1 answer
Laravel get only relationship
PHP Laravel