Home / Questions / 50958
Accepted
ByGroxD
Asked: 2020-02-23 06:08:06 +0800 CST 2020-02-23 06:08:06 +0800 CST

Load MySQLl data in Modal Bootstrap

  • 772

Example Table

modal example

Hello, how could I load all the data of the person in a modal window when clicking on the button shown in the image called Register?

When I click on it, I need to load all the data, which is in a MySQL database.

I know that it is possible with AJAX but the truth is that I have no knowledge in such, if you can provide me with information to solve my problem it would be of great help.

Thank you very much.

javascript

1 Answers

  1. Best Answer
    $.ajax({
              dataType : 'json',
              type : 'POST',
              url : 'consulta_datos.php',
              data :{id_principal},
              async:true,
              cache:false,
              success : function(response){
                 var id=response.id;
                 var identificacion=response.identi;
                 var nombre_completo=response.nom_compl;
                 $("#id").val(id);
                 $("#identificacion").val(identificacion);
                 $("#nombre_completo").val(nombre_completo);

              },
              error : function(error) {
                console.log(error);
              }
          });

    Well I recommend that you use jQuery to make your Ajax that returns the query data, when you create your table in the button that opens your modal, send a function that you are going to do in a javascript in this function that you do you are going to send the parameter that I imagine is the id of your table you make your query and put it in a JSON from PHP, and on the JavaScript side you receive it, parse it and with Jquery you send the values ​​to the corresponding input, the code above is a brief example How could you start?

    • 5