How to make a relationship between two tables. i have two tables state
and members
in state table i have id , state_name and in members table i have id , state_id, members_name
etc.
i need to fetch all data from table like his/her name,state name
etc
State.php
class State extends Model {
protected $table="state";
protected $fillable =
[
'name'
];
public function member()
{
return $this->hasMany('App\Models\Members');
}
}
Members.php
class Members extends Model {
protected $table="members";
protected $fillable =
[
'members_name',
'state_id'
];
public function state(){
return $this->belongsTo('App\Models\State');
}
}
view:
@foreach($users as $user)
{{$user->name}}//i have not got district name
@endforeach
How to get state name? Is there wrong in using relation.please help me
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire