\n"; echo "\n"; echo "Gestion des étudiants 99-00 du cours E72b\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

Gestion des étudiants 99-00 du cours E72b

\n"; echo "
\n"; echo "


\n"; # se connecte a localhost (tecfasun1) avec l'identite de nobody mysql_pconnect( "localhost", "campus", "snowwhite") or die( "Unable to connect to SQL server"); # selectionne la bdd iconometre mysql_select_db("e72b") or die( "Unable to select database"); if (isset($mode)) { if ( $mode == "passTest" ) { if ( $password == 'iapiaget' ) { $start = 1; } } if ( $mode == "ChangeAnnee" ) { $start = 1; } if ( $mode == "modif" ) { if ( $userIndex != '' ) { $modifOk = 1; $start = 1; } } if ( $mode == "NewEtu" ) { $modifOk = 0; $newOk = 1; $start = 1; } if ( $mode == "put_new" ) { if ( $userNom != '' && $userPrenom != '' ) { $nbUser1 = 0; if ( $newAnnee != "") { $userAnnee = $newAnnee; } $query1 = "INSERT INTO users VALUES (NULL,'$userNom',PASSWORD(''),'$userEmail','fran¨ais','$userPage',0,0,0,'0000-00-00','00:00:00','','$userPrenom','$userNom','',0,0,'$userGroup','$userAnnee')"; $varannee = $userAnnee; $result1 = mysql_query($query1); $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$userNom' AND prenom='$userPrenom'"; $resultUser1 = mysql_query($queryUser1); $nbUser1 = mysql_result($resultUser1,0,'userId'); if ($nbUser1 != 0 ) { $start = 1; $modifOk = 0; $newOk = 0; echo "
L'ajout de l'étudiant n° $userId a été effectuée avec succès!

\n"; } else { $start = 1; $modifOk = 0; $newOk = 0; echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; } } else { $start = 1; $modifOk = 0; $newOk = 1; echo "
Vous devez remplir au minimum les deux champs suivants : le nom de l'étudiant et son prénom !
"; } } if ( $mode == "put_modif" ) { if ( $userNom != '' && $userPrenom != '' ) { $nbUser1 = 0; $query1 = "UPDATE users SET username='$userNom',email='$userEmail',homepage='$userPage',prenom='$userPrenom',nom='$userNom',groupe='$userGroup',annee='$userAnnee' WHERE userId=$userId"; $varannee = $userAnnee; $result1 = mysql_query($query1); $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$userNom' AND prenom='$userPrenom'"; $resultUser1 = mysql_query($queryUser1); $nbUser1 = mysql_result($resultUser1,0,'userId'); if ($nbUser1 != 0 ) { $start = 1; $modifOk = 0; echo "
La mise à jour de l'entrée n° $userId a été effectuée avec succès!

\n"; } else { $start = 1; $modifOk = 0; echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; } } else { $start = 1; $modifOk = 1; echo "
Vous devez remplir au minimum les deux champs suivants : le nom de l'étudiant et son prénom !
"; } } if ($mode=="deleteUser") { $query = "DELETE FROM users WHERE userId='$userIndex'"; $result = mysql_query($query); if ($result) { echo "
La suppression de l'étudiant a fonctionné
\n"; $start = 1; $modifOk = 0; } else { echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; $start = 1; $modifOk = 0; } } } ###Procedure qui test un mot de passe pour acceder aux modifications##### if ( $start == 0 ) { $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "
\n"; echo "
\n"; echo "\n"; echo "

Cette page nécessite un mot de passe…\n"; echo "
\n"; echo "

Sélectionnez une volée :\n"; echo "
"; echo "

\n"; echo "

\n"; echo "
\n"; } else { ####Mot de passe de modifications accepte##### # se connecte a localhost (tecfasun1) avec l'identite de nobody mysql_pconnect( "localhost", "campus", "snowwhite") or die( "Unable to connect to SQL server"); # selectionne la bdd e72b mysql_select_db("e72b") or die( "Unable to select database"); $queryUserProjet = "SELECT DISTINCT * FROM users WHERE annee='$varannee' ORDER BY userId"; $resultUserProjet = mysql_query($queryUserProjet); echo "

Données pour la volée $varannee

\n"; echo "
\n"; if (mysql_num_rows($resultUserProjet)) { $i=0; echo "\n"; while ($i < mysql_num_rows($resultUserProjet)) { $test_pair = $i%2; if ( $test_pair == 0) { $bgcolor = "#DDDDDD"; } else { $bgcolor = "#FFFFFF"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; if ( mysql_result($resultUserProjet,$i,'homepage') != '') { echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $i++; } echo "
"; echo "Numéro de l'étudiant : ".mysql_result($resultUserProjet,$i,'userId')."."; echo "
"; echo "Nom de l'étudiant : ".mysql_result($resultUserProjet,$i,'prenom')." ".mysql_result($resultUserProjet,$i,'username').""; if ( mysql_result($resultUserProjet,$i,'email') != '') { echo " (e-mail)."; } else { echo " (e-mail)."; } } else { echo "".mysql_result($resultUserProjet,$i,'prenom')." ".mysql_result($resultUserProjet,$i,'username').""; if ( mysql_result($resultUserProjet,$i,'email') != '') { echo " (e-mail)."; } else { echo " (e-mail)."; } } echo "
"; echo "Groupe de travail : ".mysql_result($resultUserProjet,$i,'groupe')." "; echo "
"; echo "Année : ".mysql_result($resultUserProjet,$i,'annee'); echo "
\n"; } else { if ( $newOk == 0) { echo "


Aucun projet n'a encore été enregistré
\n"; } else { echo "


Enregistrement d'un nouvel utilisateur
\n"; } } echo "
\n"; echo "

Modification de la base de données

\n"; if ( $modifOk == 0) { if ( $newOk == 0) { echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "N° de l'étudiant à modifier :

\n"; echo "
\n"; echo "\n"; echo "

Suppression d'un étudiant

\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "N° de l'étudiant à supprimer :

\n"; echo "


\n"; echo "\n"; $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo "
\n"; echo "\n"; echo "

Sélection d'une autre volée :

\n"; echo ""; echo "

\n"; echo "

\n"; echo "
\n"; echo "\n"; echo "

Création d'un nouvel étudiant :

\n"; echo "

\n"; echo "

\n"; $queryEmail = "SELECT DISTINCT email FROM users WHERE annee='$varannee'"; $resultEmail = mysql_query($queryEmail); echo "

Envoi d'un e-mail à tous

\n"; $emailid = 0; echo "
\n"; echo "Si le ien ci-dessus ne fonctionne pas, recopiez le texte ci-dessous dans le destinataire d'un nouveau message dans un logiciel de e-mail\n"; echo "

\n"; echo "
\n"; } else { $tailleTD = 400; $tailleTD2 = tailleTD-10; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; #echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "
"; echo "Nom de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Prénom de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "E-mail de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Home-Page de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Groupe de travail : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "Année : \n"; echo "
\n"; $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo ""; echo "
\n"; echo "
"; echo "Nouvelle année : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; } } else { $queryUserModif = "SELECT DISTINCT * FROM users WHERE userId=$userIndex"; $resultUserModif = mysql_query($queryUserModif); if ( mysql_num_rows($resultUserModif) ) { $tailleTD = 400; $tailleTD2 = tailleTD-10; echo "
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo "\n"; echo "\n"; echo ""; echo "\n"; echo ""; echo "
"; echo "N° de l'étudiant à modifier : \n"; echo "
\n"; echo "

\n"; echo "
\n"; echo "
"; echo "Nom de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Prénom de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "E-mail de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Home-Page de l'étudiant : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Groupe de travail : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "Année : \n"; echo "
\n"; if ( mysql_result($resultUserModif,0,'annee') != "") { echo "
\n"; } else { $queryAnnee = "SELECT DISTINCT annee FROM users"; $resultAnee = mysql_query($queryAnnee); $idid = 0; echo ""; echo "
\n"; echo "
"; echo "Nouvelle année : \n"; echo "
\n"; echo "
\n"; } echo "
\n"; echo "
"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "\n"; } else { echo "
Le numéro $userIndex n'est attribué à aucun étudiant...
Vérifiez la liste !
\n"; echo "

Retour

"; echo "
\n"; echo "\n"; } } } echo "

Pour accéder au formulaire d'inscription des projets...

\n"; echo "

Pour accéder à la liste des projets (99-00) avec leur description...

\n"; echo "

Pour accéder à la liste des étudiants (99-00) avec un lien sur leur projet...

\n"; echo "

Didier Strasser / Didier.Strasser@pse.unige.ch\n"; echo "\n"; echo ""; ?>