<?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>&nbsp;
    <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">&nbsp;</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();

?>