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 vote129 views1 answer
Woocommerce-cart-count
PHP
0 vote150 views1 answer
Laravel hasMany with join
PHP Laravel
5 votes132 views4 answers
Hide a div
PHP
0 vote149 views1 answer
Download data from s3 and save to local disk laravel
PHP Laravel
3 votes129 views6 answers
Laravel cors
PHP
0 vote122 views2 answers
Column not found: 1054 Unknown column 'api_token' in 'where clause
PHP
13 votes124 views3 answers
Linux set default php
PHP
79 votes134 views2 answers
Str_contains
PHP
1 vote86 views10 answers
Loop object by value php
PHP
0 vote137 views1 answer
Php mail merge docx document
PHP