Source de QuestionsQuartier.php
<?php
require('biblimsm.php');
$connexion = mysql_connect(SERVEUR,UTILISATEUR,MOTDEPASSE);
mysql_select_db(NOMBASE,$connexion);
if (!isset($quartier)) {
DebutPage("Quizz sur Lille");
echo "<FORM ACTION=\"QuestionsQuartier.php\" METHOD=\"post\">\n";
echo "<TABLE>\n";
echo "<TR>\n";
echo "<TD>Quartier</TD>\n";
echo "<TD>\n";
echo "<SELECT NAME=\"quartier\">\n";
$requete = "SELECT * FROM quartiers ORDER BY nom_quartier";
$resultat = mysql_query($requete,$connexion);
while ($quartier = mysql_fetch_array($resultat)) {
echo '<OPTION VALUE="';
echo $quartier['id'];
echo '"> ';
echo $quartier['nom_quartier'];
echo "\n";
}
echo "</SELECT>\n";
echo "</TD>\n";
echo "</TR>\n";
echo '<TR>
<TD COLSPAN="2">
<INPUT TYPE="submit" VALUE="choisir">
</TD>
</TR>
</TABLE>
</FORM>
';
} else {
$requete = "SELECT nom_quartier FROM quartiers WHERE id=$quartier";
$resultat = mysql_query($requete,$connexion);
$nom_quartier = mysql_result($resultat,0,0);
DebutPage("Quizz - $nom_quartier");
if ($action == 'soumission') {
$requete = "SELECT id,reponse FROM questions WHERE ref_quartier=$quartier";
$resultat = mysql_query($requete,$connexion);
$nb_bons = 0;
$nb_erreurs = 0;
while ($question = mysql_fetch_array($resultat)) {
if (${'q'.$question['id']} == $question['reponse']) {
$nb_bons++;
} else {
$nb_erreurs++;
}
}
if ($nb_erreurs == 0) {
echo "Vous avez tout juste ! Bravo !!!!";
} else {
if ($nb_bons <= 1) {
$ajb = '';
} else {
$ajb = 's';
}
if ($nb_erreurs == 1) {
$aje = '';
} else {
$aje = 's';
}
echo "<P>\n";
echo "Vous avez $nb_bons bonne$ajb réponse$ajb\n";
echo "et $nb_erreurs mauvaise$aje.\n";
echo "</P><P>\n";
echo "Vous pouvez recommencer ou\n";
echo '<A HREF="QetRQuartier.php?quartier=';
echo $quartier;
echo '">';
echo 'voir les réponses';
echo "</A>.";
echo "</P>\n";
}
}
if ((!isset($action)) || ($nb_erreurs > 0)) {
$requete = "SELECT * FROM questions WHERE ref_quartier=$quartier ORDER BY id";
$resultat = mysql_query($requete,$connexion);
echo "<FORM ACTION=\"QuestionsQuartier.php?quartier=$quartier\" METHOD=\"post\">\n";
echo "<INPUT TYPE=\"hidden\" NAME=\"action\" VALUE=\"soumission\">\n";
?>
<p>
<table width="700" border="0" cellspacing="0" cellpadding="0" height="100%" align="center">
<?php
$num = 0;
while ($question = mysql_fetch_array($resultat)) {
$propositions = array();
$reqprops = 'SELECT * FROM propositions WHERE ref_question='.$question['id'].' ORDER BY id';
$resprops = mysql_query($reqprops,$connexion);
while ($proposition = mysql_fetch_array($resprops)) {
$propositions[] = $proposition;
}
PoseQuestion(++$num,$question,$propositions);
}
?>
<tr>
<td align=center width="25"> </td>
<td align=center>
<input type="submit" name="Verifier" value="Vérifier les réponses">
</td>
</tr>
</table>
<?php
echo "</FORM>\n";
}
}
mysql_close($connexion);
PiedPage();
?>