How to fetch specific columns from multiple tables in Laravel 5?

Question

I have 3 tables,

Country: id, name
Province: id, name, country_id
City: id, name, province_id

I have defined relationships in Model as follows,

Country Model:

    public function Provinces()
        {
            return $this->hasMany('App\Province');
        }

Province Model:

        public function Country()
        {
            return $this->belongsTo('App\Country');
        }

        public function Cities()
        {
            return $this->hasMany('App\City');
        }

City Model:

    public function Province()
        {
            return $this->belongsTo('App\Province');
        }

I am using the below query, but it overwrites all the data with Country name.

    $city = DB::table('cities')
        ->join('provinces', 'cities.province_id', '=', 'provinces.id')
        ->join('countries', 'provinces.country_id', '=', 'countries.id')
        ->select('cities.name','provinces.name','countries.name')
        ->get();

I want to fetch a result of only City Name, Province Name, Country Name from these tables in laravel 5. Can you help me with that ?

That is totally a different question. Thanks

Hammad
– Hammad

2016-06-18 20:14:56 +00:00
Commented Jun 18, 2016 at 20:14 — Hammad
– Hammad, Commented Jun 18, 2016 at 20:14

Joel Hinz · Accepted Answer · 2016-06-18 20:24:57Z

3

Try just using as:

->select('cities.name as city_name', 'provinces.name as province_name', 'countries.name as country_name')

answered Jun 18, 2016 at 20:24

Joel Hinz

25.4k8 gold badges65 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

score 0 · Accepted Answer · 2016-06-18 21:41:51Z

0

Would you try with this :

$city = DB::table('cities')
    ->join('provinces', 'cities.province_id', '=', 'provinces.id')
    ->join('countries', 'provinces.country_id', '=', 'countries.id')
    ->get(['cities.name', 'provinces.name', 'countries.name']);

I hope it helps you !

edited Jun 18, 2016 at 21:41

answered Jun 18, 2016 at 20:36

user1389087

2 Comments

Hammad Over a year ago

No, it is not working. it is replacing all the values with the value of Country Name.

user1389087 Over a year ago

Try without the select clause !

Shakti Jadon · Accepted Answer · 2017-11-20 13:51:49Z

0

ok this is going to be a specific answer learn about realtions in laravel and look at these

class example1 extends Model
    {
      public function examplefunction() {
        return $this->hasMany('App\othermodel', 'id');
    }
}

then use this query

$abc=example1::with('examplefunction')->get();

and there you go just take a look at a laravel relationship by using this u can get combined result

answered Nov 20, 2017 at 13:51

Shakti Jadon

4214 silver badges2 bronze badges

Comments

undetected Selenium · Accepted Answer · 2019-01-31 11:17:39Z

-2

 $products = User::select('id', 'email', 'first_name', 'last_name','country_code','mobile')->get()->toArray();
       $gaurang = Ticket_Thread::select('body','title','resolv_note')

edited Jan 31, 2019 at 11:17

undetected Selenium

194k44 gold badges304 silver badges387 bronze badges

answered Jan 31, 2019 at 6:28

radadiya gaurang

1

Collectives™ on Stack Overflow

How to fetch specific columns from multiple tables in Laravel 5?

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related