CodeIgniter framework database use case analysis-PHP Tutorial-php.cn

This time I will bring you an analysis of the use cases of the CodeIgniter framework database. What are theprecautionswhen using the CodeIgniter framework database. The following is a practical case, let's take a look.

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

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

Copy after login

Then configure the database inconfig/databases .phpMy practice configuration is as follows

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

Copy after login

Other things that newbies don’t need now are to create a database and a user table. 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

The reg 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');//同上跳转 } } ?>

Copy after login

The view code is as follows

   用户注册 
      姓名:  
   姓别:男 女  
   年龄:  
   密码:  
   邮件:

Copy after login

The second view code is as follows

   显示数据库中的所有注册用户  
  result() as $item):?>  注册用户的显示  ID  Name  Sex  Age  Email  Operate  
  id; ?>  name; ?>  sex; ?>  age; ?>  email; ?>   删除 | 修改

注册用户的显示
ID	Name	Sex	Age	Email	Operate
id; ?>	name; ?>	sex; ?>	age; ?>	email; ?>	删除 \| 修改

Copy after login

The three views are as follows

   修改用户注册信息 
     姓名:  
  密码:  
  邮件:

Copy after login

The renderings are as follows

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related matters on the PHP Chinese website article!