CodeIgniter Tutorial
Home
CodeIgniter Installation
CodeIgniter Configuration
CodeIgniter Features
CodeIgniter URL
CodeIgniter Model
CodeIgniter View
CodeIgniter Controller
CodeIgniter Helper
CodeIgniter Library
CodeIgniter Session
CodeIgniter Flashdata
CodeIgniter Tempdata
CodeIgniter Example
CodeIgniter File Uploading
Form Validation
CodeIgniter Insert Data
CodeIgniter Display Data
CodeIgniter Delete Data
CodeIgniter Update Data
CodeIgniter Send Email
How to insert data in codeigniter
For creating table the SQL query is:
CREATE TABLE demo ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `email` varchar(30) NOT NULL, `password` varchar(30) NOT NULL, PRIMARY KEY (id) );
Create a view file insert.php and save the below code it in application/views/insert.php.
<!DOCTYPE html> <html> <head> <title>Insertdata form</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/css/bootstrap.min.css"> <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script> <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.4.0/js/bootstrap.min.js"></script> </head> <body> <div class="container"> <div class="row"> <div class="col-lg-6"> <form action="<?= base_url('demo/save') ?>" method="post"> <label>Name</label> <input type="text" name="name" class="form-control" placeholder="Enter your name"> <br/> <label>Email</label> <input type="email" name="email" class="form-control" placeholder="Enter your email"> <br/> <label>Password</label> <input type="text" name="password" class="form-control" placeholder="Enter your password"> <br/> <input type="submit" value="Insertdata" class="form-control"> </form> </div> </div> </div> </body> </html>
Create a controller file Demo.php and save it in application/controller/Demo.php.
<?php defined('BASEPATH') OR exit('No direct script access allowed'); class Demo extends CI_Controller { public function __construct() { parent::__construct(); $this->load->model("Demo_Model"); } function insert(){ $this->load->view("insert"); } function save(){ $data = $this->input->post(); $result = $this->Demo_Model->save("demo",$data); if (!empty($result)){ redirect(base_url("demo/insert")); } } }
Create a model file Demo.php and save it in application/models/Demo_Model.php.
<?php class Demo_Model extends CI_Model{ function save($table_name,$data){ $this->db->insert($table_name,$data); return $this->db->insert_id(); } }
Let us execute this example by the following URL in the browser. This URL may be different based on your website.
https://howtowebcode.com/demo/insert