/PHP/Laravel get query in normal sql without bindings

Laravel get query in normal sql without bindings

/**
 * Combines SQL and its bindings
 *
 * @param \Eloquent $query
 * @return string
 */
public static function getEloquentSqlWithBindings($query)
{
    return vsprintf(str_replace('?', '%s', $query->toSql()), collect($query->getBindings())->map(function ($binding) {
        $binding = addslashes($binding);
        return is_numeric($binding) ? $binding : "'{$binding}'";
    })->toArray());
}

Source: stackoverflow.com

Similar codes

0 vote173 views1 answer
Acf php fields
PHP
1 vote156 views1 answer
Laravel using username instead of email
PHP
0 vote160 views6 answers
Sanctum laravel
PHP
0 vote196 views1 answer
Laravel Password & Password_Confirmation Validation
PHP Laravel
9 votes206 views2 answers
Use resource in laravel 8
PHP Laravel
0 vote159 views3 answers
Laravel migration softdelete
PHP
-1 vote167 views1 answer
Carbon check sunday
PHP
-2 votes171 views3 answers
Upgrade php 7.3 centos 7
PHP
0 vote144 views2 answers
Https://github.com/nuxt/nuxt.js/issues/8315#:~:text=%3Chtml%20lang%3D%22ru%22%20data%2Dn%2Dhead%3D%22%257B%2522lang%2522%3A%257B%2522ssr%2522%3A%2522ru%2522%257D%257D%22%3E
PHP
0 vote182 views1 answer
Wp plugins action link
PHP