Detailed explanation of the sample code for basic addition, deletion, modification and query operations of the CodeIgniter framework

This article mainly introduces the basic addition, deletion, modification and query operations of the CodeIgniter framework, and analyzes the relevant implementation skills of the CodeIgniter framework for database creation, addition, deletion, modification and query operations based on specific examples. Friends in need can refer to the following

The example in this article describes the basic addition, deletion, modification and query operations of the CodeIgniter framework. Share it with everyone for your reference, the details are as follows:

Regarding the addition, deletion and modification of codeigniter, I will use an example of my own to illustrate:

Create database:

CREATE TABLE IF NOT EXISTS `users` (
 `id` int(10) NOT NULL AUTO_INCREMENT,
 `username` varchar(50) NOT NULL,
 `password` varchar(50) NOT NULL,
 `email` varchar(100) NOT NULL,
 `fullname` varchar(100) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `username` (`username`),
 UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Model

MTest.php

<?php
  class MTest extends CI_Model{
    public function construct(){
      parent::construct();
      $this->load->database();
    }
    //insert into data
    public function insert_users($arr){
      $this->db->insert(&#39;users&#39;,$arr);
    }
    //delete data
    public function delete_users($id){
      $this->db->where(&#39;id&#39;,$id);
      $this->db->delete(&#39;users&#39;);
    }
    //Alter data
    public function update_users($username,$arr){
      $this->db->where(&#39;username&#39;,$username);
      $this->db->update(&#39;users&#39;,$arr);
    }
    //select data
    public function select_users($id){
      $this->db->where(&#39;id&#39;,$id);
      $this->db->select(&#39;*&#39;);
      return $this->db->get(&#39;users&#39;);
      //注意如果你返回的是以下内容的话，他就是一个对象的结果集，这样当你返回controller中时，你就得转换；
//     return $query->result();
    }
  }
?>

Controller

home.php

<?php
/**
 * xxx.php
 * ==============================================
 * Copy right 2012-2015
 * ----------------------------------------------
 * This is not a free software, without any authorization is not allowed to use and spread.
 * ==============================================
 * @Author:YeXianMing
 * @Email:LangWaiShiGe@hotmail.com
 * @Version:zend studio10.6.2 php5.4.38 apache2.2
 */
  if(!defined(&#39;BASEPATH&#39;))exit(&#39;No direct script access allowed&#39;);
  class Home extends CI_Controller{
    public function construct(){
      parent::construct();
    }
    //insert data
    public function insert(){
      $this->load->model(&#39;MTest&#39;,&#39;&#39;,TRUE);
      $arr=array(&#39;username&#39;=>&#39;yexianming1&#39;,&#39;password&#39;=>&#39;admin&#39;,&#39;email&#39;=>&#39;11504160314qq.com&#39;,&#39;fullname&#39;=>&#39;luotianyexianming&#39;);
      if(!($this->MTest->insert_users($arr))){
        echo "插入数据成功";
      }else{
        echo "插入数据失败";
      }
    }
    //update data
    public function update(){
      $this->load->model(&#39;MTest&#39;,&#39;&#39;,TRUE);
      $arr=array(&#39;username&#39;=>&#39;Helloworld22&#39;,&#39;password&#39;=>&#39;root&#39;,&#39;email&#39;=>&#39;895787704@qq.com&#39;,&#39;fullname&#39;=>&#39;luotianyecong&#39;);
      if(!($this->MTest->update_users(&#39;Helloworld&#39;,$arr))){
        echo "修改成功";
      }else{
        echo "修改失败";
      }
    }
    //delete data
    public function delete(){
      $this->load->model(&#39;MTest&#39;,&#39;&#39;,TRUE);
      $query=$this->MTest->delete_users(12);
      if(!$query){
        echo "删除成功";
      }else{
        echo "删除失败";
      }
    }
    //select data
    public function select(){
      $this->load->library(&#39;table&#39;);
      $this->load->model(&#39;MTest&#39;,&#39;&#39;,TRUE);
      $arr=$this->MTest->select_users(3);
      $userinformation=$this->table->generate($arr);
      $data[&#39;userinfor&#39;]=$userinformation;
      $this->load->view(&#39;template&#39;,$data);
    }
  }
?>

view

temlate.php

<?php echo $userinfor;?>

output:

id username password email fullname
3 Helloworld22 root 1111111@qq.com luotianyecong

The above is the detailed content of Detailed explanation of the sample code for basic addition, deletion, modification and query operations of the CodeIgniter framework. For more information, please follow other related articles on the PHP Chinese website!