Christian_Belgien sorry for at jeg har svært ved at udtrykke mig sprogliget da jeg er ordblind
pt indtater jeg bare selv info ind i min database
og den skal bruges som du skriver i (1) til mit team
<?php
//This gets today's date
$date = time () ;
//This puts the day, month, and year in seperate variables
$day = date('d', $date) ;
$month1 = date('m', $date) ;
$year1 = date('Y', $date) ;
if($_GET["m"]) {
$month = $_GET["m"];
$year = $_GET["y"];
} else {
$month = date('m', $date) ;
$year = date('Y', $date) ;
}
//Here we generate the first day of the month
$first_day = mktime(0,0,0,$month, 1, $year) ;
//This gets us the month name
$title = date('F', $first_day) ;
//Here we find out what day of the week the first day of the month falls on
$day_of_week = date('D', $first_day) ;
//Once we know what day of the week it falls on, we know how many blank days occure before it. If the first day of the week is a Sunday then it would be zero
switch($day_of_week){
case "Sun": $blank = 0; break;
case "Mon": $blank = 1; break;
case "Tue": $blank = 2; break;
case "Wed": $blank = 3; break;
case "Thu": $blank = 4; break;
case "Fri": $blank = 5; break;
case "Sat": $blank = 6; break;
}
//We then determine how many days are in the current month
$days_in_month = cal_days_in_month(0, $month, $year) ;
// change month
if($month == 12){
$next_month = 1;
$next_year = $year + 1;
}else{
$next_month = $month + 1;
$next_year = $year;
}
if($month == 1){
$prev_month = 12;
$prev_year = $year - 1;
}else{
$prev_month = $month - 1;
$prev_year = $year;
}
//Here we start building the table heads
echo "<table border=1 width=100%>";
echo "<tr><th colspan=7> <center><a href=\"test.php?&m=$prev_month&&y=$prev_year\"><<</a> $title $year <a href=\"test.php?m=$next_month&&y=$next_year\">>></a></center></th></tr>";
echo "<tr><td width=60>$LANG_CALENDER_son</td><td width=60>$LANG_CALENDER_man</td><td width=60>$LANG_CALENDER_tir</td><td width=60>$LANG_CALENDER_ons</td><td width=60>$LANG_CALENDER_tor</td><td width=60>$LANG_CALENDER_fre</td><td width=60>$LANG_CALENDER_lor</td></tr>";
//This counts the days in the week, up to 7
$day_count = 1;
echo "<tr>";
//first we take care of those blank days
while ( $blank > 0 )
{
echo "<td></td>";
$blank = $blank-1;
$day_count++;
}
//sets the first day of the month to 1
$day_num = 1;
//count up the days, untill we've done all of them in the month
while ( $day_num <= $days_in_month )
{
$query = mysql_query("SELECT user FROM calendar WHERE startdate = '$year-$month-$day_num'") or die(mysql_error());
while($row = mysql_fetch_array($query))
{
$user = $row["user"];
}
echo"<td valign=top><a href=\"index.php?page=new&&funk=add&&dnew=$day_num&&mnew=$month&&ynew=$year\">$day_num</a><br />
$user</td>";
$day_num++;
$day_count++;
//Make sure we start a new row every week
if ($day_count > 7)
{
echo "</tr> <tr>";
$day_count = 1;
}
}
//Finaly we finish out the table with some blank details if needed
while ( $day_count >1 && $day_count <=7 )
{
echo "<td></td>";
$day_count++;
}
echo "</tr></table>";
?>
