In case if we want to insert rows in bulk then we have a method available in CodeIgniter 4 which we call via Model object.
# Load model use App\Models\StudentModel; # Creating model instance $object = new StudentModel(); # Insert Rows $object->insertBatch([ [], [], [], ... ]);
StudentModel.php
x
<?php
namespace App\Controllers;
use App\Controllers\BaseController;
use App\Models\StudentModel;
class StudentController extends BaseController
{
public function insertData()
{
$object = new StudentModel();
// Insert rows in bulk
$object->insertBatch([
[
"name" => "Sanjay Kumar",
"email" => "test@gmail.com",
"mobile" => "9879638521"
],
[
"name" => "Ashish Kumar",
"email" => "ashish@gmail.com",
"mobile" => "6541231333"
]
]);
//...
}
}
Above code will insert rows in bulk inside associated table for StudentModel.
Read more