\n"; echo "\n"; echo "Liste des projets 2000 du cours E72b\n"; echo "\n"; echo "\n"; echo "\n"; echo "

Liste des projets 2000 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"); $queryProjet = "SELECT DISTINCT projet.* FROM projet,users WHERE users.annee='$varannee' AND (users.userId=projet.userId_1 OR users.userId=projet.userId_2 OR users.userId=projet.userId_3) ORDER BY projetId"; $queryUserProjet = "SELECT DISTINCT * FROM users WHERE annee='$varannee' ORDER BY userId"; $resultProjet = mysql_query($queryProjet); $resultUserProjet = mysql_query($queryUserProjet); if (mysql_num_rows($resultProjet)) { $i=0; echo "\n"; while ($i < mysql_num_rows($resultProjet)) { $test_pair = $i%2; if ( $test_pair == 0) { $bgcolor = "#DDDDDD"; } else { $bgcolor = "#FFFFFF"; } $url = mysql_result($resultProjet,$i,'url'); $urlTecfa = mysql_result($resultProjet,$i,'urlTecfa'); # 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"; } if ($urlTecfa != '') { if ( mysql_result($resultProjet,$i,'etat') != '' ) { echo "\n"; 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 "\n"; echo "\n"; echo "\n"; if ( mysql_result($resultProjet,$i,'etat') == 'Rendu' ) { echo "\n"; echo "\n"; $i++; } 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 "Emplacement du projet à Tecfa:	".$urlTecfa.""; 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 "
"; echo "Etat du travail :	".mysql_result($resultProjet,$i,'etat')." "; } else if ( mysql_result($resultProjet,$i,'etat') == 'Pas rendu' ) { echo "	".mysql_result($resultProjet,$i,'etat')." "; } else { echo "	En cours de finition "; } echo "

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

Pour accéder au formulaire d'inscription 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 ""; ?>