Real-time data filtering using Jquery

Question

Real-time data filtering using Jquery

Navigation

#1 by (2 votes)

1

I am building a comment system and would like that when the user selects the value of a select field, a variable would be sent to a PHP page with the selected value, and it would return the results inside a div. >

<form>
    <div class="campo">
        <label>Ordenar por: </label>
        <select id="ordenar" name="ordenar">
            <option>Relevância</option>
            <option>Mais Recente</option>
        </select>
    </div>                  
    <div class="campo">
        <label>Comentários apenas de: </label>
        <select id="filtroComentarios" name="filtroComentarios">
            <option>Professores</option>
            <option>Estudantes</option>
        </select>
    </div> 
</form>

<div id="comentarios"> </div>
//Div que recebe os comentários filtrados

php mysql jquery

asked by anonymous 06.03.2017 / 21:47

1 answer

SQL counting data from the second INNER JOIN table, but should not it? Jquery - Is there a way to connect buttons?

score 2 · Accepted Answer

$('.campo select').on('change', function(){
  var valorSelecionado = $('.campo select').eq(0).val();
  var valorSelecionado2 = $('.campo select').eq(1).val();
  $.ajax({
    method: "POST",
    url: "pagina.php",
    data: {variavel: valorSelecionado, variavel2: valorSelecionado2} // variavel é o nome que você deve pegar no servidor.
  })
  .done(function( msg ) {
    $('#comentarios').text(msg);
    //ou $('#comentarios').html(msg);
  });
})

From here you only use $ _POST in php to get the value, filter and echo the server with the comments already formatted.