Get database records count from today 8am to tomorrow 8am in mysql using php [on hold]











up vote
1
down vote

favorite
1












I am trying to get data count from today 8am to tomorrow 8am for inserting the every shopping order count.



I tried below code



$tomorrow=strtotime('+1 day', strtotime('8:00 AM'));

$today=strtotime('8:00 AM');


Mysql query 



INSERT INTO tbl_order (user_id,sno,total,datetime)

VALUES('$userid',(SELECT count(user_id) from tbl_order o where o.datetime>=$today and o.datetime<$tomorrow)+1,'$total',time())


Since my variables are dynamic it won't work after end of the day. I need a method to check till 8 AM, It should take yesterday as $today variable and so on.



For eg: If i'm running on 2018-10-14



$today = 2018-10-14 8:00;

$tomorrow = 2018-10-15 8:00;


Till tomorrow 8AM i need the same values, after 8 AM it should



 $today = 2018-10-15 8:00; 

 $tomorrow = 2018-10-16 8:00;





php mysql







share|improve this question















put on hold as unclear what you're asking by Nick, Sadikhasan, EdChum, ADyson, Unheilig 19 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
    – Anupam Bhatt
    19 hours ago












  • Thanks.it didn't work.
    – Rahumathulla
    19 hours ago












  • You can add a if condition right? codeshare.io/aVe9J6
    – Jestin Sebastian
    18 hours ago

















up vote
1
down vote

favorite
1












I am trying to get data count from today 8am to tomorrow 8am for inserting the every shopping order count.



I tried below code



$tomorrow=strtotime('+1 day', strtotime('8:00 AM'));

$today=strtotime('8:00 AM');


Mysql query 



INSERT INTO tbl_order (user_id,sno,total,datetime)

VALUES('$userid',(SELECT count(user_id) from tbl_order o where o.datetime>=$today and o.datetime<$tomorrow)+1,'$total',time())


Since my variables are dynamic it won't work after end of the day. I need a method to check till 8 AM, It should take yesterday as $today variable and so on.



For eg: If i'm running on 2018-10-14



$today = 2018-10-14 8:00;

$tomorrow = 2018-10-15 8:00;


Till tomorrow 8AM i need the same values, after 8 AM it should



 $today = 2018-10-15 8:00; 

 $tomorrow = 2018-10-16 8:00;





php mysql







share|improve this question















put on hold as unclear what you're asking by Nick, Sadikhasan, EdChum, ADyson, Unheilig 19 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.















  • Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
    – Anupam Bhatt
    19 hours ago












  • Thanks.it didn't work.
    – Rahumathulla
    19 hours ago












  • You can add a if condition right? codeshare.io/aVe9J6
    – Jestin Sebastian
    18 hours ago















up vote
1
down vote

favorite
1









up vote
1
down vote

favorite
1






1





I am trying to get data count from today 8am to tomorrow 8am for inserting the every shopping order count.



I tried below code



$tomorrow=strtotime('+1 day', strtotime('8:00 AM'));

$today=strtotime('8:00 AM');


Mysql query 



INSERT INTO tbl_order (user_id,sno,total,datetime)

VALUES('$userid',(SELECT count(user_id) from tbl_order o where o.datetime>=$today and o.datetime<$tomorrow)+1,'$total',time())


Since my variables are dynamic it won't work after end of the day. I need a method to check till 8 AM, It should take yesterday as $today variable and so on.



For eg: If i'm running on 2018-10-14



$today = 2018-10-14 8:00;

$tomorrow = 2018-10-15 8:00;


Till tomorrow 8AM i need the same values, after 8 AM it should



 $today = 2018-10-15 8:00; 

 $tomorrow = 2018-10-16 8:00;





php mysql







share|improve this question















I am trying to get data count from today 8am to tomorrow 8am for inserting the every shopping order count.



I tried below code



$tomorrow=strtotime('+1 day', strtotime('8:00 AM'));

$today=strtotime('8:00 AM');


Mysql query 



INSERT INTO tbl_order (user_id,sno,total,datetime)

VALUES('$userid',(SELECT count(user_id) from tbl_order o where o.datetime>=$today and o.datetime<$tomorrow)+1,'$total',time())


Since my variables are dynamic it won't work after end of the day. I need a method to check till 8 AM, It should take yesterday as $today variable and so on.



For eg: If i'm running on 2018-10-14



$today = 2018-10-14 8:00;

$tomorrow = 2018-10-15 8:00;


Till tomorrow 8AM i need the same values, after 8 AM it should



 $today = 2018-10-15 8:00; 

 $tomorrow = 2018-10-16 8:00;





php mysql




php mysql






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited 18 hours ago

























asked 21 hours ago









Rahumathulla

62




62




put on hold as unclear what you're asking by Nick, Sadikhasan, EdChum, ADyson, Unheilig 19 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.






put on hold as unclear what you're asking by Nick, Sadikhasan, EdChum, ADyson, Unheilig 19 hours ago


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.














  • Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
    – Anupam Bhatt
    19 hours ago












  • Thanks.it didn't work.
    – Rahumathulla
    19 hours ago












  • You can add a if condition right? codeshare.io/aVe9J6
    – Jestin Sebastian
    18 hours ago




















  • Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
    – Anupam Bhatt
    19 hours ago












  • Thanks.it didn't work.
    – Rahumathulla
    19 hours ago












  • You can add a if condition right? codeshare.io/aVe9J6
    – Jestin Sebastian
    18 hours ago


















Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
– Anupam Bhatt
19 hours ago






Try this ----> where (CONVERT(created_at, DATETIME) BETWEEN '2018-10-11 08:00:00' and '2018-11-12 08:00:00')
– Anupam Bhatt
19 hours ago














Thanks.it didn't work.
– Rahumathulla
19 hours ago






Thanks.it didn't work.
– Rahumathulla
19 hours ago














You can add a if condition right? codeshare.io/aVe9J6
– Jestin Sebastian
18 hours ago






You can add a if condition right? codeshare.io/aVe9J6
– Jestin Sebastian
18 hours ago



















active

oldest

votes






















active

oldest

votes













active

oldest

votes









active

oldest

votes






active

oldest

votes

-

Popular posts from this blog

404 Error Contact Form 7 ajax form submitting

Image
0 The contact form does not work, and affects loading after one try. The chrome console shows the error message: POST http://example.com/wp-json/contact-form-7/v1/contact-forms/50/feedback 404 (Not Found) send @ jquery.js?ver=1.12.4:4 ajax @ jquery.js?ver=1.12.4:4 wpcf7.submit @ scripts.js?ver=5.0.3:346 (anonymous) @ scripts.js?ver=5.0.3:53 dispatch @ jquery.js?ver=1.12.4:3 r.handle @ jquery.js?ver=1.12.4:3 How to solve this issue? thanks in advance javascript wordpress contact-form-7 share | improve this question edited Jul 17 '18 at 5:39 Kiran Shahi 4,745 3 16 43 ...
Read more

How to know if a Active Directory user can login interactively

Image
1 I would like to know if and how is it possible to know if a AD user can login interactively (on a server) in a domain. I need to know if I can find it out using a LDAP search. Thanks. windows active-directory login user-permissions user-profile share | improve this question edited 1 hour ago yagmoth555 ♦ 11.6k 3 17 42 asked 1 hour ago Luigi Luigi 6 1 New contributor ...
Read more

Refactoring coordinates for Minecraft Pi buildings written in Python

Image
0 $begingroup$ I'm fairly new to coding and I wrote this script in Python for a house with a roof in Minecraft Pi. I've found different ways to write the coordinates to make the code base shorter, but I'm wondering if it is possible for me to refactor it any further so I don't have to list each coordinate line by line. import mcpi.minecraft as minecraft import mcpi.block as block mc = minecraft.Minecraft.create() p = mc.player.getTilePos() mc.setBlocks(p.x+1, p.y, p.z+1, #Main structure starting coordinates (DO NOT ALTER) p.x+19, p.y+4, p.z+6, #Structure size/coordinates (Alters cube size) block.STONE_BRICK) mc.setBlocks(p.x+2, p.y+1, p.z+2, #Hollowing out main structure interior p.x+18, p.y+3, p.z+5, block.AIR) mc.setBlocks(p.x, p.y...
Read more