Get time difference & User Information using php

Question

Please, i need to get the time difference between a particular time and the current time. ie. I want to track users who submit an assignment late. the deadline time is 10:00AM everyday.I have surf,but all the solution i am seeing does not seems to work. see below:

<?php

   $d1 = new DateTime(date('Y-m-d 10:00:00'));//Deadline time
   $d2 = new DateTime(date('Y-m-d H:i:s'));//Submission time
   $interval = $d1->diff($d2);
   $c = $interval->minute;
   if($c>0){
  echo "submitted late";}else{ echo "Submitted on time";}
?>

Use `while loop` for fetching all email and for SELECT query use use `mysqli_num_rows()` to check number of rows return by your query — Saty, Aug 29 '16 at 12:21
@Saty: How shoudl i do this, becuase i know i can use: while($rw = mysqli_fetch_array($q){ }. How shoud i write such that it will return ALL as a single line even if i have to concatenate. Show me please — David Mukoro, Aug 29 '16 at 12:22
check http://php.net/manual/en/mysqli-result.fetch-assoc.php — Saty, Aug 29 '16 at 12:23
Just use one query for that `SELECT GROUP_CONCAT(emailadd) FROM table_email WHERE owner='Nelson'` — Saty, Aug 29 '16 at 12:31
http://stackoverflow.com/questions/961074/how-do-i-compare-two-datetime-objects-in-php-5-2-8 — u_mulder, Aug 29 '16 at 12:33
http://stackoverflow.com/questions/149772/how-to-use-group-by-to-concatenate-strings-in-mysql — u_mulder, Aug 29 '16 at 12:34

score 0 · Answer 1 · edited Aug 29 '16 at 12:48

Regarding the first point, your code doesn't work because $interval->minute is always positive. So you should simply compare two dates. Use the following code to achieve it:

    $d1 = new \DateTime(date('Y-m-d 10:00:00'));//Deadline time
    $d2 = new \DateTime(date('Y-m-d H:i:s'));//Submission time
    if($d1 < $d2) {
        echo "submitted late";
    } else { 
        echo "Submitted on time";
    }

Your Common Sense · Answer 2 · 2016-08-29T13:15:57.437

0

$deadline = date('10:00:00');
$now      = date('H:i:s');

if($now > $deadline){
    echo "submitted late";
} else { 
    echo "Submitted on time";
}

as simple as that

edited Aug 29 '16 at 13:15

answered Aug 29 '16 at 12:38

Your Common Sense

156,878
40
214
345

this code seems to work, but I think, since i am comparing the deadline time with the current time, it shoud be (current time>deadline time) echo Submitted late else Submitted on time. because it is given the same output of submitted late especially when you compare 9:30 with 10:00. what coudl be the issue? – David Mukoro Aug 29 '16 at 12:59
this is why you should geve meaningful names to variables - not to confuse them. Now it's clear – Your Common Sense Aug 29 '16 at 13:16
@So, what is the Solution:, as the time is still not working...,becuase, changing the time to 1 minue to 10am, still shows late submission. – David Mukoro Aug 29 '16 at 13:19
@Did you try changing your time like 9:25 and see the response? A it is showing the submission late here? Finally, how can i prevent users from changing their clock to lower time before submission? – David Mukoro Aug 29 '16 at 13:25
Users' clock has nothing to do with your server. the latter edited code in my answer shows the right message for the any time given – Your Common Sense Aug 29 '16 at 13:28

Get time difference & User Information using php

2 Answers2