无法将此差异插入表中 - cant insert the difference of this into table

cant insert the difference of this into table

本文关键字：插入 | 更新日期: 2023-09-27

这是我的插入部分，$total_分钟和$total_小时不能插入表格

$year = $_POST['year'];  
$month = $_POST['month'];  
$day = $_POST['day'];  
$hour = $_POST['hour'];  
$min = $_POST['min'];  
$sec = $_POST['sec'];  
$year1 = $_POST['year1'];  
$month1 = $_POST['month1'];  
$day1 = $_POST['day1'];  
$hour1 = $_POST['hour1'];  
$min1 = $_POST['min1'];  
$sec1 = $_POST['sec1'];  
$time_in = $year.'-'.$month.'-'.$day.' '.$hour.'-'.$min.'-'.$sec;  
$time_out = $year1.'-'.$month1.'-'.$day1.' '.$hour1.'-'.$min1.'-'.$sec1;
$total_minutes = $total_min;
$total_hour = $total_hr;
$sql = "INSERT INTO time (year, month, day, hour, min, sec, year1, month1, day1, hour1, min1, sec1, time_in, time_out, total_minutes, total_hour)
    VALUES
    ('$year','$month','$day','$hour','$min','$sec','$year1','$month1','$day1','$hour1','$min1','$sec1','$time_in','$time_out', '$total_minutes', '$total_hour')";

如何在我的表格中添加它？

纪要

    $datetime1 = strtotime($row['time_in']); //year-month-day hr:min:sec timein  
$datetime2 = strtotime($row['time_out']); //year-month-day hr:min:sec timeout  
$interval = abs($datetime2 - $datetime1);  
$total_min = round($interval / 60);  
$total_minutes = $total_min;

小时

function convertToHoursMins($total_minutes, $format = '%02d:%02d') {
    if ($total_minutes < 1) {
        return;
    }
    $hours = floor($total_minutes / 60);
    $wmin = ($total_minutes % 60);
    return sprintf($format, $hours, $wmin);
}
$total_hr = convertToHoursMins($total_minutes, '%02d hours %02d minutes');
$total_hour = $total_hr;

我是新的，我想要一个简单的答案

使用 MySQL TIMEDIFF（）函数来获取答案。MySQL 函数不是 PHP，而是以非常简单的方式给出结果。

$datetime1 = strtotime($row['time_in']); //year-month-day hr:min:sec timein  
$datetime2 = strtotime($row['time_out']); //year-month-day hr:min:sec timeout  
$timeInterval = mysql_query("SELECT TIMEDIFF($datetime2, $datetime1)");
$timeArray = explode(":", $timeInterval);

希望这可以帮助您:)

您必须先以这种格式转换日期时间1和日期时间2：

datetime1 =   2012-01-01   12:00:00;
datetime2 =   2012-01-02   13:00:00;

然后在我的sql插入查询中直接从以下函数中插入值：

TIMESTAMPDIFF（HOUR， datetime2， datetime1）//用于小时计算时间戳差异（分钟，日期时间2，日期时间1）//用于分钟计算

希望这可以帮助您:)