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 vote276 views1 answer
Php include once inside a function?
PHP
0 vote259 views1 answer
Mysql between all months days even null
PHP
0 vote260 views1 answer
Doctrine querybuilder print sql
PHP
6 votes262 views2 answers
Custom autoload without composer
PHP
8 votes327 views1 answer
Add sucssess message laravel
PHP Laravel
0 vote294 views1 answer
Ubuntu 18.04 php is not working
PHP
6 votes283 views1 answer
Php convert print_r to array
PHP
0 vote283 views1 answer
Wc php get order get coupon discount amount
PHP
0 vote279 views1 answer
Convert query result to array php
PHP
0 vote257 views1 answer
Get value mentthod get laravel
PHP