\n";
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 "";
echo "Numéro du projet : | \n";
echo "".mysql_result($resultProjet,$i,'projetId').".";
echo " | \n";
echo " \n";
echo "\n";
if ($url != '') {
echo "";
echo "Nom du projet : | \n";
echo "".mysql_result($resultProjet,$i,'projetNom')."";
echo " | \n";
echo " \n";
} else {
echo "";
echo "Nom du projet : | \n";
echo "".mysql_result($resultProjet,$i,'projetNom')."";
echo " | \n";
echo "\n";
}
if ($urlTecfa != '') {
echo "\n";
echo "";
echo "Emplacement du projet à Tecfa: | \n";
echo "".$urlTecfa."";
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 "";
echo "Participant au projet : | \n";
if ( mysql_result($resultUser1Projet,0,'homepage') != '') {
echo "".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail) (userId = $participant_1).";
} else {
echo " | ".mysql_result($resultUser1Projet,0,'prenom')." ".mysql_result($resultUser1Projet,0,'username')." (e-mail) (userId = $participant_1).";
}
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 "";
echo "Participant au projet : | \n";
if ( mysql_result($resultUser2Projet,0,'homepage') != '') {
echo "".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail) (userId = $participant_2).";
} else {
echo " | ".mysql_result($resultUser2Projet,0,'prenom')." ".mysql_result($resultUser2Projet,0,'username')." (e-mail). (userId = $participant_2)";
}
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 "";
echo "Participant au projet : | \n";
if ( mysql_result($resultUser3Projet,0,'homepage') != '') {
echo "".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail) (userId = $participant_3).";
} else {
echo " | ".mysql_result($resultUser3Projet,0,'prenom')." ".mysql_result($resultUser3Projet,0,'username')." (e-mail) (userId = $participant_3).";
}
echo " | \n";
echo " \n";
}
echo "\n";
echo "";
echo "Description du projet : | \n";
echo "".mysql_result($resultProjet,$i,'description');
echo " | \n";
echo " \n";
echo "\n";
echo "";
echo "Etat du travail : | \n";
if ( mysql_result($resultProjet,$i,'etat') == 'Rendu' ) {
echo "".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";
echo " \n";
$i++;
}
echo " \n";
} else {
echo "
Aucun projet n'a encore été enregistré\n";
}
echo " | \n";
echo "
Modification de la base de données\n";
if ( $modifOk == 0) {
echo "\n";
echo "\n";
echo "\n";
echo "
Suppression d'un projet\n";
echo "
\n";
echo "\n";
$queryAnnee = "SELECT DISTINCT annee FROM users";
$resultAnee = mysql_query($queryAnnee);
$idid = 0;
echo "\n";
echo " |