How to insert data in database - CodeIgniter framework

In this example we are going to show you how to insert data in database using CodeIgniter framework PHP.

For insert data in MySQL using CodeIgniter first we have to create a table in data base.

The INSERT INTO statement is used to insert new data to a MySQL table:

INSERT INTO table_name (column1, column2, column3,...)
VALUES (value1, value2, value3,...)

To learn more about SQL, please visit our SQL tutorial.

For creating table the SQL query is:

SQL Query

CREATE TABLE crud (
`id` int(11) NOT NULL,
`first_name` varchar(30) NOT NULL,
`last_name` varchar(30) NOT NULL,
`email` varchar(30) NOT NULL,
PRIMARY KEY (id)
);

Here we using 3 files for insert data in MySQL:

• Crud.php Path: codeIgniter\application\controllers\Crud.php
• Crud_model.php Path: codeIgniter\application\models\Crud_model.php
• insert.php Path: codeIgniter\application\views\insert.php

Crud.php (Controller)

<?php 
class Crud extends CI_Controller 
{
public function __construct()
{
//call CodeIgniter's default Constructorparent::__construct();
//load database libray manually$this->load->database();
//load Model$this->load->model('Crud_model');
}
//Insertpublic function savedata()
{
//load registration view form$this->load->view('insert');
//Check submit button if($this->input->post('save'))
{
$first_name=$this->input->post('first_name');
$last_name=$this->input->post('last_name');
$email=$this->input->post('email');
$this->Crud_model->saverecords($first_name,$last_name,$email);
echo "Records Saved Successfully";
}
}
}
?>

Crud_model.php (Model)

<?php
class Crud_model extends CI_Model 
{
//Insertfunction saverecords($first_name,$last_name,$email)
{
$query="insert into crud values('','$first_name','$last_name','$email')";
$this->db->query($query);
}
}

insert.php (View)

<!DOCTYPE html> 
<html>
<head>
<title>Registration form</title>
</head>
<body>
<form method="post">
<table width="600" border="1" cellspacing="5" cellpadding="5">
<tr>
<td width="230">First Name </td>
<td width="329"><input type="text" name="first_name"/></td>
</tr>
<tr>
<td>Last Name </td>
<td><input type="text" name="last_name"/></td>
</tr>
<tr>
<td>Email ID </td>
<td><input type="email" name="email"/></td>
</tr>
<tr>
<td colspan="2" align="center"><input type="submit" name="save" value="Save Data"/></td>
</tr>
</table>
</form>
</body>
</html>

Run the program on your browser with URL:

http://localhost/codeIgniter/index.php/Crud/savedata

Here codeIgniter is my folder name. Put your folder name instead of codeIgniter.Rest of things are same.