Codeigniter, PHP tips & tricks for developer

This is a list of tips trick & guide for these people want to learn codeigntier, php and web development 1. [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();

CodeIgniter plugin for Sublime Text

https://sublime.wbond.net/packages/CodeIgniter%20Snippets http://stackoverflow.com/questions/16235706/sublime-3-set-key-map-for-function-goto-definition

[1]:https://gist.github.com/phplaw/6305193