如何在表中显示日期明智的mysql数据

Question

I want to show machine maintenance table in my project ,currently i'm displaying all the data in single table, but now i want to display table in date wise .

SELECT * ,DATE_FORMAT(date,'%Y-%m-%d') as groupdate,SUM(operationtime) as usetime  FROM `logusages` WHERE machineid = '$id' GROUP BY groupdate,empCode"

Output of Query =

Array
(
    [workingLogs] => Array
        (
            [0] => stdClass Object
                (
                    [id] => 13
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1003
                    [employeeid] => Jon Doe
                    [date] => 2016-03-21 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-21
                    [usetime] => 1800
                )

            [1] => stdClass Object
                (
                    [id] => 14
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1003
                    [employeeid] => Jon Doe
                    [date] => 2016-03-22 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-22
                    [usetime] => 1800
                )

            [2] => stdClass Object
                (
                    [id] => 8
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1004
                    [employeeid] => Jon Doe
                    [date] => 2016-03-22 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-22
                    [usetime] => 1800
                )

            [3] => stdClass Object
                (
                    [id] => 15
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1003
                    [employeeid] => Jon Doe
                    [date] => 2016-03-23 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-23
                    [usetime] => 3600
                )

            [4] => stdClass Object
                (
                    [id] => 9
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1004
                    [employeeid] => Jon Doe
                    [date] => 2016-03-23 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-23
                    [usetime] => 3600
                )

            [5] => stdClass Object
                (
                    [id] => 12
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1003
                    [employeeid] => Jon Doe
                    [date] => 2016-03-25 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-25
                    [usetime] => 1800
                )

            [6] => stdClass Object
                (
                    [id] => 11
                    [key] => 5BTIB4EoklT6dVfTUR4ezwb8T3xdeTAi
                    [machineid] => HIT232300
                    [empCode] => 1004
                    [employeeid] => Jon Doe
                    [date] => 2016-03-25 09:27:33
                    [time] => 11:22:00
                    [operationtime] => 1800
                    [groupdate] => 2016-03-25
                    [usetime] => 1800
                )

        )

)

I'm trying to handle using this code using in_array but that code not working

  foreach ($workingLogs as $key => $date) {
          if(in_array($date['groupdate']) = $date['groupdate']){
            $datewise[$date['groupdate']]=$date;
          }else{
            $datewise[]=$date;
          }

Currently my table look like ..

I want look like.

Please help

Answer 1

You have a mistake in your code... You have to check the if statement with "==". Also, the in_array only returns a boolean. You can't compare it with a non boolean value

 foreach ($workingLogs as $key => $date) {
   if(array_key_exists('groupdate', $date) ){
     $datewise[$date['groupdate']]=$date;
   }else{
     $datewise[]=$date;
   }
}