Laravel Eloquent data Relationship issue
i have two tables:
Students Table:
columns: id | family_id | name | class | section
Families Table:
columns: id | f_name | f_profession
what i want: i want to fetch list of brothers and sisters for each student if there is any in student table. i want to show list of brothers/sisters on each student profile.
what i tried: i am able to get list of all students, when i click on student name it opens student profile, but doesn't show brothers/sisters of that student.
My Controller:
public function show($id){
$showdata = Student::find($id);
return View('students.profile' ,compact('showdata');}
My Student Model:
class student extends Model
{
public function family() {
return $this->belongsTo(family::class,'family_id'); }
public function getSiblings() {
return $this->family->students;
}}
My profile View:
Brother Sisters :{{$showdata->getSiblings()}}
laravel eloquent
asked Nov 23 '18 at 16:52
iMattiiMatti
33
add a comment |
i have two tables:
Students Table:
columns: id | family_id | name | class | section
Families Table:
columns: id | f_name | f_profession
what i want: i want to fetch list of brothers and sisters for each student if there is any in student table. i want to show list of brothers/sisters on each student profile.
what i tried: i am able to get list of all students, when i click on student name it opens student profile, but doesn't show brothers/sisters of that student.
My Controller:
public function show($id){
$showdata = Student::find($id);
return View('students.profile' ,compact('showdata');}
My Student Model:
class student extends Model
{
public function family() {
return $this->belongsTo(family::class,'family_id'); }
public function getSiblings() {
return $this->family->students;
}}
My profile View:
Brother Sisters :{{$showdata->getSiblings()}}
laravel eloquent
asked Nov 23 '18 at 16:52
iMattiiMatti
33
add a comment |
i have two tables:
Students Table:
columns: id | family_id | name | class | section
Families Table:
columns: id | f_name | f_profession
what i want: i want to fetch list of brothers and sisters for each student if there is any in student table. i want to show list of brothers/sisters on each student profile.
what i tried: i am able to get list of all students, when i click on student name it opens student profile, but doesn't show brothers/sisters of that student.
My Controller:
public function show($id){
$showdata = Student::find($id);
return View('students.profile' ,compact('showdata');}
My Student Model:
class student extends Model
{
public function family() {
return $this->belongsTo(family::class,'family_id'); }
public function getSiblings() {
return $this->family->students;
}}
My profile View:
Brother Sisters :{{$showdata->getSiblings()}}
laravel eloquent
asked Nov 23 '18 at 16:52
iMattiiMatti
33
i have two tables:
Students Table:
columns: id | family_id | name | class | section
Families Table:
columns: id | f_name | f_profession
what i want: i want to fetch list of brothers and sisters for each student if there is any in student table. i want to show list of brothers/sisters on each student profile.
what i tried: i am able to get list of all students, when i click on student name it opens student profile, but doesn't show brothers/sisters of that student.
My Controller:
public function show($id){
$showdata = Student::find($id);
return View('students.profile' ,compact('showdata');}
My Student Model:
class student extends Model
{
public function family() {
return $this->belongsTo(family::class,'family_id'); }
public function getSiblings() {
return $this->family->students;
}}
My profile View:
Brother Sisters :{{$showdata->getSiblings()}}
laravel eloquent
laravel eloquent
asked Nov 23 '18 at 16:52
iMattiiMatti
33
asked Nov 23 '18 at 16:52
iMattiiMatti
33
asked Nov 23 '18 at 16:52
iMattiiMatti
33
asked Nov 23 '18 at 16:52
iMattiiMatti
33
asked Nov 23 '18 at 16:52
iMattiiMatti
33
33
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You need a 'has many through' relationship.
public function studentSiblings() {
return $this->hasManyThrough('AppSibling', 'AppFamily);
}
More information can be found: https://laravel.com/docs/5.7/eloquent-relationships#has-many-through
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
A more appropriate function name would besiblingStudentssince it's a relationship function.
– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
|
show 2 more comments
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450446%2flaravel-eloquent-data-relationship-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You need a 'has many through' relationship.
public function studentSiblings() {
return $this->hasManyThrough('AppSibling', 'AppFamily);
}
More information can be found: https://laravel.com/docs/5.7/eloquent-relationships#has-many-through
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
A more appropriate function name would besiblingStudentssince it's a relationship function.
– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
|
show 2 more comments
You need a 'has many through' relationship.
public function studentSiblings() {
return $this->hasManyThrough('AppSibling', 'AppFamily);
}
More information can be found: https://laravel.com/docs/5.7/eloquent-relationships#has-many-through
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
A more appropriate function name would besiblingStudentssince it's a relationship function.
– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
|
show 2 more comments
You need a 'has many through' relationship.
public function studentSiblings() {
return $this->hasManyThrough('AppSibling', 'AppFamily);
}
More information can be found: https://laravel.com/docs/5.7/eloquent-relationships#has-many-through
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
You need a 'has many through' relationship.
public function studentSiblings() {
return $this->hasManyThrough('AppSibling', 'AppFamily);
}
More information can be found: https://laravel.com/docs/5.7/eloquent-relationships#has-many-through
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
edited Nov 26 '18 at 9:29
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
answered Nov 23 '18 at 17:08
user10341554user10341554
151112
151112
A more appropriate function name would besiblingStudentssince it's a relationship function.
– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
|
show 2 more comments
A more appropriate function name would besiblingStudentssince it's a relationship function.
– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
A more appropriate function name would be
siblingStudents since it's a relationship function.– apokryfos
Nov 23 '18 at 17:13
A more appropriate function name would be
siblingStudents since it's a relationship function.– apokryfos
Nov 23 '18 at 17:13
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@user10341554 but i don't have sibling model? appsibling??
– iMatti
Nov 23 '18 at 17:20
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
@apokryfos i i don't have any model name, siblings, can you please correct my model/view/controllers?
– iMatti
Nov 23 '18 at 17:23
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
Error: "Class 'AppSibling' not found", what should be in siblings?
– iMatti
Nov 23 '18 at 17:24
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
can i do it using models which i already shared?
– iMatti
Nov 23 '18 at 17:26
|
show 2 more comments
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450446%2flaravel-eloquent-data-relationship-issue%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
