doushanmo7024
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
    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
    
    点赞 评论

相关推荐