xxxxxxxxxx
$sql = Str::replaceArray('?', $query->getBindings(), $query->toSql());
xxxxxxxxxx
$query = DB::table('table')->whereIn('some_field', [1,2,30]);
$sql = $query->toSql();
$bindings = $query->getBindings();
xxxxxxxxxx
/**
* 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());
}
xxxxxxxxxx
$query = str_replace(array('?'), array('\'%s\''), $results->toSql());
$query = vsprintf($query, $results->getBindings());
dump($query);
$result = $results->get();
xxxxxxxxxx
$query = $sql->toSql();
$array = $sql->getBindings();
foreach ($array as $value) {
$query = preg_replace('/\?/', "'$value'", $query, 1);
}
echo $query;
die();
xxxxxxxxxx
$query = DB::table('table')->whereIn('some_field', [1,2,30]);
$sql = $query->toSql();
$bindings = $query->getBindings();
xxxxxxxxxx
public static function getQueries(Builder $builder)
{
$addSlashes = str_replace('?', "'?'", $builder->toSql());
return vsprintf(str_replace('?', '%s', $addSlashes), $builder->getBindings());
}
xxxxxxxxxx
\App\User::where('age', '18')->dump();
\App\User::where('age', '18')->dd();