codeigniterデータベース操作関数のまとめ

インターネットでは多くのCodeigniterデータベース操作の紹介がありますが、ここでまとめてみます。

//  : 
$query = $this->db_query("SELECT * FROM table");
 ==================================

//result()       
$data = $query->result();

//result_array()     
$data = $query->result_array();

//row()          
$data = $query->row();

//num_rows()         
$data = $query->num_rows();

//num_fields()            
$data = $query->num_fields();

//row_array()        
$data = $query->row_array();

//free_result()                      
$data = $query->free_result();

/*
 ==================================
     
 ==================================
*/

//         ID
echo $this->db->insert_id();

//             
echo $this->db->affected_rows();

//         
echo $this->db->count_all('table_name');

//           
echo $this->db->version();

//          
echo $this->db->platform();

//           
echo $this->db->last_query();

//    ，               ，  ：
//$data = array('name' => $name, 'email' => $email, 'url' => $url);
$this->db->insert_string('table_name', $data);

/*
 ==================================
     
 ==================================
*/

//    ，               ，  ：
//$data = array('name' => $name, 'email' => $email, 'url' => $url);
//$where = "author_id = 1 AND status = 'active'";
$this->db->update_string('table_name', $data, $where);

/*
 ==================================
     
 ==================================
*/

//        
$this->db->get('table_name');

//          ，          
$this->db->get('table_name', 10, 20);

//    ，        ，        ，      
$this->db->get_where('table_name', array('id'=>$id), $offset);

//select      
$this->db->select('title, content, date');
$data = $this->db->get('table_name');

//        ，        ，   max(age) AS nianling
$this->db->select_max('age');
$this->db->select_max('age', 'nianling');

//        
$this->db->select_min('age');
$this->db->select_min('age', 'nianling');

//      
$this->db->select_sum('age');
$this->db->select_sum('age', 'nianling');

//   from 
$this->db->select('title', content, date');
$this->db->from('table_name');

//     WHERE name = 'Joe' AND title = "boss" AND status = 'active'
$this->db->where('name', $name);
$this->db->where('title', $title);
$this->db->where('status', $status);

//    
$this->db->where_in('item1', 'item2');
$this->db->where_not_in('item1', 'item2');

//  ，           title LIKE '%match%'
$this->db->like('title', 'match', 'before/after/both');