Time Difference in PHP

Question

I am trying to create an attendance system.

On check out I call a function which updates attendance in database and calculate hours (Using Codeigniter)

public function updateAttendance($data,$id)
    {
    date_default_timezone_set('Asia/Karachi');
    $attendance=array(
        'check_in'=> $data['check_in'],
        'check_out'=> $data['check_out']
    );
    $this->db->WHERE('id',$id)->update('attendance',$attendance);
    $this->db->query('UPDATE attendance SET hours=(HOUR(TIMEDIFF(check_out,check_in))-1) WHERE DATE(date)=\''.date('Y-m-d').'\' and employee_id='.$id);
    return true;
}

I fetch my attendance by employee Id and render a view like this in employee's profile.

The problem is I am getting wrong calculation of hours, probably due to my query. Is there a fix by query or do I have to do keep time diff in time format and then add all of them at the end of month and then get hours out of it.

Answer 1

You can try this one...

$to_time = strtotime("2008-12-13 10:42:00");
$from_time = strtotime("2008-12-13 10:21:00");
echo round(abs($to_time - $from_time) / 60,2). " minute";

Answer 2

i think its better to use this function:

$ MY_TIME = strtotime('2017-01-04 23:12');

this line of code return this digits: 1483571520

you can doing operation on them

and you can return them to date format for saving in database with this function:

date('y-m-d H:i',$MY_TIME);