This is a list of tips trick & guide for these people want to learn codeigntier, php and web development
- [Codeigniter Input for handle PUT & DELETE][1]
Codeigniter JOIN:
$this->db->select('*');
$this->db->from('TableA AS A');// I use aliasing make joins easier
$this->db->join('TableC AS C', 'A.ID = C.TableAId', 'INNER');
$this->db->join('TableB AS B', 'B.ID = C.TableBId', 'INNER');
$result = $this->db->get();CI update data with update method without using other methods where, limit ...
$CI->db->update('allocation_tabs', $tab_data, array('id' => $tab_id), 1);CI get data by get_where
$tab_detail = $CI->db->get_where('table_name', array('id' => $_id), 1)->row();