Dynamic data display with PHP

It's quite simple to actually work with the combination of html, ajax and php to make requests, see the example below:

One thing to do is to put a field inside the modal where you will receive this information, in my case I used a div called content:

 <div id="conteudo"></div>

2 you already have a button that on the click opens modal, in addition to opening the modal you should call an ajax that will send information to php, I created a function that searches for cars informing the minimum and maximum value of each:

 $("#botao").click(function(){ // no click do botao que abre a modal faça
            buscaCarro(3000,15000);
     });

function buscaCarro(min, max) {
   $.ajax({
      type: "POST",
      url: 'arquivo.php',
      dataType: 'json',
      data: 'acao=carro' + '&min=' + min + '&max=' + max,
      success: function (data) {
         console.log(data);
         // resposta do php
        $("#conteudo").append(data); // colocando o conteudo na modal
 // dependendo do conteudo pode ser html(),text()...

      },
      error: function (data) {
         alert(data.responseText);
      }
   });
}

Ajax accesses the php file and does the following action:

 if($_REQUEST['acao'] === "carro"):
      $output = buscaCarro($_REQUEST['min'],$_REQUEST['max']);
 endif;

 echo json_encode($output);

This is a basic example, I advise you to get a basic handout: Handouts - Ajax Php

Friend, come on, I think the path is this:

A PHP file that will return the information of a product, where, such a file will receive the product ID, for example.

A little JavaScript (and jQuery) that will make the request in the PHP file and, after receiving the data, will include such values in the modal.

Come on:

query.php

$id = $_POST['id'];

// faça sua query aqui e adicione em $dadosRetornados

echo json_encode($dadosRetornados);

funcoes.js

Now you must make a function that receives the product ID and uses it in the request that will query. Something like this: (idProduct will be the value parameterized)

$.ajax({
    type: "POST",
    url: "consulta.php",
    data: { id: idProduto },
    success: function (resposta) {
        var dados = JSON.parse(resposta);
        $('#conteudoModal').html('Produto: ' + dados.nome + 'Valor: ' + dados.valor);
}

});

I believe this is the solution you are looking for, just change your HTML and add the function that will make the modal call.