Inserting data into a table in database with codeigniter

This is an important part in the codeigniter because i nthis section we are creating a model for inserting data to our database. Codeigniter has a feature to insert data to a database table with one line by creating all the data to be inserted into an array and store them by passing it with a simple variable to the database.

$this->Users_model->insert_user($u_data);

In the above code that we added in the register_process() function in the controller inserts the data to a particular table in our database.


  • Users_model : this is the new model we created with a .php extension.
  • insert_user()  : this is the function inside that model.
  • u_data            : this is the variable in which the data is stored.
The following is the new edited code in the controller :

   public function register_process()
   {
     if($this->input->post('u_reg'))
     {
      $u_email=$this->input->post('u_email');
       $u_name=$this->input->post('u_name');
       $u_pass=md5($this->input->post('u_password'));

       $u_data=array('u_email'=>$u_email,'u_name'=>$u_name,'u_pass'=>$u_pass);
       $this->Users_model->insert_user($u_data);
       redirect('login','refresh');
     }
     else
     {
       redirect('register','refresh');
     }
   }


User_model.php

<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Users_model extends CI_Model {

  public function insert_user($user_data)
  {
  $this->db->insert('users',$user_data);
  }
  
}


  • users : table name.


We also need to load the model at the top of the controller as below :

  public function __construct()
  {
    parent::__construct();
    $this->load->model('Users_model');
  }




⇐Prev
Next⇒

Comments

Post a Comment

Popular posts from this blog

Node.js Cheat Sheet

Image
To start a new node project, type  C:\Users\jinoy\OneDrive\Desktop\MERN>npm init -y      The basic syntax of calling a function in node.js with express is : const   functionname  = ()  =>  { console . log ( "hello world" ); } functionname (); To call a function after every 5 seconds : setInterval (()  =>  {      console . log ( "hello" ); }, 5000  ); To call a function only once after 4 second : setTimeout (() => { console . log ( "test" ); }, 4000 ); To run a script.js file on terminal, type : C:\Users\jinoy\OneDrive\Desktop\MERN>node script.js  OR C:\Users\jinoy\OneDrive\Desktop\MERN>node script To stop a function that is executing on every interval( time to call function again) : const   interval  =  setInterval (()  =>  {      console . log ( "hello" ); }, 1000  ); setTimeout (() => {      clearInterva...
Read more

Codeigniter ! Simple But Powerful

Image
CodeIgniter is a powerful PHP framework with a very small footprint, built for developers who need a simple and elegant toolkit to create full-featured web applications. It is the second largest php framework for website development (first-Laravel). Due to its simplicity, it is the most used framework ever than laravel. Actually these frameworks are only used for developing large scale website. The important thing about this framework is that it is using MVC principle . A MVC or Model View Control framework has a controller that controls all the pages in the website. There can be any number of controller created in codeigniter. The orginal webpages or the contents are placed in the folder named view .  Note : Don't touch the forder named system because it is the soul of the codeigniter Next ⇒
Read more

Bootstrap ? What is it ?

Image
Have you ever thinked about designing a file that can contain different styles which can be ewhile writing every code. Here is the answer. A Bootstrap is the most popular CSS Framework for developing responsive and mobile-first websites. Bootstrap is a free and open source front enddevelopment framework for the creation of websites and web apps. The Bootstrap framework is built on HTML, CSS, and JavaScript (JS) to facilitate the development of responsive, mobile-first sites and apps. The bootstrap file contain many CSS style , JavaScript and HTML which can be called any number of times during the execution of the program. The bootstrap file is a W3C accepted standard file wich can be used to develop a stylish website easly. Here you can download the bootstrap file directly from my website. It is the now available latest version of the bootstrap file. Version : 4.3.1 Click on the link below to download the bootstrap file. Bootstrap version 4.3.1 If you need ...
Read more