Concat two columns With laravel eloquent

Question

I have 3 tables, 1. countries 2. states 3.citites

COUNTRIES contains id, name columns .

STATES contains id, name, country_id columns.

CITIES contains id, name, state_id.

I am accessing cities with hasManyThrough() relation.

Relation:

public function cities()
{
   return $this->hasManyThrough('App\Models\City','App\Models\State');
}

How i am fetching citeis:

$countryObj = Country::where('name','like',$country.'%')->first();
$cities =  $countryObj->cities->pluck('name');
return response()->json(['cities'=>$cities],200);

I want to concat cites with theirs respective countries. Like: Uk-London

Rwd · Accepted Answer · 2019-06-10 10:40:14Z

2

One way to do this would be to use map. You can pass the $countryObj in to it and then simply concatenate the strings together:

$countryObj = Country::where('name', 'like', $country . '%')->first();

$cities = $countryObj->cities->map(function ($city) use ($countryObj) {
    return $countryObj->name . '-' . $city->name;
});

return response()->json(['cities' => $cities], 200);

answered Jun 10, 2019 at 10:40

Rwd

35.3k7 gold badges71 silver badges85 bronze badges

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

2 Comments

weaver Over a year ago

What if i want to concat each cities with their country. Like: UK-London,US-New york,...

Rwd Over a year ago

@weaver You could eager load the states and countries with the cities and then use map again.

Collectives™ on Stack Overflow

Concat two columns With laravel eloquent

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related