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 vote279 views1 answer
Laravel composer anctum
PHP Laravel
8 votes256 views6 answers
Laravel collection sum
PHP Laravel
0 vote334 views1 answer
Laravel assign class dynamically if condition true
PHP Laravel
0 vote291 views1 answer
Laravel project htaccess redirect to public path
PHP Laravel
0 vote294 views1 answer
Laravel jwt check token sent by request is valid
PHP Laravel
0 vote288 views1 answer
Laravel Migration Error: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
PHP Laravel
18 votes283 views6 answers
Install laravel auth
PHP Laravel
31 votes272 views2 answers
Laravel sample controller
PHP Laravel
1 vote356 views3 answers
Laravel convert timestamp to date
PHP Laravel
0 vote308 views1 answer
Add like and equal in same query in laravel
PHP Laravel