Loading..

how to use condition if using DB::table 0 0

Last updated on Apr 11, 2022 12:57 AM in Script/CMS » Laravel
Posted ByWehostClub
use App\Notification;


  if(DB::table('notifications')->where('user_id',$request->user_id)->where('notification_status', '=', 'ACTIVE' )){
 DB::table('notifications')->update(['user_name' => $request->user_name,]);//if notification_status ACTIVE IT GET UPDATE
    }else{
 DB::table('notifications')->insert(['user_name' => $request->user_name,]);//if notification_status DELETED CREATE NEW RECORD
    }


use updateOrInsert so you can avoid if condition

 DB::table('notifications')->updateOrInsert(['user_id'=>$request->user_id,'notification_status'=> 'ACTIVE'],['user_name' => $request->user_name])



** The time is base on America/New_York timezone