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

2 votes231 views1 answer
Get name custom post type wordpress
PHP Wordpress
-1 vote213 views1 answer
Php catch mysqli_connect(): (HY000/1045): Access denied
PHP
0 vote212 views1 answer
Display data from two dimensional array in vew laravel
PHP
0 vote191 views1 answer
Php ord deprecated
PHP
1 vote247 views2 answers
Wp get meta field value
PHP Wordpress
3 votes191 views1 answer
How to include php function in onclick html
PHP
-1 vote200 views2 answers
How to Delete Multiple Records using Checkbox in Laravel
PHP Laravel
7 votes222 views3 answers
Get price woocommerce product
PHP
3 votes232 views6 answers
Remove square brackets from string php
PHP
0 vote200 views1 answer
Myr currency symbol
PHP