Home / Questions / 190471
Accepted
Jose Dario Correa
Asked: 2020-08-22 11:21:34 +0800 CST 2020-08-22 11:21:34 +0800 CST

Execute MySQL query on onChange

  • 772

I have one selectthat shows the departments:

<select name="dpto" id="dpto">
   <option value="3">ATLANTICO</option>
   <option value="12">CESAR</option>
</select>

What I need is that when selecting X department, it makes a query to the Database and shows me the data as follows:

<span class="tipoboletin">Tipo Boletin: <b><?php echo $B_Tipo_Boletin ?></b></span>

This is the MySQL query I have:

SELECT * FROM boletin WHERE Departamento = '" . $idDpto . "'"

Where would be $idDptothe valuedepartment you select.

php

1 Answers

  1. Best Answer

    you could do it in the following way this is just an example there are many ways to do it this is one of the easiest example:

      <select name="dpto" id="dpto">
       <option value="3">ATLANTICO</option>
       <option value="12">CESAR</option>
    </select>


   <div id="resultados"></div><!--aqui se mostraran los resultados-->

    js file

     $(document).ready(function(){

           $("#dpto").on("change",function(){

            var valorSelect=$(this).val()//obtenemos el valor seleccionado en una variable


        $.ajax({

            url:"callback.php",
            type:"POST",
            data:{ valorSelect:valorSelect},//enviamos lo seleccionado

            success:function(respuesta){
               console.log( respuesta)
             $("#resultados").html(respuesta);//en el div con el id respuestas mostramos los resultados del callback

            }

          })

          })

        })

    callback.php

    $valorSelect=$_POST["valorSelect"];//recojemos lo seleccionado

$query=mysqli_query($conn,"SELECT * FROM boletin WHERE Departamento = '" . $valorSelect . "'");

$row=mysqli_fetch_array($query);

echo...////aqui imprimes tu resultados para que ajax lo recoja

    I hope it helps you, greetings!

    • 0