CodeIgniter Laravel PHP Example Javascript jQuery MORE
Need a Website Or Web Application.Contact : +91 9437911966 (Whatsapp) Note: Paid Service

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

  `id` int(11) NOT NULL,
  `first_name` varchar(30) NOT NULL,
  `last_name` varchar(30) NOT NULL,
  `email` varchar(30) NOT NULL,

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)

class Crud extends CI_Controller 
	public function __construct()
	/*call CodeIgniter's default Constructor*/
	/*load database libray manually*/
	/*load Model*/
	public function savedata()
		/*load registration view form*/
		/*Check submit button */
			        echo "Records Saved Successfully";
					echo "Insert error !";

Crud_model.php (Model)

class Crud_model extends CI_Model 
	function saverecords($data)
          return $this->db->insert_id();

insert.php (View)

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

Run the program on your browser with URL:


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