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 vote131 views1 answer
How to check history of database in phpmyadmin
PHP
0 vote144 views1 answer
Uft8 json php
PHP
134 votes303 views6 answers
Php find if string contains
PHP
0 vote124 views1 answer
Editing items in collection in laravel 8
PHP
0 vote203 views1 answer
String length laravel validation
PHP Laravel
13 votes109 views2 answers
If condition in php
PHP
3 votes121 views5 answers
Xampp
PHP
0 vote113 views2 answers
Set_magic_quotes_runtime php 7
PHP
12 votes115 views6 answers
Array to string php
PHP
0 vote116 views1 answer
Laravel pivot select fields
PHP