Formulaire

formulaire.php

<?php

$event = $_GET['id'];
$query = $bdd->prepare('SELECT * FROM questions WHERE id_event = :event');
$query->execute(compact('event'));
$questions = $query->fetchAll();

?>

<form action="traitement.php" method="post">
<?php foreach($questions as $id => $question): ?>
    <label for="question_<?= $id ?>"><?= $question ?></label>
    <input type="text" name="questions[<?= $id ?>]" id="questiion_<?= $id ?>">
<?php endforeach; ?>

<button type="submit">Envoyer</button>
</form>

traitement.php

<?php

$reponses = $_POST['questions'];
foreach($reponses as $idQuestion => $reponse) {
    $query = $bdd->prepare('INSERT INTO reponses(id_question, reponse, date) VALUES(:question, :reponse, :date)');
    $query->execute([
        'question' => $idQuestion,
        'reponse' => $reponse,
        'date' => date('Y-m-d')
    ]);
}