Laravel hasMany with join

public function earmarks() {
   return $this->hasMany('App\Earmark', 'labtop_id', 'id')
        ->join('locations', 'locations.id', '=', 'earmarks.location')
        ->select('earmarks.*', 'locations.location AS em_location')
        ->orderBy('date', 'asc')->get();
}

Source: stackoverflow.com

Similar codes

2 votes203 views1 answer
Php discord webhook
PHP
3 votes224 views2 answers
Laravel add values to request
PHP Laravel
9 votes225 views2 answers
Php check if object has key
PHP
1 vote185 views1 answer
How to protect your website from DDos Attack?
PHP
31 votes230 views6 answers
Update or create laravel
PHP Laravel
0 vote182 views1 answer
Trim specific character from strin using php
PHP
0 vote189 views1 answer
Comment installer laravel avec docker
PHP
1 vote222 views1 answer
Types of controller in laravel
PHP
0 vote243 views1 answer
Laravel openstreetmap
PHP Laravel
0 vote186 views1 answer
Searching for new lines
PHP