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

1 vote157 views1 answer
Laravel 8 plural singular
PHP Laravel
0 vote158 views1 answer
Laravel vendor/laravel/framework/src/Illuminate/View/Compilers/Compiler.php:36
PHP Laravel
1 vote166 views1 answer
Get value by today yesterday in laravel
PHP Laravel
0 vote150 views1 answer
Editing items in collection in laravel
PHP Laravel
0 vote149 views1 answer
Configuration laravel dompdf
PHP Laravel
0 vote151 views2 answers
Laravel collection intersect
PHP Laravel
42 votes215 views6 answers
Laravel cache remember
PHP Laravel
6 votes168 views4 answers
Insert data using seeder in laravel
PHP Laravel
0 vote160 views1 answer
Error: Class '\App\Models\User' not found in file D:\teraNinga\mazadat\vendor\laravel\framework\src\Illuminate\Auth\EloquentUserProvider.php on line 183
PHP Laravel
8 votes124 views1 answer
Laravel get variable from url
PHP Laravel