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 vote304 views1 answer
Redirect all request to public folder laravel htaccess
PHP Laravel
1 vote273 views6 answers
Laravel get url parameters in controller
PHP Laravel
12 votes247 views6 answers
Laravel where and where
PHP Laravel
1 vote269 views1 answer
How can get url from $request in laravel
PHP Laravel
1 vote243 views1 answer
Laravel create on model
PHP Laravel
10 votes242 views6 answers
Laravel Pagination
PHP Laravel
3 votes281 views1 answer
Laravel eloquent get column
PHP Laravel
0 vote244 views1 answer
Laravel query with optional filter
PHP Laravel
5 votes290 views2 answers
Laravel naming conventions
PHP Laravel
0 vote300 views1 answer
How get last item in foreach in laravel
PHP Laravel