"); $reponse1=mysql_fetch_object($result1); $titre=" Gestion des terrains de $reponse1->nom"; include("enTete.php"); include("calendrier/calendrier.inc.php"); include("calendrier/string.inc.php"); $mois_courrant=date("m"); $annee=date("Y"); $mois_courrant=$mois_courrant-1; echo "
"; $mois=$_GET['mois']; if ($mois==''){ $mois=date("m"); } $jour=$_GET['jour']; if ($jour==''){ $jour=date("j"); } //echo 'jour : ',$jour; $heure=$_GET['heure']; //echo 'heure : ',$heure; $court=$_GET['court']; //echo 'court : ',$court; $annee=date("Y"); $annuler=$_GET['annuler']; $type[][]=$_GET['type']; $nom[][]=$_GET['nom']; #echo 'test ',$nom[0][0];echo ' test ',$nom[1][1];echo ' test ',$nom[0][1]; //echo 'annuler : ',$annuler; if ($annuler=='1'){ $requete="DELETE FROM `reservation` WHERE `heure`=$heure and `jour`=$jour and `mois`=$mois and `annee`=$annee and `court`=$court and `club`=$club;"; //echo $requete; $result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } for ($h=8;$h<=20;$h++){ for ($c=1;$c<=$reponse1->nb_cours;$c++){ if ($nom[$h][$c]!=''){ $name=$nom[$h][$c]; $typ=$type[$h][$c]; $requete="INSERT INTO `reservation` ( `id_reservation` , `nom` , `heure` , `jour` , `mois` , `annee` , `court`,`type`,`club` )VALUES ('', '$name', '$h', '$jour', '$mois', '$annee', '$c','$typ','$club');"; //echo $requete; $result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); } } } echo "
"; if($mois_courrant==0){ $gestion_mois=12; $gestion_annee=$annee-1; echo showCalendar($gestion_annee."-".$gestion_mois,$club); } else{ echo showCalendar($annee."-".$mois_courrant,$club); } echo "
"; $mois_courrant=$mois_courrant+1; echo showCalendar($annee."-".$mois_courrant,$club); echo "
"; if($mois_courrant==12){ $mois_courrant=1; $annee=$annee+1; echo showCalendar($annee."-".$mois_courrant,$club); } else{ $mois_courrant=$mois_courrant+1; echo showCalendar($annee."-".$mois_courrant,$club); } echo "
"; echo "Le ",$jour," ",monthNumToName($mois)," ",$annee; if ($club=='3'){ if ($mois<10 and strlen($mois)<2) { $mois = "0".$mois; } $requete="SELECT nom FROM reservation WHERE nom = 'cours' and annee='$annee' and mois='$mois' and club='3'"; $result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $nb_h_cours = mysql_numrows($result); echo "
Nombre d'heure de cours : ",$nb_h_cours; echo " (Ecrire : 'cours' !!!)"; } echo "
"; echo""; for ($j=1;$j<=$reponse1->nb_cours;$j++){ echo""; } echo""; for ($i=8;$i<=20;$i++){ echo""; for ($j=1;$j<=$reponse1->nb_cours;$j++){ if ($mois<10 and strlen($mois)<2) { $mois = "0".$mois; } $requete="SELECT id_reservation FROM reservation WHERE court LIKE '$j' AND heure LIKE '$i' AND annee LIKE '$annee' AND mois LIKE '$mois' AND jour LIKE '$jour' AND club LIKE '$club'"; $result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $exist = mysql_numrows($result); if ($exist==0){ echo""; } else{ echo""; } } echo""; } echo "
HorairesCourt $j

"; $requete="SELECT nom,type FROM reservation WHERE court LIKE '$j' AND heure LIKE '$i' AND annee LIKE '$annee' AND mois LIKE '$mois' AND jour LIKE '$jour' AND club LIKE '$club'"; $result=mysql_query($requete,$db_connection) or die ("Erreur no".mysql_errno()." : ".mysql_error()."
"); $reponse=mysql_fetch_object($result); echo "X
$reponse->type
$reponse->nom
"; echo "
"; include("piedDePage.php"); ?>