Fetch names based on comma-separated ids using laravel relations
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
Using Laravel Model relation retrive names based on comma separated ids, can anyone help
for ex
$testing= Testpage::with('relationExample')->where('id',$id)->first();
{{testing->user_ids}} -> output is -> 5,9,15,17
instead of comma separated ids i want to display names with comma separated from users table using laravel relations
laravel
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
add a comment |
0
Using Laravel Model relation retrive names based on comma separated ids, can anyone help
for ex
$testing= Testpage::with('relationExample')->where('id',$id)->first();
{{testing->user_ids}} -> output is -> 5,9,15,17
instead of comma separated ids i want to display names with comma separated from users table using laravel relations
laravel
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
1
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16
add a comment |
0
0
0
Using Laravel Model relation retrive names based on comma separated ids, can anyone help
for ex
$testing= Testpage::with('relationExample')->where('id',$id)->first();
{{testing->user_ids}} -> output is -> 5,9,15,17
instead of comma separated ids i want to display names with comma separated from users table using laravel relations
laravel
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
Using Laravel Model relation retrive names based on comma separated ids, can anyone help
for ex
$testing= Testpage::with('relationExample')->where('id',$id)->first();
{{testing->user_ids}} -> output is -> 5,9,15,17
instead of comma separated ids i want to display names with comma separated from users table using laravel relations
laravel
laravel
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
edited Nov 24 '18 at 9:59
user3544256
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
asked Nov 24 '18 at 9:51
user3544256user3544256
68118
68118
1
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16
add a comment |
1
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16
1
1
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16
add a comment |
1 Answer
1
active
oldest
votes
0
You need another query to explode by comma and make these ids as array and use whereIn('id',$ids)
$ids = explode(',',$testing->user_ids);
$users = Users::whereIn('id',$ids)->pluck('name');
$usersName = implode(',',$users);
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysqlfind_in_setbut i would suggest to make db proper instead code.
– Niklesh Raut
Nov 24 '18 at 11:34
add a comment |
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
});
}
});
draft saved
draft discarded
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%2f53456997%2ffetch-names-based-on-comma-separated-ids-using-laravel-relations%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
0
You need another query to explode by comma and make these ids as array and use whereIn('id',$ids)
$ids = explode(',',$testing->user_ids);
$users = Users::whereIn('id',$ids)->pluck('name');
$usersName = implode(',',$users);
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysqlfind_in_setbut i would suggest to make db proper instead code.
– Niklesh Raut
Nov 24 '18 at 11:34
add a comment |
0
You need another query to explode by comma and make these ids as array and use whereIn('id',$ids)
$ids = explode(',',$testing->user_ids);
$users = Users::whereIn('id',$ids)->pluck('name');
$usersName = implode(',',$users);
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysqlfind_in_setbut i would suggest to make db proper instead code.
– Niklesh Raut
Nov 24 '18 at 11:34
add a comment |
0
0
0
You need another query to explode by comma and make these ids as array and use whereIn('id',$ids)
$ids = explode(',',$testing->user_ids);
$users = Users::whereIn('id',$ids)->pluck('name');
$usersName = implode(',',$users);
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
You need another query to explode by comma and make these ids as array and use whereIn('id',$ids)
$ids = explode(',',$testing->user_ids);
$users = Users::whereIn('id',$ids)->pluck('name');
$usersName = implode(',',$users);
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
answered Nov 24 '18 at 11:07
Niklesh RautNiklesh Raut
19.9k43269
19.9k43269
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysqlfind_in_setbut i would suggest to make db proper instead code.
– Niklesh Raut
Nov 24 '18 at 11:34
add a comment |
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysqlfind_in_setbut i would suggest to make db proper instead code.
– Niklesh Raut
Nov 24 '18 at 11:34
i want using relations
– user3544256
Nov 24 '18 at 11:17
i want using relations
– user3544256
Nov 24 '18 at 11:17
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
Then you have to store each id in separate row in another pivot table.
– Niklesh Raut
Nov 24 '18 at 11:22
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
is not possible to using relations..?
– user3544256
Nov 24 '18 at 11:27
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
Storing data with comma separated is wrong practice. Thats why you are getting this problem.
– Niklesh Raut
Nov 24 '18 at 11:29
There is a long process by using mysql
find_in_set but i would suggest to make db proper instead code.– Niklesh Raut
Nov 24 '18 at 11:34
There is a long process by using mysql
find_in_set but i would suggest to make db proper instead code.– Niklesh Raut
Nov 24 '18 at 11:34
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f53456997%2ffetch-names-based-on-comma-separated-ids-using-laravel-relations%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
1
Share all details , what is your query? and how you are tring to do?
– Niklesh Raut
Nov 24 '18 at 9:53
updated my question plz check once.
– user3544256
Nov 24 '18 at 10:00
Where these users name are stored?
– Niklesh Raut
Nov 24 '18 at 11:08
names are stored in users table
– user3544256
Nov 24 '18 at 11:14
Did you try my answer ?
– Niklesh Raut
Nov 24 '18 at 11:16