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 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53
|
<?PHP
if (isset($_POST['serie']))
{
$requete_addquestion = "INSERT INTO question(QuestID,SerieID,QuestQuestion) VALUES('','".$_POST['serie']."','".$_POST['question']."')";
$resultat_addquestion = mysql_query($requete_addquestion);
$breponse1=0;
$breponse2=0;
$breponse3=0;
$breponse4=0;
switch($_POST['reponseOK'])
{
case 1 :
$breponse1=1;
break;
case 2 :
$breponse2=1;
break;
case 3 :
$breponse3=1;
break;
case 4 :
$breponse4=1;
break;
}
$requete_question="SELECT QuestID From question";
$resultat_question=mysql_query($requete_question);
$IDquestion=0;
while($question=mysql_fetch_array($resultat_question))
{
$IDquestion = $question['QuestID'];
}
$requete_addreponse1 = "INSERT INTO reponse(RepID,QuestID,RepReponse, RepStatut) VALUES('', '".$IDquestion."' ,'".$_POST['reponse1']."','".$breponse1."')";
$resultat_addreponse1 = mysql_query($requete_addreponse1);
$requete_addreponse2 = "INSERT INTO reponse(RepID,QuestID,RepReponse, RepStatut) VALUES('', '".$IDquestion."' ,'".$_POST['reponse2']."','".$breponse2."')";
$resultat_addreponse2 = mysql_query($requete_addreponse2);
$requete_addreponse3 = "INSERT INTO reponse(RepID,QuestID,RepReponse, RepStatut) VALUES('', '".$IDquestion."' ,'".$_POST['reponse3']."','".$breponse3."')";
$resultat_addreponse3 = mysql_query($requete_addreponse3);
$requete_addreponse4 = "INSERT INTO reponse(RepID,QuestID,RepReponse, RepStatut) VALUES('', '".$IDquestion."' ,'".$_POST['reponse4']."','".$breponse4."')";
$resultat_addreponse4 = mysql_query($requete_addreponse4);
}
?> |
Partager