four tables joins in laravel eloquent

Question

this query is for codeigniter how to make it in laravel eloquent

 $this->db->select('*');
            $this->db->from('countries cun'); 
            $this->db->join('cities cit', 'cit.country_code=cun.country_code', 'left');
            $this->db->join('city_states cits', 'cits.country_code=cun.country_code', 'left');
            $this->db->join('timezone timz', 'timz.country_code=cun.country_code', 'left');
            $this->db->where('cun.country',$id);         
           return $query = $this->db->get()->result();

Shalu Singhal · Accepted Answer · 2016-05-19T06:55:44.557

1

Try this

return DB::table('countries AS cun')
    ->leftJoin('cities AS cit', 'cit.country_code', '=', 'cun.country_code')
    ->leftJoin('city_states AS cits', 'cits.country_code', '=', 'cun.country_code')
    ->leftJoin('timezone AS timz', 'timz.country_code', '=', 'cun.country_code')
    ->where('cun.country', $id)
    ->get();

Eloquent Model

return Country::leftJoin('cities AS cit', 'cit.country_code', '=', 'countries.country_code')
     ->leftJoin('city_states AS cits', 'cits.country_code', '=', 'countries.country_code')
     ->leftJoin('timezone AS timz', 'timz.country_code', '=', 'countries.country_code')
     ->where('countries.country', $id)
     ->get();

edited May 19 '16 at 06:55

answered May 19 '16 at 06:47

Shalu Singhal

553
3
8

my question is in eloquent model not a query builder – Ghulam Abbas May 19 '16 at 06:50
Okay. I have update the answer. Check this and let me know if this helps you. – Shalu Singhal May 19 '16 at 06:56

score 0 · Answer 2 · edited May 23 '17 at 12:33

0

See here

Countries::with(["cities", "city_states", "timezone"])->where("country", $id)->get();

Countries - Eloquent Model.

cities, city_states, timezone - relationships in the Countries model.

edited May 23 '17 at 12:33

Community

1
1

answered May 19 '16 at 07:01

Andrii Lutskevych

1,349
13
23

four tables joins in laravel eloquent

2 Answers2