How to insert multiple rows from a single query using eloquent/fluentLearning Curve- Perfect Tutorial for the beginers | Learning Curve- Perfect Tutorial for the beginers

Bulk Insertion in Laravel using eloquent ORM

Inserting 100 records into a table inside a loop.I have database table called emp_table with 100 employees records if you want to insert this records into a new table called salary_table in this cas see how the batch insert works in laravel

$new_insert_array=array();

foreach($emp_details as $key=>$val)
{
$new_insert_array[]=array('emp_id'=>$emp_details['emp_id'],'emp_name'=>$emp_details['emp_name'],'basic_
sal'=>$emp_details['basic_sal']);
//no need to use insert statement here because this will execute 100 times so keep the code outside the 
loop
}
Salary::insert($new_insert_array);
?>

$new_insert_array=array();

foreach($emp_details as $key=>$val)

{

$new_insert_array[]=array('emp_id'=>$emp_details['emp_id'],'emp_name'=>$emp_details['emp_name'],'basic_

sal'=>$emp_details['basic_sal']);

//no need to use insert statement here because this will execute 100 times so keep the code outside the

loop

}

Salary::insert($new_insert_array);