如何使用php和mysql计算发布广告的时间？

Question

大家好，有没有人能告诉我怎样才能计算一篇在线帖子的时间。意味着我有一个广告发布的网站，我想统计一下我如何计算广告发布的在线时间，比如

2天过去的广告在线3天过去的广告是在线的

下面是一个http://www.buyandsell.ie/motors/classic-cars/kerry/head-gasket-sealer-3示例

你可以在这个网站上看到，在线时间是广告发布后的9天。

Answer 1

假设你已经在圣诞节上发布了一则广告。日期在mysql中保存为2012-12-25。现在，您想要显示其已发布的天数。像这样使用DateTime，DateInterval类。

$d = DateTime::createFromFormat("Y-m-d", "2012-12-25");
$interval = $d->diff(new DateTime());
echo $interval->format("%a days"); // echos '6 days'

查看更多code in action

Answer 2

<?php

//time() will give current time and
//$time will have the time from database when the post was posted on your site.
$time_difference = time() - $time ;

//calculate the difference and show accordingly.
$seconds = $time_difference ;
$minutes = round($time_difference / 60 );
$hours = round($time_difference / 3600 );
$days = round($time_difference / 86400 );
$weeks = round($time_difference / 604800 );
$months = round($time_difference / 2419200 );
$years = round($time_difference / 29030400 );
if($seconds <= 60)
{
    echo "<font id='big'>a few seconds ago</font>";
}
//Minutes
else if($minutes <=60)
{
    if ($minutes==1) {
        echo "1 minute ago";
    }
    else {
        echo $minutes." minutes ago";
    }
}
else if($hours <=24) {
    if ($hours==1) {
        echo "1 hour ago";
    }
    else {
        echo $hours." hours ago";
    }
}
else if($days <= 7)
{
    if ($days==1) {
        echo "Yesterday";
    }
    else {
        echo $days." days ago";
    }
}
else if($weeks <= 4)
{
    if ($weeks==1) {
        echo "1 week ago";
    }
    else {
        echo $weeks." weeks ago";
    }
}
else if($months <=12)
{
    if ($months==1) {
        echo "1 month ago";
    }
    else {
        echo $months." months ago";
    }
}
else
{
    if ($years==1) {
        echo "1 year ago";
    }
    else {
        echo $years." years ago";
   }
}
?>