codice:<html> <head> </head> <body> <div style="width:50%;"> <table style="background-color: lightSkyBlue;" summary="" > <?php require ("db_config.php"); $record=array(); $query=array(); $prova = mysql_query("select camere,checkin,checkout from `villa_pren`"); while ($result = mysql_fetch_array($prova) ) { $query['camere']=$result['camere']; $query['checkin']=$result['checkin']; $query['checkout']=$result['checkout']; $record[]=$query; } for($i = 0, $size = sizeof($record); $i < $size; ++$i) { $camere=$record[$i]['camere']; $checkin=$record[$i]['checkin']; $checkout=$record[$i]['checkout']; $giorno=$checkin[8].$checkin[9]; $mese=$checkin[5].$checkin[6]; $anno=$mese=$checkin[0].$checkin[1].$checkin[2].$checkin[3]; } $d=date('d'); $d1=$d; for($i=1; $i<=5;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo"<tr></tr>"; for($i=6; $i<=10;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo "<tr></tr>"; for($i=11; $i<=15;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo "<tr></tr>"; for($i=16; $i<=20;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo "<tr></tr>"; for($i=21; $i<=25;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo "<tr></tr>"; for($i=26; $i<=30;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } echo "<tr></tr>"; for($i=31; $i<=31;$i++) { if($i==$giorno){ echo"<td><textarea style='color: darkGreen;font-weight: bolder;font-family: sans, cursive;' readonly>".$i." ".$camere."</textarea></td>"; }else { echo"<td><textarea readonly>".$i."</textarea></td>"; } } ?> <select name="mese"> <?php $mese_corrente=date('M'); //mese corrente come stringa if($mese=$mese_corrente) { $mese_corrente=date('m'); // trasformo il mese corrente da stringa a intero $d1=1;$d2=2;$d3=3;$d4=4;$d5=5;$d6=6;$d7=7;$d8=8;$d9=9; $c=$mese_corrente; echo "<option title=\"$c\" value=\"$c\">".$c."</option>"; for($i=$c+1; $i<=12;$i++) { //SE IL MESE È 1,2,3,4,5,6,7,8,9 aggiungo uno 0 in testa alla stringa if($i==$d1 || $i==$d2 || $i==$d3 || $i==$d4 || $i==$d5 || $i==$d6 || $i==$d7 || $i==$d8 || $i==$d9) { $giorno="0".$i; echo "<option title=\"$giorno\" value=\"$giorno\">".$giorno."</option>"; } else echo "<option title=\"$i\" value=\"$i\">".$i."</option>"; } if($c==12) { for($i=1; $i<=12;$i++) { //SE IL MESE È 1,2,3,4,5,6,7,8,9 aggiungo uno 0 in testa alla stringa if($i==$d1 || $i==$d2 || $i==$d3 || $i==$d4 || $i==$d5 || $i==$d6 || $i==$d7 || $i==$d8 || $i==$d9) { $giorno="0".$i; echo "<option title=\"$giorno\" value=\"$giorno\">".$giorno."</option>"; } else echo "<option title=\"$i\" value=\"$i\">".$i."</option>"; } } } ?> </select> <select name="anno"> <?php $y=date('Y'); $next_year=$y+1; echo"<option title=\"$y\" value=\"$y\">".$y."</option>"; echo "<option title='$next_year' value='$next_year'>".$next_year."</option>"; ?> </select> </table> </div> </body> </html>

Rispondi quotando