PHP How to find the number of day's before the event happen compare to current date

Question

How to find the number of day's before the event happen compare to current date , i having Linux time in my database i am converting the Linux to ordinary time like 2012-05-28 17:25:43,

i am tried like this its not working

   $sql_sms_transactions = "SELECT MAX(`sendtime`) FROM `sms_transaction`  where customer_id='$customer_id'";

    $result_sms_transactions = mysql_query($sql_sms_transactions);
    while($row2=mysql_fetch_assoc($result_sms_transactions))
{

    $status = $row2['MAX(`sendtime`)'];

    $timestamp2 = $status;


    $ptime= gmdate("Y-m-d H:i:s", $timestamp2);

 function time_elapsed_string($ptime)
  {
$etime = time() - $ptime;

if ($etime < 1)
{
    return '0 seconds';
}

$a = array( 12 * 30 * 24 * 60 * 60  =>  'year',
            30 * 24 * 60 * 60       =>  'month',
            24 * 60 * 60            =>  'day',
            60 * 60                 =>  'hour',
            60                      =>  'minute',
            1                       =>  'second'
            );

foreach ($a as $secs => $str)
{
    $d = $etime / $secs;
    if ($d >= 1)
    {
        $r = round($d);
        return $r . ' ' . $str . ($r > 1 ? 's' : '') . ' ago';
    }
}
     }

}

i want to compare this 2012-05-28 17:25:43 with current date (today) and find out how many days before it happens i want only days,

final out put text should be like xx Days Ago

Does anyone have a better solution or code thanks.....

@deceze it's not duplicate also its not calculating days properly,if you know the answer writeme — Xavi, Jun 17 '14 at 07:12
How's that not a duplicate? There's a great answer there: http://stackoverflow.com/a/3923228/476 — deceze, Jun 17 '14 at 07:13
i tried that codes its shows compare the current date and the date like this (17-06-2012) its shows 0years 16days do you think its write its just 16day — Xavi, Jun 17 '14 at 07:17
i pasted the code above ,it's inside the while loop each time its take date from database and compare the date display the result,unfortunately its not working — Xavi, Jun 17 '14 at 07:19
i tries its displays like this date like this (17-06-2012) its shows 1years 1days do you think its write its just 16day — Xavi, Jun 17 '14 at 07:20
Let us [continue this discussion in chat](http://chat.stackoverflow.com/rooms/55746/discussion-between-xavi-and-krishna). — Xavi, Jun 17 '14 at 07:23
i am getting like this $timestamp1 = time(); and converting it to ordinary date like this $date = gmdate("Y-m-d H:i:s", $timestamp1); — Xavi, Jun 17 '14 at 07:25
`$interval->format('%a')` - there's a difference between *days* as in "3 years, 2 months, 1 day" and *total days*. `'a'` is the *total days*. — deceze, Jun 17 '14 at 07:26
@ thanks for you code if you dont mind can you provide me an example so i can easily understand — Xavi, Jun 17 '14 at 07:28
Could you please take a look at chat link for the sample code. — krishna, Jun 17 '14 at 07:30
Please RTFM for examples: http://php.net/manual/en/dateinterval.format.php — deceze, Jun 17 '14 at 07:34
chat room is not opening for me it saying some error occurred — Xavi, Jun 17 '14 at 08:28

PHP How to find the number of day's before the event happen compare to current date

0 Answers0