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

2 votes227 views2 answers
Laravel simplexmlelement xml add attribute
PHP Laravel
7 votes235 views3 answers
Laravel - Query Builder Left join
PHP Laravel
2 votes226 views3 answers
Laravel model particular column
PHP Laravel
10 votes219 views4 answers
Import session laravel
PHP Laravel
0 vote224 views2 answers
Laravel dirty words check
PHP Laravel
5 votes239 views2 answers
Db::statement in laravel
PHP Laravel
0 vote222 views1 answer
Laravel check if postback
PHP Laravel
1 vote228 views1 answer
Laravel date diff
PHP Laravel
7 votes252 views3 answers
Laravel migration seed fresh
PHP Laravel
8 votes232 views2 answers
Laravel storage hard link
PHP Laravel