laravel model two table search example

1-on-one

Define one-to-one association

One-to-one association is a very basic association. For example, a User model will correspond to a Phone. In Eloquent, you can define associations like the following:

class User extends Model {
 
 public function phone()
 {
  return $this->hasOne('App\Phone');
 }
 
}

The first parameter passed to the hasOne method is the class name of the associated model. After defining the association, you can use the dynamic attributes of Eloquent to obtain the association object:

$phone = User::find(1)->phone;

SQL will execute the following statement:

select * from users where id = 1
 
select * from phones where user_id = 1

Note that Eloquent assumes that the foreign key name is based on the model name in the corresponding associated model database table. In this example, the default Phone model database table will use user_id as the foreign key. If you want to change this default, you can pass the second parameter into the hasOne method. Going further, you can pass in a third parameter, specifying which field the associated foreign key should correspond to:

return $this->hasOne('App\Phone', 'foreign_key');
 
return $this->hasOne('App\Phone', 'foreign_key', 'local_key');

Query multiple entries

 $rolePermissions = Permission::join('permission_role', 'permission_role.permission_id', '=', '')
   ->where('permission_role.role_id', $id)
   ->get();

The above example of the two-table joint search of laravel model is all the content I share with you. I hope you can give you a reference and I hope you can support me more.