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

46 votes181 views6 answers
Laravel make controller with model
PHP Laravel
0 vote157 views1 answer
2 days left format in laravel
PHP Laravel
0 vote243 views1 answer
Show sender name laravel
PHP Laravel
6 votes134 views4 answers
Enset laravel session
PHP Laravel
0 vote182 views1 answer
Laravel simple
PHP Laravel
12 votes153 views2 answers
Laravel query with trashed
PHP Laravel
0 vote141 views1 answer
Laravel check if primary key exists
PHP Laravel
0 vote154 views1 answer
Laravel - Query Builder Raw Query selectRaw
PHP Laravel
1 vote152 views3 answers
Laravel JSON query
PHP Laravel
0 vote140 views1 answer
Laravel search user details by specific role
PHP Laravel