\n"; echo "\n"; echo "Formulaire d’inscription pour le projet du cours E72b\n"; echo "\n"; echo "\n"; echo "
\n"; echo "

Formulaire d’inscription pour le projet
du cours E72b

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

\n"; ###Variables pour l'annee 99-00 $varannee = '9900'; # 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"); ####DEBUT de la procedure pour le formulaire if (isset($mode)) { # Action du bouton Soumettre if ( $mode == "new_projet" ) { if ( $projetNom != '' && $nom_1 != '' && $projetDescription != '' ) { $nbUser1 = 0; $nbUser2 = 0; $nbUser3 = 0; if ( $nom_1 != '' ) { $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$nom_1' AND prenom='$prenom_1'"; $resultUser1 = mysql_query($queryUser1); if ( mysql_result($resultUser1,0,'userId') == '' ) { $query1 = "INSERT INTO users VALUES (NULL,'$nom_1',PASSWORD(''),'$email_1','fran¨ais','$homepage_1',0,0,0,'0000-00-00','00:00:00','','$prenom_1','$nom_1','',0,0,'','$varannee')"; $result1 = mysql_query($query1); $queryUser1 = "SELECT DISTINCT userId FROM users WHERE username='$nom_1' AND prenom='$prenom_1'"; $resultUser1 = mysql_query($queryUser1); $nbUser1 = mysql_result($resultUser1,0,'userId'); # echo "nbUser1 = $nbUser1
\n"; } else { $nbUser1 = mysql_result($resultUser1,0,'userId'); } } if ( $nom_2 != '' ) { $queryUser2 = "SELECT DISTINCT userId FROM users WHERE username='$nom_2' AND prenom='$prenom_2'"; $resultUser2 = mysql_query($queryUser2); if ( mysql_result($resultUser2,0,'userId') == '' ) { $query2 = "INSERT INTO users VALUES (NULL,'$nom_2',PASSWORD(''),'$email_2','fran¨ais','$homepage_2',0,0,0,'0000-00-00','00:00:00','','$prenom_2','$nom_2','',0,0,'','$varannee')"; $result2 = mysql_query($query2); $queryUser2 = "SELECT DISTINCT userId FROM users WHERE username='$nom_2' AND prenom='$prenom_2'"; $resultUser2 = mysql_query($queryUser2); $nbUser2 = mysql_result($resultUser2,0,'userId'); # echo "nbUser2 = $nbUser2
\n"; } else { $nbUser2 = mysql_result($resultUser2,0,'userId'); } } if ( $nom_3 != '' ) { $queryUser3 = "SELECT DISTINCT userId FROM users WHERE username='$nom_3' AND prenom='$prenom_3'"; $resultUser3 = mysql_query($queryUser3); if ( mysql_result($resultUser3,0,'userId') == '' ) { $query3 = "INSERT INTO users VALUES (NULL,'$nom_3',PASSWORD(''),'$email_3','fran¨ais','$homepage_3',0,0,0,'0000-00-00','00:00:00','','$prenom_3','$nom_3','',0,0,'','$varannee')"; $result3 = mysql_query($query3); $queryUser3 = "SELECT DISTINCT userId FROM users WHERE username='$nom_3' AND prenom='$prenom_3'"; $resultUser3 = mysql_query($queryUser3); $nbUser3 = mysql_result($resultUser3,0,'userId'); # echo "nbUser3 = $nbUser3
\n"; } else { $nbUser3 = mysql_result($resultUser3,0,'userId'); } } $queryProjetAll = "INSERT INTO projet VALUES (NULL,'$projetNom',$nbUser1,$nbUser2,$nbUser3,'$projetDescription','$projetUrl','','')"; # echo "Jusque la ca passse
\n"; $resultProjetAll = mysql_query($queryProjetAll); if ($nbUser1 != 0 && $resultProjetAll) { echo "
Merci d'avoir rempli ce formulaire!

\n"; } else { $start = 0; echo "
Ca n'a pas marché ! Contactez Didier Strasser ;)
\n"; } } else { $start = 0; echo "
Vous devez remplir au minimum les trois champs suivants : le nom du projet, le participant n° 1 et une description du projet !
"; } } } ####FIN de procˇdure pour le formulaire ####DEBUT du formulaire if ( $start == 0 ) { $tailleTD = 400; $tailleTD2 = tailleTD-10; echo "
\n"; echo "Merci de ne remplir ce formulaire qu'en un seul exemplaire par projet.
\n"; echo "Laissez libres les champs inutilisés.
\n"; echo "
\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo ""; echo "\n"; echo ""; echo ""; echo "\n"; echo ""; echo "
"; echo "Nom du projet : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "Participant n° 1 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom : Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "URL de la HomePage : \n"; echo "
\n"; echo "
"; echo "Participant n° 2 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom : Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "URL de la HomePage : \n"; echo "
\n"; echo "
"; echo "Participant n° 3 au projet : \n"; echo "\n"; echo "\n"; echo "
\n"; echo "Nom : Prénom :
\n"; echo "
\n"; echo "e-mail : \n"; echo "
\n"; echo "URL de la HomePage : \n"; echo "
\n"; echo "
"; echo "Description du projet : \n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
"; echo "URL du projet : \n"; echo "
\n"; echo "\n"; echo "
\n"; echo "
"; echo "
\n"; echo "
\n"; echo "
\n"; echo "
\n"; echo "

Suivez ce lien pour atteindre la liste des projets...

\n"; echo "

Suivez ce lien pour atteindre la page du cours...

\n"; } else if ( $start == 1 ) { $queryProjet = "SELECT DISTINCT * FROM projet WHERE projetNom='$projetNom'"; $queryUserProjet = "SELECT DISTINCT * FROM users ORDER BY userId"; $resultProjet = mysql_query($queryProjet); $resultUserProjet = mysql_query($queryUserProjet); echo "
\n"; if (mysql_num_rows($resultProjet)) { $i = 0; $bgcolor = "#DDDDDD"; $url = mysql_result($resultProjet,$i,'url'); # echo "\n"; # echo "\n"; # echo "\n"; # echo "\n"; echo "\n"; if ($url != '') { echo "\n"; echo "\n"; echo "\n"; } else { echo "\n"; echo "\n"; echo "\n"; } $participant_1 = mysql_result($resultProjet,$i,'userId_1'); $queryUser1Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_1"; $resultUser1Projet = mysql_query($queryUser1Projet); if ( $participant_1 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser1Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } $participant_2 = mysql_result($resultProjet,$i,'userId_2'); $queryUser2Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_2"; $resultUser2Projet = mysql_query($queryUser2Projet); if ( $participant_2 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser2Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } $participant_3 = mysql_result($resultProjet,$i,'userId_3'); $queryUser3Projet = "SELECT DISTINCT * FROM users WHERE userId=$participant_3"; $resultUser3Projet = mysql_query($queryUser3Projet); if ( $participant_3 > 0 ) { echo "\n"; echo "\n"; if ( mysql_result($resultUser3Projet,0,'homepage') != '') { echo "\n"; echo "\n"; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; } echo "
"; # echo "Numéro du projet : ".mysql_result($resultProjet,$i,'projetId')."."; # echo "
"; echo "Nom du projet : ".mysql_result($resultProjet,$i,'projetNom')."."; echo "
"; echo "Nom du projet : ".mysql_result($resultProjet,$i,'projetNom')."."; echo "
"; echo "Participant au projet : ".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail)."; } else { echo "".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail)."; } echo "
"; echo "Participant au projet : ".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail)."; } else { echo "".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail)."; } echo "
"; echo "Participant au projet : ".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail)."; } else { echo "".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail)."; } echo "
"; echo "Description du projet : ".mysql_result($resultProjet,$i,'description').".

"; echo "
\n"; echo "
Pour toute modification, merci de prendre contact avec Didier Strasser!

\n"; echo "
N'envoyez pas un second formulaire avec vos modifications!!!

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

Suivez ce lien pour atteindre la liste des projets...

\n"; echo "

Suivez ce lien pour atteindre la page du cours...

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