Problems in generating a table

Question

I’m having a hard time making a table. Could someone make a table that shows the times an employee made during the month? the idea would be to show the employee beats during the month.

In my bank would have the table that would keep those employee beats:

---

markings
batida_id (int) is the id of the beat
collaborator (int) is the official’s registration
registration (time) is the time of the beat ex: 07:30:00, 12:00:00..
date (date) is the date of the strike.
guy (char) is the type of incoming or outgoing hit.

---

Example: if an employee has the following strikes:

batida_id =>1 collaborator_id=> 1 date => 01/06/2016 beat => 07:30 type => input
batida_id =>2 collaborator_id=> 1 date => 01/06/2016 beat => 12:00 type => output
batida_id =>3 collaborator_id=> 1 date => 01/06/2016 beat => 13:30 type => input
batida_id =>4 collaborator_id=> 1 date => 01/06/2016 beat => 17:00 type => output

the table would have to look like this:

I managed to make only a part of the table, I can not make the logic to show the beats in front of the dates.

<table class="table table-striped">
  <tr>
  <th>Data</th>
  <th>Dia Semana</th>
  <th>Ocorrências</th>
  </tr>  <br />

    <?php


    $diasSemana[1] = 'Segunda-feira';
    $diasSemana[2] = 'Terça-feira';
    $diasSemana[3] = 'Quarta-feira';
    $diasSemana[4] = 'Quinta-feira';
    $diasSemana[5] = 'Sexta-feira';
    $diasSemana[6] = 'Sábado';
    $diasSemana[7] = 'Domingo';


    for($dias = 1; $dias <= date('t',strtotime('2016-06')); $dias++)

    {
    echo "<tr>";
    echo "<th>".$dias."</th>" . "<th>".$diasSemana[date('N', strtotime("2016-06-$dias"))] ."</th>" . "<th>";


        }


   echo "</tr>";

?>    
             </table>

Could someone help me?

Answer 1

<?php
    # valor que vem do formulario (se houver)
    $colaborador = 1;

    # todos os resultados por ordem de dia e hora (não importa a entrada e saída) de uma matricula (se for de todos, retire o WHERE)
    $resultado = "SELECT * FROM tabela WHERE colaborador = {$colaborador} 
    ORDER BY dia ASc, HOUR(hora) ASC";

    # se vier um array valido
    if (is_array($resultado) && count($resultado) >0)
    {
        # uma variável para armazenar as horas
        $dia_hora = array();
        foreach($resultado as $key => $value)
        {
            # agrupar dia e hora
            $dia_hora[$value['dia'][] = $value['hora'];
        }
        # construir a tabela
        echo "<table>" . PHP_EOL .
        "<tbody>";
        foreach($resultado as $key => $value)
        {
           echo "<tr>" . PHP_EOL .
                "<td>{$value['dia']</td>" . PHP_EOL;
            # aqui é a forma (que eu achei) para imprimir a entrada e saída na mesma linha e dividir as mesmas por coluna
            $dia[$value['dia'][] = $value['hora'];
            foreach($dia_hora[$value['dia']] as $dia => $hora)
            {
               # 0 (entrada)
               # 1 (saída) 
               echo "<td>{$hora[0]}</td>" . PHP_EOL .
               "<td>{$hora[1]}</td>" . PHP_EOL;
            }
            echo "</tr>";
        }
        echo "</tbody>" . PHP_EOL .
        "</table>";