Joining two tables in codeigniter query

How to join two tables in codeigniter ?

Codeigniter table joining queries are used to join two database tables. Most of the php web developers know to join mysql database tables using core php but not by using codeigniter query builder. So, today we are going to discuss about joining two tables in codeigniter with examples.

Codeigniter table join

Consider two database tables 

1)  students_account - To store students details.

2)  school_list - To store school details.

Table 1 : students_account
id	student_name	school_id
1	Eshin	3
2	Jozer	1
3	Jacinth	2

Table 2 : school_list
id	school_name
1	StudentsBlog100
2	W3schools100
3	Sample School

Model

function test_model($student_id)
{
     $this->db->select('students_account.*,school_list.school_name');
     $this->db->from("students_account");
     $this->db->join('school_list', 'students_account.school_id = school_list.id', 'left');
     $this->db->where("students_account.id",$student_id);
     $query=$this->db->get();
          if($query->num_rows() > 0)
          {
          return $query->result();
          }
     return false;
}

Controller

public function test_controller() 
{
     $student_id = 2;
  
     $query = $this->model_name->test_model($student_id);  
          if($query)
          {
               echo "<pre>";
               print_r($query);
               echo "</pre>";
          }
          else
          {
               echo "problem in getting student's details";
          }
 }

---

Test by using above sample codes.. if you have any doubts or any mistakes in the codes given above, please let me know by commenting below.. Thank you, W3schools100 team