doushanmo7024 2014-03-20 22:34
浏览 6
已采纳

在单独的日/月/年部分显示新()数据?

I am using a now() code to enter just a date into the database. The date appears as Year/Month/Day (yyyy/mm/dd).

In my PHP code I have been using:

$news_date=$row['news_date'];

to recall the date on my site, I was wondering, instead of the date all showing at once, is there a way to add a separate value for day, month and year? So I could recall 'day' separate and so forth? Obviously without changing the database to have 3 different inputs, there must be an easier way? I am fairly new to PHP and MySQL so if someone could help me out with an example that would be handy! Thanks.

  • 写回答

1条回答 默认 最新

  • dongwei1921 2014-03-20 22:47
    关注

    PHP has a very powerful function called strtotime() that intuitively converts next to any datestamp into a UNIX-based timestamp, which you can then format any way you want.

    $news_timestamp = strtotime($row['news_date']);
    

    Now you can use PHP's date() function to output this timestamp in all sorts of ways.

    print 'Today is day number '.date('d', $news_timestamp); // 20
    print 'The month is '.date('F', $news_timestamp); // March
    print 'Post timestamp: '.date('l, F d, Y @ h:ia', $news_timestamp); // Thursday, March 20, 2014 @ 03:46pm
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 jupyterthemes 设置完毕后没有效果
  • ¥15 matlab图像高斯低通滤波
  • ¥15 针对曲面部件的制孔路径规划,大家有什么思路吗
  • ¥15 钢筋实图交点识别,机器视觉代码
  • ¥15 如何在Linux系统中,但是在window系统上idea里面可以正常运行?(相关搜索:jar包)
  • ¥50 400g qsfp 光模块iphy方案
  • ¥15 两块ADC0804用proteus仿真时,出现异常
  • ¥15 关于风控系统,如何去选择
  • ¥15 这款软件是什么?需要能满足我的需求
  • ¥15 SpringSecurityOauth2登陆前后request不一致