How to Check Value if Exists in laravel array?

I need to check if the value in the Table is existed skip it otherwise save it in the table below is the code.

 else if(!empty($checkActivity)) 
    {
        //dd($checkActivity);

            foreach($activitydetails->acb as $ac){
        
                $acd=new ActivityFinance();
                 $acd->project_id=$project_id;
                 $acd->account_code=$ac->account_code;
                 $acd->activity_budget=$ac->activity_budget;
                 $acd->exact_title=$ac->exact_title;
                 $acd->created_by=Auth::user()->id;
                 $acd->save();
                }
    
            }

if we dd($activity->acb); How to Check Value if Exists in laravel array?

and if we dd the $checkActivity it shows the following data How to Check Value if Exists in laravel array?
in simple words, there is two arrays, one came from the database and the other from View how to check if the view sent array is in Database?
Thanks

Answers:

Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.

Method 1

i have use the laravel function updateOrCreate() it will check if the entry exist it will ignore or create new , if already in database table then it will update not ID below are the codes

ProjectFinance::updateOrCreate([
         'project_id'=>$project_id,
        ],[
      'finance_budget'=>$finance->finance_budget,
      'finance_currency'=>$finance->finance_currency,
       'created_by'=>Auth::user()->id
     ]);
    $upsertActvity=$activitydetails->acb;
 
              foreach($upsertActvity as $up)
                  {

                  ActivityFinance::updateOrCreate([
                     'id'=>$up->id,
                     'project_id'=>$project_id,
                    ],[
                     'account_code'=>$up->account_code,
                     'activity_budget'=>$up->activity_budget,
                     'exact_title'=>$up->exact_title,
                     'created_by'=>Auth::user()->id
                     ]);


All methods was sourced from stackoverflow.com or stackexchange.com, is licensed under cc by-sa 2.5, cc by-sa 3.0 and cc by-sa 4.0

0 0 votes
Article Rating
Subscribe
Notify of
guest

0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x