PHP getting TIME difference in hours and minutes format

Question

I'm currently new to PHP , and I am stuck on this problem. I cant seem to subtract the TIME IN from employee SCHEDULE

function update_dtr($rs) {

    foreach ($rs as $key => $value) {

        $db=new Database ();
        $db->connect();

        //date_default_timezone_set('Asia/Ho_Chi_Minh');
        $empShift = $db->select(array('myilogin_46.DATE_TIME_RECORDS'),'SHIFT_START'
        ,"ID = '".$id."' and R_STATUS = 'A'");

      
        $sched= strtotime($empshift);
        $alterin = strtotime($value['alterIN']);
        if($sched>$alterin){
            $late= strtotime("00:00:00");

        }else{
            //subtract Alterin by the scedule so i can get late in hours and minutes format
            $late = $alterin - $sched;
        }

        $db->update_imp('myilogin_46.DATE_TIME_RECORDS',array(
                'date_in'=>date('Y-m-d',strtotime($value['alterIN']))
                ,'time_in_info'=>'ALTERED IN'
                ,'time_out_info'=>'ALTERED OUT' 
                ,'time_in'=>date('H:i',strtotime($value['alterIN']))
                ,'time_out'=>date('H:i',strtotime($value['alterOUT']))
                ,'date_out'=>date('Y-m-d',strtotime($value['alterOUT']))
                ,'late'=>gmdate('H:i',strtotime($late))
        ),"id = '".$value['dtrID']."' and id_emp = '".$value['empID']."' and R_STATUS = 'A'");
        $db->disconnect();

PS: I also tried date_diff method, but it doesn't work on me. THis is what my database looks like

This may help: https://stackoverflow.com/questions/24936855/get-time-difference-in-hours-minutes-and-seconds — Sanjeev, Jun 16 '21 at 06:19
Tried all the methods in the link, you have given, still didnt work. I got this error in the console. Catchable fatal error: Object of class DateInterval could not be converted to string in /var/www/43_alteration/classes/cls.db.php on line 419 — DarkChocolate Reborn, Jun 16 '21 at 06:34
in which column you want the difference and in which format you want it? — Muhammad Asif, Jun 16 '21 at 07:16
,'late'=>gmdate('H:i',strtotime($late)) I called it here. I want the format to be H:i:s ("00:00:00") the same format as my database. — DarkChocolate Reborn, Jun 16 '21 at 07:30
So as per column the highlighted field in above pic the result should be like 00:02:00 this. right? — Muhammad Asif, Jun 16 '21 at 07:36

Muhammad Asif · Answer 1 · 2021-06-16T09:01:07.940

just use the below function with edited code of yours, also have updated it with additional updates in my function.

function update_dtr($rs) {

    foreach ($rs as $key => $value) {

        $db=new Database ();
        $db->connect();

        //date_default_timezone_set('Asia/Ho_Chi_Minh');
        $empShift = $db->select(array('myilogin_46.DATE_TIME_RECORDS'),'SHIFT_START'
        ,"ID = '".$id."' and R_STATUS = 'A'");

      
        $sched= strtotime($empshift);
        $alterin = strtotime($value['alterIN']);
        if($sched>$alterin){
            $late= strtotime("00:00:00");

        }else{
            //subtract Alterin by the scedule so i can get late in hours and minutes format
            $late = datediff($alterin,$sched);
        }

        $db->update_imp('myilogin_46.DATE_TIME_RECORDS',array(
                'date_in'=>date('Y-m-d',strtotime($value['alterIN']))
                ,'time_in_info'=>'ALTERED IN'
                ,'time_out_info'=>'ALTERED OUT' 
                ,'time_in'=>date('H:i',strtotime($value['alterIN']))
                ,'time_out'=>date('H:i',strtotime($value['alterOUT']))
                ,'date_out'=>date('Y-m-d',strtotime($value['alterOUT']))
                ,'late'=>$late
        ),"id = '".$value['dtrID']."' and id_emp = '".$value['empID']."' and R_STATUS = 'A'");
        $db->disconnect();
        
        
        
 function datediff($d1,$d2) 
    {       
    $date1 = new DateTime($d1); 
    $date2=$date1->format('%H:%I:%S');
    $date2 = $date1->diff(new DateTime($d2));   
    return $date2->format('%H:%I:%S');
    }

Thanks my dudes, ill tweak this function, and ill update you if this worksout. Thank you so much. — DarkChocolate Reborn, Jun 16 '21 at 08:37
you are welcome, just use it and if needed you can convert it to strtotime upon insertion to databases. — Muhammad Asif, Jun 16 '21 at 08:44

score 0 · Answer 2 · answered Jun 17 '21 at 09:09

0

It turns out $empshift is not returned as time datatype. When i echoed it , it return the sql query as string itself. So i asked another questioned here: PHP echoed variable returns a mysql query string

answered Jun 17 '21 at 09:09

DarkChocolate Reborn

43
8

score 0 · Accepted Answer · answered Jun 22 '21 at 01:25

I got the answer, i did it like this. Example: shiftstart 08:30:00AM and timein= 8:34:00 AM

function update_dtr($rs) {
    foreach ($rs as $key => $value) {
      $db=new Database();
     $db->connect();
        
     $alterin= date('H:i:s', strtotime($value['alterIN']));
        

     $db->select(array('myilogin_46.DATE_TIME_RECORDS'),'SHIFT_START'
        ,"ID = '".$value['dtrID']."' and ID_EMP = '".$value['empID']."' and 
        R_STATUS='A'");

        foreach ($db->getResult() as $key => $value) {

            $shiftstart1 = $value['SHIFT_START'];




            $shiftstart= date('H:i:s',strtotime($shiftstart1));  
             
         }                
                var_dump($shiftstart);
                var_dump($alterin> $shiftstart);
                    var_dump($alterin);
                //working condition 
                if($shiftstart >= $alterin){
      
                $late= date('H:i:s',strtotime('00:00:00'));

                }else{
                    
                    $late1=strtotime($alterin)-strtotime($shiftstart);
                $late= gmdate('H:i:s', ($late1));
                
                }
                // $db->disconnect();   
                    echo $late;
                    echo date('H:i:s',strtotime($late));
                    var_dump(date('H:i:s',strtotime($late)));
      }

}

OUTPUT SHOULD BE LIKE THIS: 00:04:00

PHP getting TIME difference in hours and minutes format

3 Answers3