Source de SauveQuestion.php
<?php
require('biblimsm.php');
DebutPage('Enregistrement d\'une question');
// Connexion à la base
$connexion = mysql_connect(SERVEUR,UTILISATEUR,MOTDEPASSE);
mysql_select_db(NOMBASE,$connexion);
// Insertion de la nouvelle question
$requete = "INSERT INTO questions VALUES ('','$formulation',$quartier,0)";
mysql_query($requete,$connexion);
// Insertion des réponses
$requete = "SELECT MAX(id) FROM questions";
$resultat = mysql_query($requete,$connexion);
$id_question = mysql_result($resultat,0,0);
for ($i=1 ; $i<=7 ; $i++) {
if ($prop[$i] != '') {
$requete = "INSERT INTO propositions VALUES ('','$prop[$i]',$id_question)";
mysql_query($requete,$connexion);
if ($i == $br) {
$requete = "SELECT MAX(id) FROM propositions";
$resultat = mysql_query($requete,$connexion);
$id_br = mysql_result($resultat,0,0);
$requete = "UPDATE questions SET reponse=$id_br WHERE id=$id_question";
mysql_query($requete,$connexion);
}
}
}
// Récupération des infos pour vérification
$requete = "SELECT * FROM questions WHERE id=$id_question";
$resultat = mysql_query($requete,$connexion);
$question = mysql_fetch_array($resultat);
$requete = "SELECT * FROM propositions WHERE ref_question=$id_question";
$resultat = mysql_query($requete,$connexion);
while ($proposition = mysql_fetch_array($resultat)) {
$propositions[] = $proposition;
}
?>
<p>
<table width="700" border="0" cellspacing="0" cellpadding="0" height="100%" align="center">
<?php
AfficheQuestion(1,$question,$propositions,FALSE);
AfficheQuestion(1,$question,$propositions,TRUE);
?>
<tr>
<td width="25"> </td>
<td> </td>
</tr>
<tr>
<td align=center width="25"> </td>
<td align=center> </td>
</tr>
</table>
<?php
// Déconnexion et fin de page
mysql_close($connexion);
PiedPage();
?>