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

15 votes332 views3 answers
Composer
PHP
0 vote342 views1 answer
Php remove nbsp from string
PHP
0 vote384 views1 answer
Laravel migration make auto increment
PHP Laravel
0 vote338 views1 answer
Header return back php
PHP
15 votes342 views6 answers
Php $_SERVER
PHP
1 vote417 views1 answer
Laravel cashier overwrite users table name
PHP Laravel
0 vote374 views1 answer
Functions file erased wordpress
PHP
0 vote366 views1 answer
Php foreach alternative syntax
PHP
0 vote409 views1 answer
Bootswatch import theme into laravell vuejs
PHP Laravel
0 vote318 views1 answer
Php header utf8 json
PHP