89 lines
3.3 KiB
PHP
Executable File
89 lines
3.3 KiB
PHP
Executable File
<?php
|
|
/* include("admin_connecte.php"); */
|
|
session_start();
|
|
/* test si la session est lancée */
|
|
if((isset($_SESSION['Admin'])==true) && ($_SESSION['Admin']==1))
|
|
{
|
|
$titre="Modification d'un tournoi";
|
|
include("enTete.php");
|
|
?>
|
|
<body background="images/balle_raquette3.jpg">
|
|
<br>
|
|
<br>
|
|
<br>
|
|
<center><B>Veuillez choisir le tournoi à modifier</B></center>
|
|
<CENTER>
|
|
<?php
|
|
affiche_tableau_tournoi();
|
|
|
|
include("deco_admin.php");
|
|
include("piedDePage.php");
|
|
/* sinon si la personne n'est pas autorisé la renvoyer àla page de login */
|
|
}
|
|
else
|
|
{
|
|
echo("Non autorisé - Redirection vers la page d'identification dans 2 secondes");
|
|
sleep(2);
|
|
include("identification_admin.php");
|
|
}
|
|
|
|
function affiche_tableau_tournoi()
|
|
{
|
|
include("conf.php");
|
|
include("mysql_compat.php");
|
|
include ("conf.php");
|
|
$db_connection=mysql_connect($db_host,$db_user,$password);
|
|
mysql_select_db($db_name,$db_connection);
|
|
$annee_en_cours = date("Y") ;
|
|
$requete="SELECT club.nom as nom_club,club.e_mail, club.id_club, club.telephone ,tournoi.debut,tournoi.fin,tournoi.id_tournoi,tournoi.saison,tournoi.nom FROM club,tournoi WHERE tournoi.id_club=club.id_club AND tournoi.saison=$annee_en_cours GROUP BY tournoi.debut , club.nom;";
|
|
$reponse=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
while($reptab=mysql_fetch_array($reponse)){
|
|
$debut=explode("-",$['']);
|
|
$fin=explode("-",$['']);
|
|
$type="";
|
|
$type_adulte=0;
|
|
$type_enfant=0;
|
|
$type_double=0;
|
|
$requete2="SELECT categorie.type, categorie.age_min, categorie.age_max FROM categorie, categories_par_tournoi WHERE categories_par_tournoi.id_tournoi=$[''] AND categories_par_tournoi.id_categorie=categorie.id_categorie";
|
|
$reponse2=mysql_query($requete2,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."<br>");
|
|
while($reptab2=mysql_fetch_array($reponse2)){
|
|
if($['']=="double")
|
|
$type_double=$type_double+1;
|
|
else if($['']!="double" && $['']==0)
|
|
$type_enfant=$type_enfant+1;
|
|
else if($['']!="double" && $['']==0)
|
|
$type_adulte=$type_adulte+1;
|
|
}
|
|
/* affectation des categories */
|
|
if($type_adulte>0)
|
|
$type=$type."adulte ";
|
|
if($type_enfant>0)
|
|
$type=$type."jeune ";
|
|
if($type_double>0)
|
|
$type=$type."double";
|
|
$debut=explode("-",$['']);
|
|
$fin=explode("-",$['']);
|
|
$[''][]=$[''];
|
|
$[''][]=$[''];
|
|
$[''][]=$debut[2]."/".$debut[1]."/".$debut[0];
|
|
$[''][]=$fin[2]."/".$fin[1]."/".$fin[0];
|
|
$[''][]=$type;
|
|
}
|
|
mysql_close($db_connection);
|
|
echo"<FORM ACTION=modifier_tournoi_suite.php METHOD=GET>";
|
|
echo "<center><table width=75% border=1 CELLPADDING=5 bgcolor='#FFFFFF'><tr><td align=center width=23%><b>Tournoi à modifier</b></td><td width=31%><b>Club</b></td><td align=center width=23%><b>Debut du tournoi</b></td><td align=center width=23%><b>Fin du tournoi</b></td><td align=center width=23%><b>Type</b></td></tr>";
|
|
for ($i=0;$i<count($['']);$i++){
|
|
$liste =$[''];
|
|
echo "<tr><td><center><input type='radio' name='action' value='$liste[$i]'></center></td>";
|
|
echo "<td>".$[''][$i]."</td><td align=center>".$[''][$i]."</td><td align=center>".$[''][$i]."</td><td align=center>".$[''][$i]."</td></tr>";
|
|
}
|
|
for ($i=0;$i<count($['']);$i++){
|
|
if($[''][$i]==$id_tournoi)
|
|
$selected[$i]="selected";
|
|
else $selected[$i]="";
|
|
}
|
|
echo"</table><br><br><INPUT TYPE='SUBMIT' VALUE='Modifier'></form></center><br /><br /><br />";
|
|
}
|
|
|
|
?>
|