All data from mysql is not showing by php condition
0
$sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 ORDER BY `main`.`ID`, DATE(`main`.`time`) DESC";
this is my query I'm fetching all the data and trying to show them by php condition like this.
while ($table = mysqli_fetch_array($result)) {
echo strtotime($table['mrDate']) >= strtotime($from) && strtotime($table['mrDate']) <= strtotime($to);
}
but this is not showing all the data as I've more then 30k data....and I can just get half of the data from my database. and I'm also getting issues is I set the from date to Augest 1, 2018. After that this just provides me one month data even I've set the to date to November 1, 2018
php if-statement mysqli
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
|
show 3 more comments
0
$sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 ORDER BY `main`.`ID`, DATE(`main`.`time`) DESC";
this is my query I'm fetching all the data and trying to show them by php condition like this.
while ($table = mysqli_fetch_array($result)) {
echo strtotime($table['mrDate']) >= strtotime($from) && strtotime($table['mrDate']) <= strtotime($to);
}
but this is not showing all the data as I've more then 30k data....and I can just get half of the data from my database. and I'm also getting issues is I set the from date to Augest 1, 2018. After that this just provides me one month data even I've set the to date to November 1, 2018
php if-statement mysqli
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Are you sure you getting the right value in your SQL fromDATE(`main`.`time`)?
– Nigel Ren
Nov 21 '18 at 13:31
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37
|
show 3 more comments
0
0
0
$sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 ORDER BY `main`.`ID`, DATE(`main`.`time`) DESC";
this is my query I'm fetching all the data and trying to show them by php condition like this.
while ($table = mysqli_fetch_array($result)) {
echo strtotime($table['mrDate']) >= strtotime($from) && strtotime($table['mrDate']) <= strtotime($to);
}
but this is not showing all the data as I've more then 30k data....and I can just get half of the data from my database. and I'm also getting issues is I set the from date to Augest 1, 2018. After that this just provides me one month data even I've set the to date to November 1, 2018
php if-statement mysqli
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
$sqlforData = "SELECT *, `main`.`email` as useremail, `main`.`ID` as `userID`, `mail_owners`.`country_code_field` as `micountry`, DATE(`main`.`time`) as `mrDate` FROM `main` LEFT JOIN `mail_owners` ON `main`.`ID` = `mail_owners`.`ID` WHERE `main`.`is_deleted` = 0 ORDER BY `main`.`ID`, DATE(`main`.`time`) DESC";
this is my query I'm fetching all the data and trying to show them by php condition like this.
while ($table = mysqli_fetch_array($result)) {
echo strtotime($table['mrDate']) >= strtotime($from) && strtotime($table['mrDate']) <= strtotime($to);
}
but this is not showing all the data as I've more then 30k data....and I can just get half of the data from my database. and I'm also getting issues is I set the from date to Augest 1, 2018. After that this just provides me one month data even I've set the to date to November 1, 2018
php if-statement mysqli
php if-statement mysqli
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
asked Nov 21 '18 at 13:26
M.i. SujonM.i. Sujon
1125
1125
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Are you sure you getting the right value in your SQL fromDATE(`main`.`time`)?
– Nigel Ren
Nov 21 '18 at 13:31
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37
|
show 3 more comments
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Are you sure you getting the right value in your SQL fromDATE(`main`.`time`)?
– Nigel Ren
Nov 21 '18 at 13:31
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Are you sure you getting the right value in your SQL from
DATE(`main`.`time`)?– Nigel Ren
Nov 21 '18 at 13:31
Are you sure you getting the right value in your SQL from
DATE(`main`.`time`)?– Nigel Ren
Nov 21 '18 at 13:31
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37
|
show 3 more comments
0
active
oldest
votes
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%2f53413078%2fall-data-from-mysql-is-not-showing-by-php-condition%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f53413078%2fall-data-from-mysql-is-not-showing-by-php-condition%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
Have you run the query directly in MySQL? Are you getting a different result than you expect there? It might be a query structure issue, and not a PHP issue.
– Difster
Nov 21 '18 at 13:28
Are you sure you getting the right value in your SQL from
DATE(`main`.`time`)?– Nigel Ren
Nov 21 '18 at 13:31
yes...sure...I'm getting the write value from there. But that data not sorting by this php condition
– M.i. Sujon
Nov 21 '18 at 13:36
If you are just looking to get the records back between those dates, consider using MYSQL's BETWEEN
– Nigel Ren
Nov 21 '18 at 13:36
I've used that mysqli between...but that's not working. that's why I've used the php
– M.i. Sujon
Nov 21 '18 at 13:37