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

3 votes291 views3 answers
Sum row data and get all data eloquent laravel
PHP Laravel
7 votes257 views4 answers
Many to many relationship laravel
PHP
6 votes244 views1 answer
Laravel check collection not empty
PHP
0 vote259 views3 answers
Lookup token information in vault
PHP
20 votes272 views6 answers
Laravel 8 make:auth
PHP
0 vote252 views1 answer
How to show image in easyadmin 3 index page
PHP
0 vote242 views1 answer
How do i implement blockchain payments on laravel website
PHP
0 vote255 views1 answer
Laravel phpdoc collection of model
PHP
0 vote307 views1 answer
Laravel access request in provider
PHP Laravel
12 votes377 views5 answers
Shortcode php wordpress
PHP Wordpress