Relevant explanations of basic operations of the CodeIgniter framework database

This article mainly introduces the basic operations of the CodeIgniter framework database, and analyzes the basic operation skills of the CodeIgniter framework for mysql database configuration, user registration, information query, modification and deletion in the form of examples. Friends in need can refer to the following

The examples in this article describe the basic operations of the CodeIgniter framework database. Share it with everyone for your reference, the details are as follows:

Start now, first move the CI framework to your own server directory and configure config/config.php

$config['base_url'] = 'http://localhost:90/CI/';

Next, configure the database in config/databases.phpI do the practice configuration as follows

$db['default']['hostname'] = 'localhost';
$db['default']['username'] = 'root';
$db['default']['password'] = 'root';
$db['default']['database'] = 'demo';
$db['default']['dbdriver'] = 'mysql';

In addition, novices now don’t need to create a database and a user table immediately. This is in my source code package and you can import it directly, but the prerequisite is that you need to create a demo database

reg The class code is as follows

load->database();//这个是连接数据库的方法，放到这里的好处只要调用该方法就会连接数据库
  }
  function index(){
    $this->load->view('reg_view');//这个是使用哪个视图来显示相当于Smarty中的display
  }
  function reg_insert(){
    $data['name'] = $this->input->post('name');//这个是指取得POST数组的值然后赋值一个心的数组
    $data['sex'] = $this->input->post('sex');
    $data['age'] = $this->input->post('age');
    $data['pwd'] = md5($this->input->post('pwd'));//这里用了一个md5加密只是为了演示
    $data['email'] = $this->input->post('email');
    $this->db->insert('user',$data);//这个是数据库操作插入操作
    redirect('/reg/reg_select/', 'refresh');//这个是跳转函数是url辅助函数里面的一个方法
  }
  function reg_select(){//这个查询数据库的方法
    $this->db->select('id,name,sex,age,email');//这里是查询要显示的字段，可不能像我第一次这样写啊$this->db->select('id','name','sex','age','email');
    $data['query'] = $this->db->get('user');//这个是取得数据（如果你上面写的和我第一次一样的话只能取的一个字段）
    $this->load->view('select_view',$data);//这里是调用哪个视图并分配数据给指定视图显示
  }
  function reg_delete(){//删除数据的操作
    $id = $this->input->get('id');//这里是取得get传过来的值
    $this->db->where('id',$id);//这里是做where条件这个相当重要，如果没有这个你有可能把这个表数据都清空了
    $this->db->delete('user');//删除指定id数据
    redirect('/reg/reg_select/', 'refresh');//同上跳转
  }
  function reg_update(){//跟新数据的操作
    $data['id'] = $this->input->get('id');//同上取的get传值过来的ID
    $this->load->view('update_view',$data);//同上调用视图分配数据
  }
  function reg_com_update(){//这个是真正的跟新数据操作方法
    $id = $this->input->post('id');//同上取得post中的id值
    $data = array(//把post数组的值封装到新的数组中为了下面跟新操作用
          'name'=>$this->input->post('name'),
          'pwd'=>md5($this->input->post('pwd')),
          'email'=>$this->input->post('email' )
        );
    if(!empty($id) && (count($data) > 1)){//判断id值是否传过来并且判断封装的数组是否有元素存在
      $this->db->where('id',$id);//同上准备where条件
      $this->db->update('user',$data);//跟新操作
    }
    redirect('/reg/reg_select/', 'refresh');//同上跳转
  }
}
?>

The view code is as follows

  
    
    
  

  
    

      

        

          

            姓名:
          
        
        

          

            姓别:男
               女
          
        
        

          

            年龄:
          
        
        

          

            密码:
          
        
        

          

            邮件:
          
        
        

          

            
            
          
        
      
    
  

The second view code is as follows

  
    
    
    
  

  
    result() as $item):?>
      

      
注册用户的显示
      

        
ID
        
Name
        
Sex
        
Age
        
Email
        
Operate
      
      

        
id; ?>
        
name; ?>
        
sex; ?>
        
age; ?>
        
email; ?>
        

          删除 |
          修改
        
      
      
    
  

The third view is as follows

  
    
    
  

  
    

      

        

          
姓名:
        
        

          
密码:
        
        

          
邮件:
        
        

          

            
            
          
        
      
    
  

The rendering is as follows

There is no verification or proofreading, just practice the basic operations of the database.

Articles you may be interested in:

PHP method to get all the dates of this week or all the dates of the last seven days

Comparison of the effect of php lcg_value and mt_rand in generating 0~1 random decimals

How to use php to perform ID prefix formatting class

The above is the detailed content of Relevant explanations of basic operations of the CodeIgniter framework database. For more information, please follow other related articles on the PHP Chinese website!