time() 函数数学

发布于 2024-12-11 09:52:48 字数 979 浏览 0 评论 0原文

我正在使用 time() 将日期存储在数据库中。我有某种广告网站。用户提交他们的广告以及他们希望展示广告的天数，例如：

标题：广告标题....
持续时间：20天
创建日期：time()（当我在数据库上提交此广告。）

我需要计算每个广告的纪元格式的到期日期。

exp_date = creation date + 20 days ; /// this line is hypothetical , i need correct way to calculate exp_Date
sql->set(experation date = exp_date);

我还需要知道距离到期日期还剩多少时间（以天、小时和分钟为单位），并将其显示在页面上。

    $current time = time();
    $remaining_time = $current time - $exp date ; //this line is hypothetical , i need correct way to calculate remaining_time
    echo 'remaining time : '.$remaining_time ;

最后我不想显示过期的广告（我不确定最好的方法是计算我显示广告的时间，也许我可以在 20 天后自动禁用广告状态？）

    current date = time();
    if (ads experation date > current date ) // this line is hypothetical , i need to calculate this 
    sql->update ('set ads status= 0');
    echo 'this ad has been expires ';
    exit;

原文

I'm using time() to store date in the database.
I have some kind of advertising web site.
Users submit their ads and number of the days they want their ads to be shown for example:

title : ad title....
duration : 20 days
creation date : time() (I get the creation date by time() when I'm
submitting this ad on the database. )

I need to calculate expiration date for each ad on epoch format.

exp_date = creation date + 20 days ; /// this line is hypothetical , i need correct way to calculate exp_Date
sql->set(experation date = exp_date);

Also I need to know how much time is left to the exp date in days and hours and minutes and show it on the page.

    $current time = time();
    $remaining_time = $current time - $exp date ; //this line is hypothetical , i need correct way to calculate remaining_time
    echo 'remaining time : '.$remaining_time ;

At last I don't want to show expired ads (I'm not sure the best way to do this is to calculate time when I'm showing the ads maybe I could somehow automatically disable ads status after 20 days?)

    current date = time();
    if (ads experation date > current date ) // this line is hypothetical , i need to calculate this 
    sql->update ('set ads status= 0');
    echo 'this ad has been expires ';
    exit;

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

享受孤独 2024-12-18 09:52:48

计算到期日期：

$expiration = time() + 1728000; // 1728000 = 20 * 24 * 60 * 60 (20 days)

要计算剩余时间，您应该执行类似

$currentTime = time();
$seconds = $expiration - $currentTime;

$daysLeft = (int)($seconds / 86400); // 86400 = 24*60*60 (seconds in one day)
$seconds -= $daysLeft * 86400;
$hoursLeft = (int)($seconds / 3600); // 3600 = 60*60 (seconds in one hour)
$seconds -= $hoursLeft * 3600;
$minutesLeft = (int)($seconds / 60); // seconds in one minute
$seconds -= $minutesLeft * 60;

$daysLeft、$hoursLeft、$minesLeft 和 的操作$seconds 是您想要的值

To calculate the expiration date:

$expiration = time() + 1728000; // 1728000 = 20 * 24 * 60 * 60 (20 days)

To calculate the time left, you should do something like

$currentTime = time();
$seconds = $expiration - $currentTime;

$daysLeft = (int)($seconds / 86400); // 86400 = 24*60*60 (seconds in one day)
$seconds -= $daysLeft * 86400;
$hoursLeft = (int)($seconds / 3600); // 3600 = 60*60 (seconds in one hour)
$seconds -= $hoursLeft * 3600;
$minutesLeft = (int)($seconds / 60); // seconds in one minute
$seconds -= $minutesLeft * 60;

$daysLeft, $hoursLeft, $minutesLeft and $seconds are the values that you want

回复收藏 0 原文