duandi2853
2019-07-07 21:05
浏览 132
已采纳

PHP将mysql时间戳添加到现有时间戳

I have mysql timestamps named the following:

$end_time = $row['end_time'];
$paused_time = $row['paused_time'];
$current_time = date("Y-m-d H:i:s");

i need to get the difference between the current time and the paused time, then add that total to the end time.

Essentially what im trying to achieve is when an event is paused, it updates the $paused_time in the database, so when i resume again i need to add the time since it was paused to the end time which will increase it.

say i paused it 1 hour ago, the difference between $paused_time and $current_time is 1 hour, so $end_time will be $end_time + 1 hour which i will then update the database replacing the current end time.

Everything i try is such a mess and not really achieving my goal so i would appreciate how to go about doing this.

$datetime1 = new DateTime($paused_time);
$datetime2 = new DateTime($current_time);
$interval = $datetime1->diff($datetime2);
// add $interval to $end_time??

Many thanks and hope i explained it clear enough

  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

2条回答 默认 最新

相关推荐 更多相似问题