\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 "";
echo "Numéro de l'étudiant : | \n";
echo "".mysql_result($resultUserProjet,$i,'userId').".";
echo " | \n";
echo " \n";
echo "\n";
echo "";
echo "Nom de l'étudiant : | \n";
if ( mysql_result($resultUserProjet,$i,'homepage') != '') {
echo "".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 " | \n";
echo " \n";
echo "\n";
echo "";
echo "Groupe de travail : | \n";
echo "".mysql_result($resultUserProjet,$i,'groupe')." ";
echo " | \n";
echo " \n";
echo "\n";
echo "";
echo "Année : | \n";
echo "".mysql_result($resultUserProjet,$i,'annee');
echo " | \n";
echo " \n";
$i++;
}
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 "
Suppression d'un étudiant\n";
echo "
\n";
echo "\n";
$queryAnnee = "SELECT DISTINCT annee FROM users";
$resultAnee = mysql_query($queryAnnee);
$idid = 0;
echo "\n";
echo "\n";
$queryEmail = "SELECT DISTINCT email FROM users WHERE annee='$varannee'";
$resultEmail = mysql_query($queryEmail);
echo "
\n";
$emailid = 0;
echo " \n";
echo " |