从当前日期时间减去提取的日期时间 [英] Subtract fetched datetime from current date time

问题描述

我需要计算localDatetime和从我的数据库表（csv）中调用ReportedDateAndTime的特定行获取的日期时间之间的时间差。我搜索了很多解决方案，但它并不适用于我。显示当地时间从数据库获取的时间正在运行。但时差不行。这是我的代码到目前为止。请帮忙。感谢提前！

I need to calculate the time difference between the localDatetime and a Datetime fetched from a specific row in my database-table(csv) called ReportedDateAndTime. I searched a lots of solutions but it doesn't working for me. Displaying localtime & the fetched time from Database are working. But the time difference doesn't. Here is my code so far. Please help. Thanks in advance!

<?php

    include_once('connection.php');
    $sql="SELECT * FROM csv";
    $records=mysqli_query($conn, $sql);
    $date = new DateTime(null, new DateTimeZone('Asia/Colombo'));
    while ($csv=mysqli_fetch_assoc($records))
    {
    $exp = $csv['ReportedDateAndTime'];
    }
    $diff = $date->diff($exp);
    echo $diff->format('%H')

?>

推荐答案

幸运的是我找到了一个答案。 ：）

Thanks all. Fortunately I found an answer. :)

<?php
include 'connection.php';
date_default_timezone_set('Asia/Colombo');
$the_time = date('H:i');
echo $the_time." </br>";
$sql="SELECT ReportedDateAndTime FROM csv";
$result=$conn->query($sql);
while ($row = $result->fetch_assoc()) 
{
$new_time=$row['ReportedDateAndTime'];
echo "<br/>";
echo $new_time." ReportedDateAndTime</br>";
$datetime1 = new DateTime($the_time);
$datetime2 = new DateTime($new_time);
$interval = $datetime1->diff($datetime2);
$hours=$interval->format('%h');
$minutes= $interval->format('%i');
echo "<br/>";
echo $hours." Hours  ".$minutes."  Minutes</br></br>";
}
?>

这篇关于从当前日期时间减去提取的日期时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！