Insert & insertBatch function in codeigniter 4

Deepak Tailor Image
Deepak Tailor - Nov 17 2020
Insert & insertBatch function in codeigniter  4

To insert data, Codeigniter has provided insert function for single row insert and insertBatch function for multiple data insert. In this function, we can pass data in array format or in object format.

Data pass in array format
public function insert_record()
{
	$user_data = array(
		'name'	=>	'lokesh meena',
		'age'	=>	20,
		'salary'=>	5000
	);
	$query = $this->seller->table('users')
				  ->insert($user_data);
	if($query == true){
		echo "data insert";
	}
	else{
		echo "data fail";
	}
}

When inserting duplicate data, we get an error from the database. If we pass true in the ignore function, then we can stop the error on duplicate entry.

public function insert_record()
{
	$user_data = array(
		'id'	=>	36,
		'name'	=>	'lokesh meena',
		'age'	=>	20,
		'salary'=>	5000
	);
	$query = $this->seller->table('users')
				->ignore(true)
				->insert($user_data);
	if($query == true){
		echo "data insert";
	}
	else{
		echo "data fail";
	}
}
Data insert with insertBatch

With insertBatch, we can insert multiple records at once. In this, the data passes multiple records into the array.

public function insert_record()
{
	$user_data = array(
		array(
			'name'	=>	'lokesh meena',
			'age'	=>	20,
			'salary'=>	5000
		),
		array(
			'name'	=>	'priti tailor',
			'age'	=>	21,
			'salary'=>	5500
		)
	);
	
	$query = $this->seller->table('users')
				  ->insertBatch($user_data);
	if($query == true){
		echo "data insert";
	}
	else{
		echo "data fail";
	}
}
Deepak Tailor Image
Deepak Tailor

My name is Deepak tailor as a fullstack developer. I have been in the IT industry for the last 5 years. For professional and customize web development, you can send inquiry on our email.
----
You can contact him at support@fulstackdev.com