Answers for "laravel raw query builder"

PHP
1

raw queries in laravel

DB::statement('UPDATE users SET role_id = 1 WHERE role_id IS NULL AND YEAR(created_at) > 2020');
Posted by: Guest on August-11-2020
0

Laravel query builder toSql

$query = DB::table('table')->whereIn('some_field', [1,2,30]);

$sql = $query->toSql();

$bindings = $query->getBindings();
Posted by: Guest on May-16-2021

Browse Popular Code Answers by Language