Running ajax within a table

Question

Good afternoon everyone, I’m trying to make a code where it shows how long a request has been opened and I have an ajax that keeps updating this counter every second, my problem is that this request comes in a table where there may be several requests, but since ajax is only running after the page loads it takes the base date only of the last request and replication at all.

Javascript from ajax:

$(document).ready(function() {

      // Requisicao AJAX
      var requisicao = function() {
        var data_abertura = "<?php echo $data_base; ?>";
        $.ajax({
          url: "contador.php",

          type: "post",
          data: {
            data_abertura: data_abertura
          },
        }).done(function(resultado) {
          // Exibe o resultado no elemento com ID contador
          $(".contador").html(resultado);
        });
      };

      // Executa a requisicao com intervalo de 100ms
      setInterval(requisicao, 100);

    });

Javascript of the counter.php :

$date = $_POST['data_abertura'];
echo $date;
$date = new DateTime($date);
$interval = $date->diff( new DateTime( ) );
echo $interval->format( '%a Dia %H Horas %i Minutos e %s Segundos' );

Html snippet where I bring the counter (with the table), I don’t know if it helps:

    <table id="example1" class="table table-bordered table-striped">
                                <thead>
                                  <tr>
                                    <th id="CV" width="10%">Chamado</th>
                                    <th id="CV" width="10%">Problema</th>
                                    <th id="CV">Nome <br> Contato</th>
                                    <th id="CV">Departamento <br> Descrição</th>
                                    <th id="CV">Prioridade</th>
                                    <th id="CV">Data</th>
                                    <th id="CV" width="0%">Status</th>
                                  </tr>
                                </thead>
                                <tbody>
                                  <?php
                                  $query_2 =  "
                                      SELECT tb_ocorrencias.data_final, tb_ocorrencias.data_inicial, tb_ocorrencias.data_saida, tb_ocorrencias.id_prioridade,tb_ocorrencias.data_abertura,tb_ocorrencias.data_atendimento,  tb_ocorrencias.data_fechamento, tb_ocorrencias.id_ocorrencia, tb_problemas.problema, tb_usuarios.usuario, tb_usuarios.contato, tb_departamentos.departamento, tb_ocorrencias.descricao_ocorrencia, tb_status.status,tb_prioridades.prioridade, tb_ocorrencias.data_entrada
                                      FROM tb_ocorrencias
                                      INNER JOIN tb_usuarios on tb_usuarios.id_usuario = tb_ocorrencias.id_usuario
                                      INNER JOIN tb_problemas on tb_problemas.id_problema = tb_ocorrencias.id_problema
                                      INNER JOIN tb_departamentos on tb_usuarios.id_departamento = tb_departamentos.id_departamento
                                      INNER JOIN tb_prioridades on tb_prioridades.id_prioridade = tb_ocorrencias.id_prioridade
                                      INNER JOIN tb_status on  tb_status.id_status = tb_ocorrencias.id_status
                                      WHERE tb_ocorrencias.id_atendente = 0
                                      AND (tb_ocorrencias.id_departamento = '$id_departamento'
                                                      OR tb_ocorrencias.id_departamento = 184)
                                      ORDER BY tb_prioridades.prioridade DESC, tb_ocorrencias.id_ocorrencia ASC
                                  ";

                                  $resultado_2 = mysql_query($query_2, $conexao);
                                  while ($dados_2 = mysql_fetch_array($resultado_2)) {
                                    $data_base = $dados_2['data_abertura'];

                                    $id_ocorrencia =  $dados_2['id_ocorrencia'];
                                    $a = "<a href = 'chamados/atendente.php?numero=$id_ocorrencia' title = 'Visualizar' style = 'color: #000;'> $id_ocorrencia </a>";
                                      $data_abertura_1 = substr($dados_2['data_abertura'], 0, 10);
                                      $data_abertura = substr($data_abertura_1, -2, 2) . '/' . substr($data_abertura_1, -5, 2) . '/' . substr($data_abertura_1, 0, 4);
                                  ?>
                                      <tr>
                                        <td id="CC"> <?php echo "$a"; ?> </td>
                                        <td id="CV"> <?php echo $dados_2['problema']; ?> </td>
                                        <td id="CV"> <b> <?php echo $dados_2['usuario']; ?> </b> <br> <?php echo $dados_2['contato']; ?> </td>
                                        <td id="CV"> <b> <?php echo $dados_2['departamento']; ?> </b> <br> <?php echo $dados_2['descricao_ocorrencia']; ?> </td>
                                        <td id="CV"> <?php echo $dados_2['prioridade']; ?> </td>
                                        <td id="CC"> <?php echo $data_abertura; ?><p><span id="contador" class="contador" ></span> </p> </td>
                     </tbody>
</table>  

Answer 1

Good afternoon people, I managed to solve the problem, I made the request AJAX of the table every minute, this solved the problem, thank you all.

Answer 2

your query has multiple JOINS and this makes there are multiple returns per record found, what you need to do is regroup the return data correctly. Some GROUP BY may help, but I would regroup the data directly in PHP on using foreach. Take the query out of the view hehe, create a class (DAO) to control the requests to DB. One more thing, if you want to do these AJAX in sequence, better use callbacks or Promisses so that the next request is made only when the previous request has finished :) Hug.