|
Nom |
Prenom |
Promo |
E-mail |
Adresse |
Tel |
Accompagne(e) |
Type Hotel |
Chambre |
Buffet |
Visite |
Gala |
Supprimer";
}
//
?>
";print "";
print $data['nom'];
print " | ";print "";
print $data['prenom'];
print " | ";print "";
print $data['promo'];
print " | ";print "";
print $data['email'];
print " | ";print "";
print $data['adresse'];
print " | ";print "";
print $data['tel'];
print " | ";print "";
print $data['accomp'];
print " | ";print "";
print $data['typehotel'];
print " | ";print "";
print $data['hotel'];
print " | ";print "";
print $data['buffet'];
print " | ";print "";
print $data['visite'];
print " | ";print "";
print $data['gala'];
print " | ";
//affichage de la colonne "supprimer utilisateur" quand $spe=afficher_del
if ($spe=='afficher_del' || $spe=='del'){
print "";
print " ";
print " | ";
}
//
print "";
}
print "
";
mysql_close();
}
// inscription d'une nouvelle personne $spe=root
//par appelle du fichier inscription.php dans lequel on a introduit la variable $spe
if ($spe==root){
include "inscription.php";
}
//statistiques de la base de donnees
if ($spe=='stats'){
$q="SELECT COUNT(*) from liste where promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$nb69=$row[0];
$q="SELECT COUNT(*) from liste where accomp='oui' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$accomp69=$row[0];
$q="SELECT COUNT(*) from liste where buffet='oui' AND promo=$promo1 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$buffet69a=$row[0];
$q="SELECT COUNT(*) from liste where buffet='oui' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$buffet69=$row[0];
$q="SELECT COUNT(*) from liste where hotel='double' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$hoteld69=$row[0];
$q="SELECT COUNT(*) FROM liste where hotel='simple' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$hotels69=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite1' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$espace69=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite1' AND promo=$promo1 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$espace69a=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite2' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$toulouse69=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite2' AND promo=$promo1 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$toulouse69a=$row[0];
$q="SELECT COUNT(*) from liste where gala='oui' AND promo=$promo1";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$gala69=$row[0];
$q="SELECT COUNT(*) from liste where gala='oui' AND promo=$promo1 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$gala69a=$row[0];
$q="SELECT COUNT(*) from liste where promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$nb99=$row[0];
$q="SELECT COUNT(*) from liste where accomp='oui' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$accomp99=$row[0];
$q="SELECT COUNT(*) from liste where buffet='oui' AND promo=$promo2 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$buffet99a=$row[0];
$q="SELECT COUNT(*) from liste where buffet='oui' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$buffet99=$row[0];
$q="SELECT COUNT(*) from liste where hotel='double' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$hoteld99=$row[0];
$q="SELECT COUNT(*) FROM liste where hotel='simple' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$hotels99=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite1' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$espace99=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite1' AND promo=$promo2 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$espace99a=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite2' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$toulouse99=$row[0];
$q="SELECT COUNT(*) from liste where visite='$activite2' AND promo=$promo2 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$toulouse99a=$row[0];
$q="SELECT COUNT(*) from liste where gala='oui' AND promo=$promo2";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$gala99=$row[0];
$q="SELECT COUNT(*) from liste where gala='oui' AND promo=$promo2 AND accomp='oui'";
$r=@mysql_query($q) or die ("Query Failed: $q");
$row=mysql_fetch_row($r);
$gala99a=$row[0];
$nb=$nb69+$nb99;
$accomp=$accomp69+$accomp99;
$hotels=$hotels69+$hotels99;
$espace=$espace69+$espace69a+$espace99+$espace99a;
$hoteld=$hoteld69+$hoteld99;
$buffet=$buffet69+$buffet99+$buffet69a+$buffet99a;
$gala=$gala69+$gala99+$gala69a+$gala99a;
$toulouse=$toulouse69+$toulouse99+$toulouse69a+$toulouse99a;
$total=$nb+$accomp;
print "
Inscrire une personne