Mass update in laravel using foreach

Course Queries Syllabus Queries 3 years ago

3.31K 1 0 0 0

User submissions are the sole responsibility of contributors, with TuteeHUB disclaiming liability for accuracy, copyrights, or consequences of use; content is for informational purposes only and not professional advice.

Answers (1)

Post Answer
profilepic.png
manpreet Tuteehub forum best answer Best Answer 3 years ago

 

How to Update mass records without deleting or replacing old one inserted records. Here mine problem is that last inserted record will replace with latest records.

/*DB::table('syllabuses')
             ->where('course_id', $curse_id)
             ->Where('semster',$semesterid)
             ->delete();*/
               $Syllabus =   Syllabus::find($id);
                foreach ($data as $value) 
                {  
                    //$Syllabus =  new Syllabus;//
                     $Syllabus->slno = $value->SlNo;
                      $Syllabus->coursecode =$value->cousrecode;
                     $Syllabus->coursename =$value->coursename;
                     $Syllabus->credit =$value->credit;
                     $Syllabus->papertype=$value->papertype;
                     $Syllabus->deptoffering_name=$value->Deptoffer;
                     $Syllabus->deptoffering_id=$value->Department;
                     $Syllabus->dept_id = $details['depart'];
                     $Syllabus->save();

                }
0 views
0 shares

No matter what stage you're at in your education or career, TuteeHUB will help you reach the next level that you're aiming for. Simply,Choose a subject/topic and get started in self-paced practice sessions to improve your knowledge and scores.

Similar Forum