xxxxxxxxxx
DB::table('users')
->where('id', $id)
->update([
'status' => 1
]);
xxxxxxxxxx
DB::table('user')->where('email', $userEmail)->update(array('member_type' => $plan));
xxxxxxxxxx
$affected = DB::table('users')
->where('id', 1)
->update(['votes' => 1]);
xxxxxxxxxx
// Newer version of PHP
$user = User::updateOrCreate(
['email' => request('email')],
['name' => request('name')]
);
// Older version of PHP
$user = User::where('email', request('email'))->first();
if ($user !== null) {
$user->update(['name' => request('name')]);
} else {
$user = User::create([
'email' => request('email'),
'name' => request('name'),
]);
}
xxxxxxxxxx
$update = \DB::table('student') ->where('id', $data['id']) ->limit(1) ->update( [ 'name' => $data['name'], 'address' => $data['address'], 'email' => $data['email'], 'contactno' => $data['contactno'] ]);
xxxxxxxxxx
use App\Models\User;
$User_Update = User::where("id", '2')->update(["member_type" => $plan]);