我试图在我的数据库中使用我的Duration来自动获取两个时间戳(LeaveFrom和Leaveto)之间的差异,这两个时间戳在我的代码中是不同的格式。我有两个邮政变量间隔,以便第一个显示日期在sql格式和其他显示时间在sql格式。它的工作原理是,它们都显示为我的数据库中的Leaveto和LeaveFrom的时间戳。我希望duration变量在与其他变量一起插入数据库时,以小时为单位计算$begindate和$enddate之间的差异。这可能吗?有人能解释一下吗?
if(isset($_POST['LeaveRequest'])) { // checking that form is submitted
session_start(); //creating variables for form entries
$Enum = $_POST['Employeenumber'];
$fullname = $_POST['Leavename'];
$leavetype = $_POST['Leavetype'];
$begindate = $_POST['LeaveFrom'].' '.$_POST['BeginTime'];
$enddate = $_POST['Leaveto'].' '.$_POST['EndTime'];
$duration = (I dont know!!)
$unit = $_POST['Unit'];
$leavereason = $_POST['LeaveReason'];
$leavestatus = "Pending";
$supervisor = $_POST['Supervisor'];
$sql = $con->query("INSERT INTO Leave_details
(Employeenumber, Leavename, Leavetype, LeaveFrom, Leaveto,
Duration, Unitpick, LeaveReason, LeaveStatus, Supervisor)Values('{$Enum}',
'{$fullname}', '{$leavetype}', '{$begindate}', '{$enddate}' ,'{$duration}',
'{$unit}' , '{$leavereason}', '{$leavestatus}', '{$supervisor}')");
header('Location: Account.php');
可以使用DateTime
(如果您使用的日期格式是Y-m-d H:i:s
或类似的)
$begindate = new DateTime($_POST['LeaveFrom'].' '.$_POST['BeginTime']);
$enddate = new DateTime($_POST['Leaveto'].' '.$_POST['EndTime']);
$diff = $begindate->diff($enddate);
print_r($diff);
输出:DateInterval Object
(
[y] => 0
[m] => 0
[d] => 1
[h] => 0
[i] => 0
[s] => 0
[invert] => 1
[days] => 1
)
所以你可以用:
$diff->h