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>
Permessi di invio
Rispondi quotando