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