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 vote262 views1 answer
Laravel routes return view in web.php
PHP
7 votes250 views3 answers
Php file put content
PHP
3 votes239 views1 answer
Auth::loginUsingId
PHP
0 vote309 views1 answer
Server error in laravel
PHP Laravel
9 votes292 views6 answers
Get raw query laravel
PHP
0 vote265 views2 answers
Laravel db insert get last id
PHP Laravel
0 vote259 views1 answer
Php sort array by value length
PHP
0 vote250 views1 answer
Deserialize php
PHP
0 vote317 views1 answer
Cakephp 3
PHP CakePHP
0 vote337 views1 answer
Amazon linux 2 php.ini changes not working
PHP