PHP date_diff() using variables from a database

Question

I have tried to get this date diff function working all night now, its fine until i feed it my two variables.

What am I doing wrong ?

<h2>Date diff attempt</h2>
    <?php
    $z = $row->account_add_date;
    $y = $row->start_amount;

    $date1=date_create($z);
    $date2=date_create($y);
    $diff=date_diff($date1,$date2);
    echo $diff->format('%d days');
    ?>

When I run it I get

Severity: Warning

Message: date_diff() expects parameter 2 to be DateTime, boolean given

what is this $row->start_amount give?. Is this a date from database? — Gopalakrishnan, Mar 03 '16 at 03:59
Its from a query above to get the variable from the database — Beep, Mar 03 '16 at 04:00
Message means thant your "$z = $row->account_add_date; $y = $row->start_amount;" is not Date time. — Jakir Hossain, Mar 03 '16 at 04:00
make sure this will return a date and this will help you see it. http://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php — Gopalakrishnan, Mar 03 '16 at 04:02
@JakirHossain in the database they were date originally, but I have since change the database structure to be date time. I will try to insert new data see if it helps — Beep, Mar 03 '16 at 04:02
When you print/dump $z and $y, what do you get? It seems you have an error when try to create `$date2=date_create($y);` . date_create or new DateTime return false if error. You should see what the value of your variable $y. — olibiaz, Mar 03 '16 at 04:14
One sec, I seem to got something working. but its the wrong difference, but that may be a formatting problem — Beep, Mar 03 '16 at 04:18
@VadivelS you are a life saver ... its 4.19 am, sorry guys i put start_amount not start_time — Beep, Mar 03 '16 at 04:20
@Beep: see [DateInterval format](http://php.net/manual/en/dateinterval.format.php). You are probably mixing this format with [date format](http://php.net/manual/en/function.date.php). — Glavić, Mar 03 '16 at 14:48

score 0 · Answer 1 · answered Mar 03 '16 at 04:13

0

Try this one.

$date1 = $row->account_add_date;
$date2 =$row->start_amount;    
$date1 = new DateTime($date1);
$date2 = new DateTime($date2);

echo $date1->diff($date2)->format("%d days, %h hours and %i minuts");

answered Mar 03 '16 at 04:13

Gopalakrishnan

957
8
19

http://stackoverflow.com/questions/24608529/date-diff-expects-parameter-1-to-be-datetimeinterface-string-given – Jakir Hossain Mar 03 '16 at 04:14

score 0 · Accepted Answer · answered Mar 03 '16 at 04:20

0

It is working properly, I thing there is some problem in your $row->account_add_date and $row->start_amount

<h2>Date diff attempt</h2>
<?php
$z = "2013-03-15";
$y = "2013-03-31";

$date1=date_create($z);
$date2=date_create($y);
$diff=date_diff($date1,$date2);
echo $diff->format('%d days');
?>

answered Mar 03 '16 at 04:20

SAUMYA

1,508
1
13
20

Yes there was, i put start_amount not start_date my bad. thanks guys – Beep Mar 03 '16 at 04:24

PHP date_diff() using variables from a database

2 Answers2