Php日期从数据库信息中添加一天

Question

I have this line of code:

<?= date('F dS, Y',$user_info['date_of_birth']) ?>

It gets the unix birtday date per user and converts it in a normal date. The only problem is that it will show one day earlier. For example, the unix date in the database is 11th may 1990. In the view it will output, 10th may 1990. Do you know how to fix this issue?

Thanks in advance

Answer 1

To explicitly answer your question, you can do the following:

<?=date('F dS, Y',($user_info['date_of_birth'] + 86400))?>

Where 86400 is the number of seconds in a day.

---

However, as others suggested, you can and should sync up the database and Php to UTC/GMT time.

For Php timezone, do the following at top of your scripts:

date_default_timezone_set('UTC');

For SQL, that depends on the database you're using (I don't believe you specified the database you're using).