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 vote179 views1 answer
Laravel validation in controller
PHP
0 vote225 views1 answer
Laravel convert querybuilder to string
PHP
9 votes179 views3 answers
Uninstall phpmyadmin
PHP
1 vote214 views3 answers
Laravel convert timestamp to date
PHP
0 vote238 views1 answer
Wordpress display post categories
PHP
0 vote217 views1 answer
Wordpress how to string multple function.php files together
PHP Wordpress
3 votes172 views3 answers
Laravel if request has
PHP
0 vote176 views3 answers
Laravel pagination with search filter
PHP
0 vote196 views1 answer
Php createFromFormat day of week
PHP
0 vote171 views1 answer
Php is_assoc
PHP