Search in three related table

I have 3 tables: Visitors (ID, name, places_id, ...) Places (Id, name, country_id ...) and Countries (Id, Name, ...).

Visitors is related to Places in a Model. Places is related to Countries in another Model.

I need to do a single search for a keyword in the three tables and return the result in one table.

Thank you for helping.

SilenceBringer

5 years ago

Best Answer

Level 55

@eas3011 assuming you have defined place relation on your Visitor model, and country relation on your Place model

$search = 'keyword';

$visitors = Visitor::where('name', 'like', '%' . $search . '%')
    ->orWhereHas('place', function ($placeQuery) use ($search) {
        $placeQuery->where('name', 'like', '%' .. $search . '%')
            ->orWhereHas('country', function ($countryQuery) use ($search) {
                $countryQuery->where('name', 'like', '%' .. $search . '%');
            });
    })
    ->with('place.country')
    ->get();

1 like

eas3011

5 years ago

Level 1

Perfect. Very grateful.

Please or to participate in this conversation.