我想以hh:mm:ss格式计算两个strtotime DATETIME/S之间的时间差.
这是WordPress项目.(PHP)
$target_time = strtotime($quiz_date . " 08:30 PM"); // Quiz Start time
$submitted_time = strtotime('now'); // submitted time
$time = gmdate('H:i:s', ($submitted_time - $target_time)); // difference in hh:mm:ss
我还设置了所需的默认时区.
这些是处理表单时的日期时间.
2023-08-29 20:30:00
2023-08-31 19:00:00
它将这个插入为Time 22:30:00
稍后我会将‘hh:mm:ss’格式的差异插入到MySQL中.
$query = "INSERT INTO Results (user_id, Time) VALUES (" . $user_id . " , " . $time . ");" ;
对我来说，解决这个问题的最好方法是:
$quiz_date = date('Y-m-d', strtotime($quiz_date)) . " 08:30 PM";
$target_time = strtotime($quiz_date);
$submitted_time = time();
$time_difference = $submitted_time - $target_time;
$hours = floor($time_difference / 3600);
$minutes = floor(($time_difference % 3600) / 60);
$seconds = $time_difference % 60;
$time_diff_formatted = sprintf('%02d:%02d:%02d', $hours, $minutes, $seconds);
我想，我的 idea 很清楚，我只是将$Time_Difference转换为小时、分钟和秒！这样，您就有了MySQL查询所需的变量！
祝好运!