1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38
| <?php
$bdd = new PDO('mysql:host=127.0.0.1;dbname=projet', 'root', '');
$question = $bdd->query('SELECT * FROM question');
$reponse = array();
$i = 0;
while ($donnees = $question->fetch())
{
?>
<p>
<strong> Question </strong> <?php echo $donnees['id']; ?>
</br>
<strong> <?php echo $donnees['question']; ?> </strong> </br>
<?php $choix = $donnees['id']; ?>
<select name=$choix>
<option value="1"><?php echo $donnees['q1']; ?></option>
<option value="2"><?php echo $donnees['q2']; ?></option>
<option value="3"><?php echo $donnees['q3']; ?></option>
<option value="4"> Je ne sais pas </option>
</select>
<?php
$reponse[$i] = $_POST[$choix];
$i++;
?>
</p>
<?php
}
?>
<input type="submit" name="formreponse" value="Confirmer" />
<?php
$question->closeCursor();
$insertmbr = $bdd->prepare = "INSERT INTO membre WHERE id = '1'
(q1,q2,q3,q4,q5,q6,q7,q8,q9,q10) VALUES (? , ? , ?, ?, ?, ?, ?, ?, ?, ?)";
$insertmbr->execute(array($reponse[0], $reponse[1], $reponse[2], $reponse[3], $reponse[4], $reponse[5], $reponse[6], $reponse[7], $reponse[8], $reponse[9]));
?> |
Partager