Posts

Showing posts from April, 2016

add join in datatables using codeigniter

Sets join statement variables. If you want DataTables to include data from another table, you can define an a table along with its columns and foreign key relationship. $this->datatables->join('states', 'cities.state_id = states.id', 'left'); $this->datatables->select('cities.id,cities.name,states.name as state_name') ->from('cities');