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

Liste des étudiants 99-00 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"); # 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 username"; $resultUserProjet = mysql_query($queryUserProjet); if (mysql_num_rows($resultUserProjet)) { $i=0; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; while ($i < mysql_num_rows($resultUserProjet)) { $test_pair = $i%2; if ( $test_pair == 0) { $bgcolor = "#DDDDDD"; } else { $bgcolor = "#FFFFFF"; } $collab1 = 0; $collab2 = 0; $userId = mysql_result($resultUserProjet,$i,'userId'); $queryProjet = "SELECT DISTINCT * FROM projet WHERE userId_1=".mysql_result($resultUserProjet,$i,'userId')." OR userId_2=".mysql_result($resultUserProjet,$i,'userId')." OR userId_3=".mysql_result($resultUserProjet,$i,'userId'); $resultProjet = mysql_query($queryProjet); if ( mysql_result($resultProjet,0,'userId_1') != 0) { if ( mysql_result($resultProjet,0,'userId_1') != $userId) { if ($collab1 == 0) { $collab1 = mysql_result($resultProjet,0,'userId_1'); } else if ($collab2 == 0) { $collab2 = mysql_result($resultProjet,0,'userId_1'); } } } if ( mysql_result($resultProjet,0,'userId_2') != 0) { if ( mysql_result($resultProjet,0,'userId_2') != $userId) { if ($collab1 == 0) { $collab1 = mysql_result($resultProjet,0,'userId_2'); } else if ($collab2 == '') { $collab2 = mysql_result($resultProjet,0,'userId_2'); } } } if ( mysql_result($resultProjet,0,'userId_3') != 0) { if ( mysql_result($resultProjet,0,'userId_3') != $userId) { if ($collab1 == 0) { $collab1 = mysql_result($resultProjet,0,'userId_3'); } else if ($collab2 == 0) { $collab2 = mysql_result($resultProjet,0,'userId_3'); } } } echo "\n"; if ( mysql_result($resultUserProjet,$i,'email') != '') { echo ""; if ( mysql_result($resultUserProjet,$i,'homepage') != '') { echo ""; } echo "\n"; if ( mysql_result($resultProjet,0,'etat') == 'Rendu' ) { echo "\n"; } else if ( mysql_result($resultProjet,0,'url') != '' ) { echo "\n"; } else { echo "\n"; } if ($collab1 != '') { $queryUser1 = "SELECT DISTINCT * FROM users WHERE userId=$collab1"; $resultUser1 = mysql_query($queryUser1); echo "\n"; } else { echo "\n"; } } else { echo "\n"; } } else { echo ""; if ( mysql_result($resultUserProjet,$i,'homepage') != '') { echo ""; } echo "\n"; if ( mysql_result($resultProjet,0,'etat') == 'Rendu' ) { echo "\n"; } else if ( mysql_result($resultProjet,0,'url') != '' ) { echo "\n"; } else { echo "\n"; } if ($collab1 != '') { $queryUser1 = "SELECT DISTINCT * FROM users WHERE userId=$collab1"; $resultUser1 = mysql_query($queryUser1); echo "\n"; } else { echo "\n"; } } else { echo "\n"; } } echo "\n"; $i++; } echo "

Nom, Prénom	Home-Page	Groupe	Projet	Collaborateur/trice(s)
".mysql_result($resultUserProjet,$i,'username').", ".mysql_result($resultUserProjet,$i,'prenom')."	(Home-page)."; } else { echo "	(Home-page).	".mysql_result($resultUserProjet,$i,'groupe')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultUser1,0,'username')." ".mysql_result($resultUser1,0,'prenom')."\n"; if ($collab2 != '') { $queryUser2 = "SELECT DISTINCT * FROM users WHERE userId=$collab2"; $resultUser2 = mysql_query($queryUser2); echo " ".mysql_result($resultUser2,0,'username')." ".mysql_result($resultUser2,0,'prenom')."		".mysql_result($resultUserProjet,$i,'username').", ".mysql_result($resultUserProjet,$i,'prenom')."	(Home-page)."; } else { echo "	(Home-page).	".mysql_result($resultUserProjet,$i,'groupe')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultProjet,0,'projetNom')."	".mysql_result($resultUser1,0,'username')." ".mysql_result($resultUser1,0,'prenom')."\n"; if ($collab2 != '') { $queryUser2 = "SELECT DISTINCT * FROM users WHERE userId=$collab2"; $resultUser2 = mysql_query($queryUser2); echo " ".mysql_result($resultUser2,0,'username')." ".mysql_result($resultUser2,0,'prenom')."

\n"; } else { echo "

Aucun étudiant n'a encore été enregistré\n"; } echo "

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

\n"; echo "

Pour accéder à la liste des projets avec leur description...

\n"; echo "

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