Articles → PHP CODEIGNITER → Insert Method In The Active Records In Codeigniter

Insert Method In The Active Records In Codeigniter

In this article, we will discuss the insert method in the active records in codeigniter.

Table

For this example, let us use the following table. The name of the table is "Agent".

Click to Enlarge

User Interface

For this example, we have created this user interface.

Click to Enlarge

Code To Insert Data In The Table

In the first step, we will get the value of all the fields in an array. In the controller, we will use the following code

if(!empty($_REQUEST))
{
$agent = array(
"agent_name" => $this->input->post("agentname"),
"contact_number" => $this->input->post("contactnumber"),
"email_id"=> $this->input->post("emailid"),
"state"=> $this->input->post("state"),
"city"=> $this->input->post("city"),
"agent_address"=> $this->input->post("address"),
"pin_code"=> $this->input->post("pin")
);
$this->load->model('AgentModel');
$this->AgentModel->InsertAgent($agent);
}

It is important to note that the field order of an array should be the same as that of the database table.

In the model, write the following code.

public function InsertAgent($agent)
{
$this->load->database(); 
$this->db->insert("Agents", $agent);
}

Output

Picture showing the data inserted in the agent table

Click to Enlarge

Posted By -	Karan Gupta

Posted On -	Sunday, November 29, 2020

Query/Feedback

Your Email Id		**

Subject		*

Query/Feedback	Characters remaining 250	**