PHP: Days, hours and minutes left to a certain date?

Question

I'm trying to get remaining Days, hours and minutes to a certain date using php.

However i get a very strange output from my code which looks like this:

-16828 days and -11 hours and -21 minutes and -24 seconds

The future dates are stored in the mysql database in this format:

29/01/2016 7pm

So I went ahead and done this:

$Draw_time = "29/01/2016 7pm";

$date = $Draw_time;
$timestamp = strtotime($date);
$new_date = date('Y-m-d a',$timestamp );

$seconds = strtotime($new_date) - time();

$days = floor($seconds / 86400);
$seconds %= 86400;

$hours = floor($seconds / 3600);
$seconds %= 3600;

$minutes = floor($seconds / 60);
$seconds %= 60;


echo "$days days and $hours hours and $minutes minutes and $seconds seconds";

But when i run this code, I get the above strange output!

I understand that this could be because of a number reasons but the only thing i could think of is the fact that I am using a in my format?

Could someone please advise on this issue?

Possible duplicate of [PHP Countdown to Date](http://stackoverflow.com/questions/1735252/php-countdown-to-date) — kamal pal, Jan 27 '16 at 10:27
Possible duplicate of [Strtotime() doesn't work with dd/mm/YYYY format](http://stackoverflow.com/questions/2891937/strtotime-doesnt-work-with-dd-mm-yyyy-format) — AleFranz, Jan 27 '16 at 10:27
Which kind of mysql are you using that stores `29/01/2016 7pm` as date? :) — Mr. Engineer, Jan 27 '16 at 10:31
@Mr.Engineer, the mysql data being inserted from a CSV file. so whatever is in the CSV file, would be in the mysql database as well. — rooz, Jan 27 '16 at 10:32
@rooz what kind of output or date or time format do you want? — jameshwart lopez, Jan 27 '16 at 10:33
@jameshwartlopez, i was trying to get an output in this format.. example: `2 days 3 hours 4 minutes 30 seconds` — rooz, Jan 27 '16 at 10:36
@Mr.Engineer, this really isn't a "date" as it is a string from a CSV file as I mentioned before. — rooz, Jan 27 '16 at 10:38
@rooz [http://stackoverflow.com/a/32499148/2899618](http://stackoverflow.com/a/32499148/2899618) answer — Narendrasingh Sisodia, Jan 27 '16 at 17:22

score 4 · Accepted Answer · answered Jan 27 '16 at 10:44

4

Simply use DateTime class like as

$Draw_time = "29/01/2016 7pm";

$date = DateTime::createFromFormat("d/m/Y ha",$Draw_time);
$date2 = new DateTime();

echo $diff = $date2->diff($date)->format("%a days and %H hours and %i minutes and %s seconds");

answered Jan 27 '16 at 10:44

Narendrasingh Sisodia

21,247
6
47
54

score 0 · Answer 2 · answered Jan 27 '16 at 10:44

Try this

<?php 

    $Draw_time = str_replace('/', '-', "29/01/2016 7pm");

    $now = new DateTime();

    $futureDate = new DateTime($Draw_time);

    $interval = $futureDate->diff($now);
    echo $interval->format("%a days %h hours %i minutes %s seconds");
?>

pratik · Answer 3 · 2016-01-27T12:00:38.637

Try this.

$draw_time = "2016/01/29 7pm";
$date_time = explode(" ", $draw_time);// make separate date and time in array
$date = strtotime($date_time[0]); // convert your date(2016/01/29) into php time
$time = strtotime($date_time[1]); // convert your time(7pm) into php time
$date = $date + $time; // make total time to count
$new_Date = $date - (time()); // convert into difference from current time
$day = $new_Date % 86400;
$hrs = $new_Date % 3600;
$min = $new_Date % 60;
echo "Day= ".(date("d",$day));
echo " Hours= ".(date("h",$hrs));
echo " Minutes= ".(date("i",$min));

PHP: Days, hours and minutes left to a certain date?

3 Answers3