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]));
?> |
