Home >>Codeigniter Tutorial >CodeIgniter Insert Data into Database

CodeIgniter Insert Data into Database

CodeIgniter gives you access to a Query Builder class. This pattern allows information to be retrieved, inserted, and updated in your database with minimal scripting. In some cases only one or two lines of code are necessary to perform a database action. In this tutorial we will understand how to Save Records inside database using CodeIgniter Core Library. Here we are going to use student table to Save Records and Check user's existence. This is student table structure

Table Name : student
student_id	int primary key auto_increment
name	char(50)
email	varchar(100)
password	varchar(100)
mobile	bigint
course	char(100)

Controller

Copy the below given code in your User Controller.

<?php
class User extends CI_Controller 
{
	public function __construct()
	{
	parent::__construct();
	$this->load->database();
	$this->load->helper('url');
	}

	public function index()
	{	
		if($this->input->post('register'))
		{
		//first check user's email id already exists or not
$query=$this->db->get_where("student",array('email'=>$this->input->post('email')));

//count number of matching rows
$row=$query->num_rows();
	
		if($row)
		{
		$data['error']="<h3 style='color:red'>This user already exists</h3>";
		}
		else
		{
		$data=array('student_id'=>'',
					'name'=>$this->input->post('name'),
					'email'=>$this->input->post('email'),
					'password'=>$this->input->post('pass'),
					'mobile'=>$this->input->post('mobile'),
					'course'=>$this->input->post('course'));
		
		$this->db->insert('student',$data);
		
		$data['error']="<h3 style='color:blue'>Your account created successfully</h3>";
		}
		
	  }
		$this->load->view('student_registration',@$data);
	}
	
}
?>

Registration View

<!DOCTYPE html>
<html>
<head>
<title>Student Registration form</title>
</head>

<body>
	<form method="post">
		<table width="600" align="center" border="1" cellspacing="5" cellpadding="5">
	<tr>
		<td colspan="2"><?php echo @$error; ?></td>
	</tr>	
  <tr>
    <td width="230">Enter Your Name </td>
    <td width="329"><input type="text" name="name"/></td>
  </tr>
  
  <tr>
    <td>Enter Your Email </td>
    <td><input type="text" name="email"/></td>
  </tr>
  
  <tr>
    <td>Enter Your Password </td>
    <td><input type="password" name="pass"/></td>
  </tr>

  <tr>
    <td>Enter Your Mobile </td>
    <td><input type="text" name="mobile"/></td>
  </tr>
  
  <tr>
    <td>Select Your Course </td>
    <td>
	<select name="course">
		<option value="">Select Course</option>
		<option>PHP</option>
		<option>Java</option>
		<option>Wordpress</option>
	</select>
	</td>
  </tr>
  
  <tr>
    <td colspan="2" align="center">
	<input type="submit" name="register" value="Register Me"/></td>
  </tr>
</table>
	</form>
</body>
</html>

Execute User Controller’s index method

Open your web browser and Pass : http://localhost/CodeIgniter/index.php/user/index

Output(Save Records if email id is not already exists)

Output(Show error "This user already exists")

« Previous Next »

Codeigniter Tutorial Codeigniter overview Codeigniter Installation CodeIgniter Application Architecture CodeIgniter MVC Framework Codeigniter controller Codeigniter Views Codeigniter Models codeigniter insert data database Codeigniter display data from database Codeigniter delete database record Codeigniter update database record Create registration form in codeigniter Create login form in Codeigniter CodeIgniter Insert Data into Database How to Upload image in codeigniter How to Remove index.php in Codeigniter How to use pagination in codeigniter CodeIgniter Form Validation with Example How to Set Session in Codeigniter With Example How to Send Email using CodeIgniter CodeIgniter URL Routing Codeigniter Tutorial PDF Difference between CodeIgniter vs Laravel Insert Data Using jQuery Ajax in Codeigniter Username availability check using Codeigniter and AJAX CodeIgniter Strong Password Validation Import CSV Data into Mysql in Codeigniter Export MySQL data to CSV file in CodeIgniter Convert HTML to PDF in CodeIgniter using Dompdf Create Custom 404 Page not found in CodeIgniter How to insert multiple rows in MySQL using Codeigniter Codeigniter multiple drag and drop image upload

CodeIgniter Interview Questions

Download Codeigniter Project

No Sidebar ads