codice:
<?
$num = 0;
$query_base = "SELECT * FROM calendari where stagione = '$Stagione'";
$numero_righe = TotRows($query_base, $RecordPerPagine, $db);
$numero_pagine = TotPages($numero_righe, $RecordPerPagine);
$argom = "&Pag=admin_calendari&Stagione=$Stagione";
$lmt_inf = LimitLower($PaginaAssoluta, $RecordPerPagine);
$query = "$query_base ORDER BY data desc LIMIT $lmt_inf, $RecordPerPagine";
$result = mysql_query($query, $db);
while($row = mysql_fetch_array($result)) {
$num++;
$ID_Calendario = $row["id"];
$TorneoCalendario = $row["torneo"];
$DataCalendario = $row["data"];
$GiornataCalendario = $row["giornata"];
$AndataRitornoCalendario = $row["andata_ritorno"];
if ($AndataRitornoCalendario=="Andata") {
$selectb1 = " selected";
$selectb2 = "";
} elseif ($AndataRitornoCalendario=="Ritorno") {
$selectb1 = "";
$selectb2 = " selected";
} elseif ($AndataRitornoCalendario=="") {
$selectb1 = "";
$selectb2 = "";
}
$TurnoCalendario = $row["turno"];
$IDins = $row["id_ins"];
$Datains = $row["inserito"];
$anno = getYear($DataCalendario);
$mese = getMonth($DataCalendario);
$giorno = getDay($DataCalendario);
$annoins = getYear($Datains);
$meseins = getMonth($Datains);
$giornoins = getDay($Datains);
$orains = getHour($Datains);
$minutiins = getMinutes($Datains);
$datains2 = $giornoins."-".$meseins."-".$annoins." alle ".$orains.":".$minutiins;
$IDmod = $row["id_mod"];
$Datamod = $row["modifica"];
$annomod = getYear($Datamod);
$mesemod = getMonth($Datamod);
$giornomod = getDay($Datamod);
$oramod = getHour($Datamod);
$minutimod = getMinutes($Datamod);
$datamod2 = $giornomod."-".$mesemod."-".$annomod." alle ".$oramod.":".$minutimod;
$query2 = "SELECT * FROM users WHERE id = '$IDins'";
$result2 = mysql_query($query2, $db);
$row2 = mysql_fetch_array($result2);
$UserIns = $row2["username"];
$query3 = "SELECT * FROM users WHERE id = '$IDmod'";
$result3 = mysql_query($query3, $db);
$row3 = mysql_fetch_array($result3);
$UserMod = $row3["username"];
$query6 = "SELECT * FROM stagioni where id = '$Stagione'";
$result6 = mysql_query($query6, $db);
$row6 = mysql_fetch_array($result6);
$AlStagione = $row6["al"];
$annoAl = getYear($AlStagione);
$meseAl = getMonth($AlStagione);
$giornoAl = getDay($AlStagione);
$goggi = date("d");
$moggi = date("m");
$aoggi = date("Y");
if ($giornoAl >= $goggi and $meseAl >= $moggi and $annoAl >= $aoggi) {
?>
<form action="pag2.php?Pag=mod_calendario&Stagione=<? echo $Stagione ?>&pg=<? echo $pg ?>" method="post" name="ModCalendario<? echo $num ?>">
<center>
<table border="1" bordercolor="#000000" cellpadding="2" cellspacing="0" width="750">
<tr>
<td width="30%">Torneo/Campionato</td>
<td><select name="Torneo">
<option value="" selected></option>
<?
$query5 = "SELECT * FROM tornei where stagione = '$Stagione' order by nome desc";
$result5 = mysql_query($query5, $db);
while ($row5 = mysql_fetch_array($result5)) {
$value = $row5["id"];
$Titolo = $row5["nome"];
if ($value==$TorneoCalendario) {
$selectb3 = " selected";
} else {
$selectb3 = "";
}
echo "<option value=\"$value\"$selectb3>$Titolo</option>";
}
?>
</select>
<?
echo " <input name=\"ID\" type=\"hidden\" value=\"$ID_Calendario\" />
inserito da $UserIns il $datains2
ultima mod. di $UserMod il $datamod2";
?>
</td>
</tr>
<tr>
<td>Giornata</td>
<td><input name="Giornata" type="text" size="2" maxlength="255" value="<? echo $GiornataCalendario ?>" /></td>
</tr>
<tr>
<td width="30%">Andata/Ritorno</td>
<td>
<select name="AndataRitorno">
<option value=""></option>
<option value="Andata"<? echo $selectb1 ?>>Andata</option>
<option value="Ritorno"<? echo $selectb2 ?>>Ritorno</option>
</select></td>
</tr>
<tr>
<td>Turno</td>
<td><input name="Turno" type="text" size="2" maxlength="255" value="<? echo $TurnoCalendario ?>" /></td>
</tr>
<tr>
<td>Data</td>
<?
if ($giorno=="01") {
$select[1] = "selected ";
} elseif ($giorno=="02") {
$select[2] = "selected ";
} elseif ($giorno=="03") {
$select[3] = "selected ";
} elseif ($giorno=="04") {
$select[4] = "selected ";
} elseif ($giorno=="05") {
$select[5] = "selected ";
} elseif ($giorno=="06") {
$select[6] = "selected ";
} elseif ($giorno=="07") {
$select[7] = "selected ";
} elseif ($giorno=="08") {
$select[8] = "selected ";
} elseif ($giorno=="09") {
$select[9] = "selected ";
} elseif ($giorno=="10") {
$select[10] = "selected ";
} elseif ($giorno=="11") {
$select[11] = "selected ";
} elseif ($giorno=="12") {
$select[12] = "selected ";
} elseif ($giorno=="13") {
$select[13] = "selected ";
} elseif ($giorno=="14") {
$select[14] = "selected ";
} elseif ($giorno=="15") {
$select[15] = "selected ";
} elseif ($giorno=="16") {
$select[16] = "selected ";
} elseif ($giorno=="17") {
$select[17] = "selected ";
} elseif ($giorno=="18") {
$select[18] = "selected ";
} elseif ($giorno=="19") {
$select[19] = "selected ";
} elseif ($giorno=="20") {
$select[20] = "selected ";
} elseif ($giorno=="21") {
$select[21] = "selected ";
} elseif ($giorno=="22") {
$select[22] = "selected ";
} elseif ($giorno=="23") {
$select[23] = "selected ";
} elseif ($giorno=="24") {
$select[24] = "selected ";
} elseif ($giorno=="25") {
$select[25] = "selected ";
} elseif ($giorno=="26") {
$select[26] = "selected ";
} elseif ($giorno=="27") {
$select[27] = "selected ";
} elseif ($giorno=="28") {
$select[28] = "selected ";
} elseif ($giorno=="29") {
$select[29] = "selected ";
} elseif ($giorno=="30") {
$select[30] = "selected ";
} elseif ($giorno=="31") {
$select[31] = "selected ";
}
if ($mese=="01") {
$selec[1] = "selected ";
} elseif ($mese=="02") {
$selec[2] = "selected ";
} elseif ($mese=="03") {
$selec[3] = "selected ";
} elseif ($mese=="04") {
$selec[4] = "selected ";
} elseif ($mese=="05") {
$selec[5] = "selected ";
} elseif ($mese=="06") {
$selec[6] = "selected ";
} elseif ($mese=="07") {
$selec[7] = "selected ";
} elseif ($mese=="08") {
$selec[8] = "selected ";
} elseif ($mese=="09") {
$selec[9] = "selected ";
} elseif ($mese=="10") {
$selec[10] = "selected ";
} elseif ($mese=="11") {
$selec[11] = "selected ";
} elseif ($mese=="12") {
$selec[12] = "selected ";
}
$anno_prima = $anno - 1;
$anno_dopo = $anno + 1;
?>
<td><select name="Giorno">
<option value=""></option>
<option value="01" <? echo $select[1]; ?>>01</option>
<option value="02" <? echo $select[2]; ?>>02</option>
<option value="03" <? echo $select[3]; ?>>03</option>
<option value="04" <? echo $select[4]; ?>>04</option>
<option value="05" <? echo $select[5]; ?>>05</option>
<option value="06" <? echo $select[6]; ?>>06</option>
<option value="07" <? echo $select[7]; ?>>07</option>
<option value="08" <? echo $select[8]; ?>>08</option>
<option value="09" <? echo $select[9]; ?>>09</option>
<option value="10" <? echo $select[10]; ?>>10</option>
<option value="11" <? echo $select[11]; ?>>11</option>
<option value="12" <? echo $select[12]; ?>>12</option>
<option value="13" <? echo $select[13]; ?>>13</option>
<option value="14" <? echo $select[14]; ?>>14</option>
<option value="15" <? echo $select[15]; ?>>15</option>
<option value="16" <? echo $select[16]; ?>>16</option>
<option value="17" <? echo $select[17]; ?>>17</option>
<option value="18" <? echo $select[18]; ?>>18</option>
<option value="19" <? echo $select[19]; ?>>19</option>
<option value="20" <? echo $select[20]; ?>>20</option>
<option value="21" <? echo $select[21]; ?>>21</option>
<option value="22" <? echo $select[22]; ?>>22</option>
<option value="23" <? echo $select[23]; ?>>23</option>
<option value="24" <? echo $select[24]; ?>>24</option>
<option value="25" <? echo $select[25]; ?>>25</option>
<option value="26" <? echo $select[26]; ?>>26</option>
<option value="27" <? echo $select[27]; ?>>27</option>
<option value="28" <? echo $select[28]; ?>>28</option>
<option value="29" <? echo $select[29]; ?>>29</option>
<option value="30" <? echo $select[30]; ?>>30</option>
<option value="31" <? echo $select[31]; ?>>31</option>
</select> - <select name="Mese">
<option value=""></option>
<option value="01" <? echo $selec[1]; ?>>01</option>
<option value="02" <? echo $selec[2]; ?>>02</option>
<option value="03" <? echo $selec[3]; ?>>03</option>
<option value="04" <? echo $selec[4]; ?>>04</option>
<option value="05" <? echo $selec[5]; ?>>05</option>
<option value="06" <? echo $selec[6]; ?>>06</option>
<option value="07" <? echo $selec[7]; ?>>07</option>
<option value="08" <? echo $selec[8]; ?>>08</option>
<option value="09" <? echo $selec[9]; ?>>09</option>
<option value="10" <? echo $selec[10]; ?>>10</option>
<option value="11" <? echo $selec[11]; ?>>11</option>
<option value="12" <? echo $selec[12]; ?>>12</option>
</select> - <select name="Anno">
<option value=""></option>
<option value="<? echo $anno_prima; ?>"><? echo $anno_prima; ?></option>
<option value="<? echo $anno; ?>" selected><? echo $anno; ?></option>
<option value="<? echo $anno_dopo; ?>"><? echo $anno_dopo; ?></option>
</select></td>
</tr>
<tr>
<td>Modifica / Elimina</td>
<? echo " <td><a href=\"#\" onclick=\"document.forms['ModCalendario$num'].submit();\">Modifica</a> / <a href=\"pag2.php?Pag=can_calendario&ID=$ID_Calendario&Stagione=$Stagione\">Elimina</a></td>"; ?>
</tr>
</table>
</center>
</form>
<?
}
}
?>