I need to take the patient id from the table to the next page, along with the user, by clicking the button

Question

<?php
$conexao = new mysqli("localhost","root","","hospital");

if($conexao->connect_errno){
    echo"Failed to connect to MySQL: (" . $conexao->connect_errno   .") " . $conexao->connect_error;
}

$res = $conexao->query("SELECT nome, idade, cpf from paciente, ficha_atendimento, questionario WHERE paciente.id = ficha_atendimento.id_paciente AND paciente.id = questionario.id_paciente");


echo "<table class='table table-striped'>";
echo "<tr>
        <td>Nome</td>
        <td>Idade</td>
        <td>CPF</td>
        </tr>";

while($row = mysqli_fetch_assoc($res)) {

    echo "<tr class='info'>
    <td>". $row['nome']."</td>
    <td>". $row['idade']."</td>
    <td>". $row['cpf']."</td>
    <td><a href='sala_questionario.php'><button class='btn btn-info'>Redirecionar</button></a></td>
    </tr>";
}

echo "</table>";


?>

The 'patient' table has the name age and Cpf fields, and all of these are being printed in the table, next to a button (in the code above) that redirects the patient to a page that he will answer a questionnaire. However, I need to take this patient’s id to this next page when it’s redirected, so that when he answers the questionnaire the program sends the data to the 'questionnaire' table that has a foreign key called id_patient that corresponds to the patient id of the 'patient' table. (that is, the problem is that all are being redirected to the same page, without differentiating who is answering the questionnaire).

Answer 1

You can do this using the method ?_GET, would look this way:

<td><a href='sala_questionario.php?id=$row['id']'><button class='btn btn-info'>Redirecionar</button></a></td>

And on the page sala_questionario, for you to take the value, would be like this:

$id = $_GET["id"];