<?
function blanktd(){
echo("<td width='25' align='center'>"." "."</td>");
}
function evento($var){
$conn=mysql_connect("localhost","root","");
mysql_select_db("database");
$select="SELECT DISTINCT eventdate FROM tevents ORDER BY eventdate";
$recordset=mysql_query($select);
for ($w=0; $w<=$var;$w++){
$record=mysql_fetch_array($recordset);
}
return $record["eventdate"];
}
$i = date("m");
switch ($i) {
case '01':
$mese[$i] = 'January';
break;
case '02':
$mese[$i] = 'February';
break;
case '03':
/*20*/ $mese[$i] = 'March';
break;
case '04':
$mese[$i] = 'April';
break;
case '05':
$mese[$i] = 'May';
break;
case '06':
$mese[$i] = 'June';
/*30*/ break;
case '07':
$mese[$i] = 'July';
break;
case '08':
$mese[$i] = 'Agust';
break;
case '09':
$mese[$i] = 'September';
break;
/*40*/ case '10':
$mese[$i] = 'October';
break;
case '11':
$mese[$i] = 'November';
break;
case '12':
$mese[$i] = December';
}
echo("<table border='1' width='151' cellspacing='0' cellpadding='0'>");
/*50*/echo("<tr>");
echo("<td colspan='7' align='center'>");
echo("<b>".$mese[$i]."</b>");
echo(date("<b>"." Y"."</b>"));
echo("</td>"."</tr>");
echo("<tr>"."<td width='25' align='center'>");
echo("<b>L</b>"."</td>");
echo("<td width='25' align='center'>"."<b>M</b>"."</td>");
echo("<td width='25' align='center'>"."<b>M</b>"."</td>");
echo("<td width='25' align='center'>"."<b>G</b>"."</td>");
/*60*/echo("<td width='25' align='center'>"."<b>V</b>"."</td>");
echo("<td width='25' align='center'>"."<b>S</b>"."</td>");
echo("<td width='25' align='center'>"."<b>D</b>"."</td>"."</tr>");
$k=date("D", mktime(23,1,0,$i,01,2006));
switch ($k){
case 'Mon':
$cont = 0;
break;
case 'Tue':
$cont = 1;
/*70*/ break;
case 'Wed':
$cont = 2;
break;
case 'Thu':
$cont = 3;
break;
case 'Fri':
$cont = 4;
break;
/*80*/ case 'Sat':
$cont = 5;
break;
case 'Sun':
$cont = 6;
break;
}
echo("<tr>");
for ($ind=1; $ind<=$cont; $ind++){
blanktd();
/*90*/}
if ($i == '02'){
$limit = 28;
}elseif (($i == '01')||($i == '03')||($i == '05')||($i == '07')||($i == '08')||($i == '10')||($i == '12')){
$limit = 31;
}else{
$limit = 30;
}
$oggi = date("d");
$oggiext=date("Y-m-d");
$num= 0;
echo($oggi);
for ($j=1; $j<=$limit; $j++){
$l = date("D", mktime(23,1,0,$i,$j,2006));
$event=evento($num);
if(($event == date("Y-m-d", mktime(23,1,0,$i,$j,2006)))&&($event == date("Y-m-d", mktime(23,1,0,$i,$j,2006)))&&($oggi== date("d", mktime(23,1,0,$i,$j,2006)))){
echo("<td width='25' align='center' bordercolor='#ff0000'>"."<a href='vedieventi.php?id='$event'>"."$j"."</a>"."</td>");
if($l=='Sun'){
echo("</tr>"."<tr>");
}$num++;
}
elseif(($l=='Sun')&&($event==date("Y-m-d", mktime(23,1,0,$i,$j,2006)))){
echo("<td width='25' align='center' bordercolor='#0000ff'>"."<a href='vedieventi.php?id=$event'>"."$j"."</a>"."</td>");
echo("</tr>"."<tr>");
$num++;
}
elseif(($l=='Sun')&&($oggi== date("d", mktime(23,1,0,$i,$j,2006)))){
echo("<td width='25' align='center' bordercolor='ff0000'>"."$j"."</td>");
if ($l=='Sun'){
echo("</tr>"."<tr>");
}
}
elseif($oggi== date("d", mktime(23,1,0,$i,$j,2006))&&($event == date("Y-m-d", mktime(23,1,0,$i,$j,2006)))){
echo("<td align='center' width='25' bordercolor='ff0000'>"."<a href='vedieventi.php?id=$event'>"."$j"."</a>"."</td>");
}
elseif($l=='Sun'){
echo("<td width='25' align='center'>"."$j"."</td>");
echo("</tr>"."<tr>");
}
elseif($event==date("Y-m-d", mktime(23,1,0,$i,$j,2006))){
echo("<td width='25' align='center' bordercolor='#0000ff'>"."<a href='vedieventi.php?id=$event'>"."$j"."</a>"."</td>");
$num++;
}
elseif($oggiext == date("Y-m-d", mktime(23,1,0,$i,$j,2006))){
echo("<td width='25' align='center' bordercolor='#ff0000'>"."$j"."</td>");
}
elseif($l <> 'Sun'){
echo("<td width='25' align='center'>"."$j"."</td>");
}
}
echo("</tr>");
echo("</table>");
?>
|
|
Store
Your email: