How to get data from 2 related tables in the same controller? |
I'm trying to get data from 2 DB tables that are related. Departments and Functions: Each Department has multiple Functions.
I want to show all data in an accordion on the same page. Until now, the code works like this: Declare the variable departments in the controller, and in view, in the foreach loop, I have called the Functions model in a variable. Controller: Code: public function index(){ Here I want to add the Function->get_by_department_id() method. How to get the ID dynamically? The occupation model method: Code: public function get_by_fk($table = 'occupations', $fk = "department_id" , $fk_value=$department->department_id){
Use JOIN to get the result from both tables at once.
The CI documentation explains it very well. If you prefer the query builder, look for $this->db->join() AND $this->db->order_by(). Once you get all the data in an array, you can fill the accordion in your view with it. PHP Code: $this->db->select('d.*, o.*') Simple join it is all you have to do, and you should learn JOIN clause in SQL.
|
Welcome Guest, Not a member yet? Register Sign In |