how to get status of last order id in magento2 sql query?
i want to get last order id along with order status in magneto2, i use this query to extract it but the status is not extracting correct:
SELECT max(entity_id) , STATUS FROM sales_order
max entity id returns last order but the status of the last order is
returning wrong it's returning status of first order , please help me
to correct my sql query.
i am using this code in magento2 api:
$con = mysqli_connect("localhost","root","","development_v2");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
$sql2 = "SELECT max(entity_id) and status FROM sales_order";
$result_set2 = mysqli_query($con,$sql2);
if ($result_set2) {
$rowB = mysqli_fetch_array($result_set2);
$hamza = $rowB['max(entity_id)'];
// echo $hamza;
} else {
echo 'No latest order';
}
mysqli_close($con);
}
magento2 collection sales-order sql
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
add a comment |
i want to get last order id along with order status in magneto2, i use this query to extract it but the status is not extracting correct:
SELECT max(entity_id) , STATUS FROM sales_order
max entity id returns last order but the status of the last order is
returning wrong it's returning status of first order , please help me
to correct my sql query.
i am using this code in magento2 api:
$con = mysqli_connect("localhost","root","","development_v2");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
$sql2 = "SELECT max(entity_id) and status FROM sales_order";
$result_set2 = mysqli_query($con,$sql2);
if ($result_set2) {
$rowB = mysqli_fetch_array($result_set2);
$hamza = $rowB['max(entity_id)'];
// echo $hamza;
} else {
echo 'No latest order';
}
mysqli_close($con);
}
magento2 collection sales-order sql
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
add a comment |
i want to get last order id along with order status in magneto2, i use this query to extract it but the status is not extracting correct:
SELECT max(entity_id) , STATUS FROM sales_order
max entity id returns last order but the status of the last order is
returning wrong it's returning status of first order , please help me
to correct my sql query.
i am using this code in magento2 api:
$con = mysqli_connect("localhost","root","","development_v2");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
$sql2 = "SELECT max(entity_id) and status FROM sales_order";
$result_set2 = mysqli_query($con,$sql2);
if ($result_set2) {
$rowB = mysqli_fetch_array($result_set2);
$hamza = $rowB['max(entity_id)'];
// echo $hamza;
} else {
echo 'No latest order';
}
mysqli_close($con);
}
magento2 collection sales-order sql
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
i want to get last order id along with order status in magneto2, i use this query to extract it but the status is not extracting correct:
SELECT max(entity_id) , STATUS FROM sales_order
max entity id returns last order but the status of the last order is
returning wrong it's returning status of first order , please help me
to correct my sql query.
i am using this code in magento2 api:
$con = mysqli_connect("localhost","root","","development_v2");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
else{
$sql2 = "SELECT max(entity_id) and status FROM sales_order";
$result_set2 = mysqli_query($con,$sql2);
if ($result_set2) {
$rowB = mysqli_fetch_array($result_set2);
$hamza = $rowB['max(entity_id)'];
// echo $hamza;
} else {
echo 'No latest order';
}
mysqli_close($con);
}
magento2 collection sales-order sql
magento2 collection sales-order sql
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
edited Mar 5 '18 at 9:29
Amit Bera♦
57.2k1374170
57.2k1374170
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
asked Mar 5 '18 at 8:02
Hamza Mustafa
15614
15614
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Change your query like this,
SELECT entity_id and status FROM sales_order ORDER BY entity_id DESC LIMIT 1;
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
add a comment |
Load order collection by increment id desc,
on collection
$colletion->getFirstItem()->getData();
This may help.
edited yesterday
Community♦
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "479"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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%2fmagento.stackexchange.com%2fquestions%2f215935%2fhow-to-get-status-of-last-order-id-in-magento2-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
Change your query like this,
SELECT entity_id and status FROM sales_order ORDER BY entity_id DESC LIMIT 1;
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
add a comment |
Change your query like this,
SELECT entity_id and status FROM sales_order ORDER BY entity_id DESC LIMIT 1;
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
add a comment |
Change your query like this,
SELECT entity_id and status FROM sales_order ORDER BY entity_id DESC LIMIT 1;
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
Change your query like this,
SELECT entity_id and status FROM sales_order ORDER BY entity_id DESC LIMIT 1;
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
answered Mar 5 '18 at 8:14
Keyur Shah
12.8k23764
12.8k23764
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
add a comment |
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
SELECT entity_id , STATUS FROM sales_order ORDER BY entity_id DESC LIMIT 1;
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
this querey worked for me thanks
– Hamza Mustafa
Mar 5 '18 at 8:17
add a comment |
Load order collection by increment id desc,
on collection
$colletion->getFirstItem()->getData();
This may help.
edited yesterday
Community♦
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
add a comment |
Load order collection by increment id desc,
on collection
$colletion->getFirstItem()->getData();
This may help.
edited yesterday
Community♦
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
add a comment |
Load order collection by increment id desc,
on collection
$colletion->getFirstItem()->getData();
This may help.
edited yesterday
Community♦
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
Load order collection by increment id desc,
on collection
$colletion->getFirstItem()->getData();
This may help.
edited yesterday
Community♦
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
edited yesterday
Community♦
1
edited yesterday
Community♦
1
edited yesterday
Community♦
1
1
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
answered Mar 5 '18 at 8:12
padhiyar gaurang
541314
541314
add a comment |
add a comment |
Thanks for contributing an answer to Magento Stack Exchange!
- 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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2fmagento.stackexchange.com%2fquestions%2f215935%2fhow-to-get-status-of-last-order-id-in-magento2-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
