CI(3) model CRUD

model

<?php
	class Test_model extends CI_Model //test_model 是CI推荐的规范,不强制,但要与文件名相同
	{									  //首字母要求大写,但是在win下小写也没事 ,linux没有试过
		public function __construct()
		{
			parent::__construct(); //这是必须的
			$this->load->database(); //非必要,只不过为了方便 自动连接数据库
		}
		public function insert(Array $data) //Create
		{
			$this->db->insert("test",$data);
		}
		public function select($id=NULL) //Retrieve
		{
			//这种 数据库操作方式没有TP好用,也没有YII好用
			if($id)
			{
				$this->db->where('id',$id);
			}
			$this->db->select("*");
			$query=$this->db->get("test");
			return $query->result();
		}
		public function update($id,Array $date)//Update
		{
			$this->db->where('id',$id);
			$this->db->update('test',$date);
		}
		public function delete($id)//Delete
		{
			$this->db->where('id',$id);
			$this->db->delete('test');
		}
	}
?>

controller 调用

<?php 
if ( ! defined('BASEPATH')) exit('No direct script access allowed');
class defaults extends CI_Controller {

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -  
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in 
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see http://codeigniter.com/user_guide/general/urls.html
	 */
	public function index()
	{
		header('Content-type:text/html;charset=utf-8');
		$this->load->view('head');
		$this->load->view('body');
		$this->load->view('foot',array('foot'=>'哥们'));
	}
	public function insert()
	{
		$this->load->model('test_model');
		$this->test_model->insert(array('name'=>'赵彤','password'=>md5('221310')));
	}
	public function select()
	{
		$this->load->model('test_model');
		var_dump($this->test_model->select());
	}
	public function update()
	{
		$this->load->model('test_model');
		$this->test_model->update(1,array('name'=>'阿三'));
	}
	public function delete()
	{
		$this->load->model('test_model');
		$this->test_model->delete(1);
	}
}

/* End of file welcome.php */
/* Location: ./application/controllers/welcome.php */