Laravel Query builder query equivalent to SQL query?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
My query is working fine only problem in this where clause. Please tell me what will query builder query in Laravel, equivalent to this query
WHERE (interest_request.sender_id = 6 or interest_request.to_user_id = 6)
AND interest_request.interest_status =2
and profiles.profile_id not in (6)
I am using following query builder but not working
where('to_user_id',$my_profile_id)->orwhere
('sender_id',$my_profile_id)->where('interest_status','2')
->whereNotIn('profiles.profile_id', $my_profile_id)
mysql laravel laravel-5 query-builder laravel-query-builder
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
add a comment |
My query is working fine only problem in this where clause. Please tell me what will query builder query in Laravel, equivalent to this query
WHERE (interest_request.sender_id = 6 or interest_request.to_user_id = 6)
AND interest_request.interest_status =2
and profiles.profile_id not in (6)
I am using following query builder but not working
where('to_user_id',$my_profile_id)->orwhere
('sender_id',$my_profile_id)->where('interest_status','2')
->whereNotIn('profiles.profile_id', $my_profile_id)
mysql laravel laravel-5 query-builder laravel-query-builder
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11
add a comment |
My query is working fine only problem in this where clause. Please tell me what will query builder query in Laravel, equivalent to this query
WHERE (interest_request.sender_id = 6 or interest_request.to_user_id = 6)
AND interest_request.interest_status =2
and profiles.profile_id not in (6)
I am using following query builder but not working
where('to_user_id',$my_profile_id)->orwhere
('sender_id',$my_profile_id)->where('interest_status','2')
->whereNotIn('profiles.profile_id', $my_profile_id)
mysql laravel laravel-5 query-builder laravel-query-builder
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
My query is working fine only problem in this where clause. Please tell me what will query builder query in Laravel, equivalent to this query
WHERE (interest_request.sender_id = 6 or interest_request.to_user_id = 6)
AND interest_request.interest_status =2
and profiles.profile_id not in (6)
I am using following query builder but not working
where('to_user_id',$my_profile_id)->orwhere
('sender_id',$my_profile_id)->where('interest_status','2')
->whereNotIn('profiles.profile_id', $my_profile_id)
mysql laravel laravel-5 query-builder laravel-query-builder
mysql laravel laravel-5 query-builder laravel-query-builder
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
edited Nov 16 '18 at 13:04
Zain Farooq
2,06121030
2,06121030
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
asked Nov 16 '18 at 12:08
EntrepreunerEntrepreuner
235
235
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11
add a comment |
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11
add a comment |
2 Answers
2
active
oldest
votes
In your particular case, you'll have to use a nested where clause:
->where(function ($query) use ($my_profile_id) {
$query->where('to_user_id', $my_profile_id)
->orWhere('sender_id', $my_profile_id);
})
->where('interest_status', 2)
->where('profile_id', '!=', $my_profile_id)
Also you don't need to use a whereIn (or whereNotIn) query if you have only one id in the list.
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
add a comment |
i would assume it will be the following in sql:
WHERE to_user_id = $my_profile_id
OR sender_id = $my_profile_id
AND interest_status = 2
AND profiles.profile_id NOT IN ($my_profile_id)
When i use orwhere() statements i use callback functions:
where(function($query) {$query->something})
->orwhere(function($query) {$query->otherOptions})
answered Nov 16 '18 at 12:14
Florian Florian
64
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
});
}
});
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%2f53337622%2flaravel-query-builder-query-equivalent-to-sql-query%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In your particular case, you'll have to use a nested where clause:
->where(function ($query) use ($my_profile_id) {
$query->where('to_user_id', $my_profile_id)
->orWhere('sender_id', $my_profile_id);
})
->where('interest_status', 2)
->where('profile_id', '!=', $my_profile_id)
Also you don't need to use a whereIn (or whereNotIn) query if you have only one id in the list.
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
add a comment |
In your particular case, you'll have to use a nested where clause:
->where(function ($query) use ($my_profile_id) {
$query->where('to_user_id', $my_profile_id)
->orWhere('sender_id', $my_profile_id);
})
->where('interest_status', 2)
->where('profile_id', '!=', $my_profile_id)
Also you don't need to use a whereIn (or whereNotIn) query if you have only one id in the list.
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
add a comment |
In your particular case, you'll have to use a nested where clause:
->where(function ($query) use ($my_profile_id) {
$query->where('to_user_id', $my_profile_id)
->orWhere('sender_id', $my_profile_id);
})
->where('interest_status', 2)
->where('profile_id', '!=', $my_profile_id)
Also you don't need to use a whereIn (or whereNotIn) query if you have only one id in the list.
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
In your particular case, you'll have to use a nested where clause:
->where(function ($query) use ($my_profile_id) {
$query->where('to_user_id', $my_profile_id)
->orWhere('sender_id', $my_profile_id);
})
->where('interest_status', 2)
->where('profile_id', '!=', $my_profile_id)
Also you don't need to use a whereIn (or whereNotIn) query if you have only one id in the list.
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
answered Nov 16 '18 at 12:13
NamoshekNamoshek
3,2272920
3,2272920
add a comment |
add a comment |
i would assume it will be the following in sql:
WHERE to_user_id = $my_profile_id
OR sender_id = $my_profile_id
AND interest_status = 2
AND profiles.profile_id NOT IN ($my_profile_id)
When i use orwhere() statements i use callback functions:
where(function($query) {$query->something})
->orwhere(function($query) {$query->otherOptions})
answered Nov 16 '18 at 12:14
Florian Florian
64
add a comment |
i would assume it will be the following in sql:
WHERE to_user_id = $my_profile_id
OR sender_id = $my_profile_id
AND interest_status = 2
AND profiles.profile_id NOT IN ($my_profile_id)
When i use orwhere() statements i use callback functions:
where(function($query) {$query->something})
->orwhere(function($query) {$query->otherOptions})
answered Nov 16 '18 at 12:14
Florian Florian
64
add a comment |
i would assume it will be the following in sql:
WHERE to_user_id = $my_profile_id
OR sender_id = $my_profile_id
AND interest_status = 2
AND profiles.profile_id NOT IN ($my_profile_id)
When i use orwhere() statements i use callback functions:
where(function($query) {$query->something})
->orwhere(function($query) {$query->otherOptions})
answered Nov 16 '18 at 12:14
Florian Florian
64
i would assume it will be the following in sql:
WHERE to_user_id = $my_profile_id
OR sender_id = $my_profile_id
AND interest_status = 2
AND profiles.profile_id NOT IN ($my_profile_id)
When i use orwhere() statements i use callback functions:
where(function($query) {$query->something})
->orwhere(function($query) {$query->otherOptions})
answered Nov 16 '18 at 12:14
Florian Florian
64
answered Nov 16 '18 at 12:14
Florian Florian
64
answered Nov 16 '18 at 12:14
Florian Florian
64
answered Nov 16 '18 at 12:14
Florian Florian
64
64
add a comment |
add a comment |
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%2f53337622%2flaravel-query-builder-query-equivalent-to-sql-query%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
instead posting only part post whole query please.
– Ram Bhandari
Nov 16 '18 at 12:11