[RESOLVED] Calendar Question

obrienkev

Hi all,

How do I create a calendar with the days of each month, and the user should be able to select whatever date they want.

Then based on their selection a file from a database table with the same date opens.

Any ideas how I go about doing this?

thanks,

Kevin.

BIOSTALL

Well... first you'd need to draw out the calender... I would do this by using for loops. You'd need to get the amount of days in each month though. So something like:

$current_month = $_GET['month'];
$no_of_days = mcal_days_in_month($current_month); //gets amount of days in month

echo "<table><tr>";
for ($i=1; $i=10; $i++) {
      echo "<td><a href='getfromdb.php'>$i</a></td>";
}
echo "</tr><tr>";
for ($i=11; $i=20; $i++) {
      echo "<td><a href='getfromdb.php'>$i</a></td>";
}
echo "</tr><tr>";
for ($i=21; $i=$no_of_days; $i++) {
      echo "<td><a href='getfromdb.php'>$i</a></td>";
}
if ($no_of_days >30) {
echo "</tr><tr><td><a href='getfromdb.php'>31</a></td></tr></table>";
}else{
echo "</tr></table>";
}

Something like that anyway 🙂

Hope that helps

BIOSTALL

obrienkev

Been working on this code but for some reason I am unable to select a month. Why is that?
If I echo out

else {
$date = getdate();
}

only 26 days appear and the month name disappears. Again why is this?

<?php
echo "
<html>
<head>
<body bgcolor=#FFFFFF>
<center>
";
// Check for a Month Change submission

if ($submit) {

// Subtract one from the month for previous, add one for next

if ($submit == "Prev") {
$month_now--;
} else {
$month_now++; }

$date = getdate(mktime(0,0,0,$month_now,1,$year_now));

} else {
$date = getdate();
}

$month_num = $date["mon"];
$month_name = $date["month"];
$year = $date["year"];
$date_today = getdate(mktime(0,0,0,$month_num,1,$year));
$first_week_day = $date_today["wday"];
$cont = true;
$today = 27;

while (($today <= 32) && ($cont)) {
$date_today = getdate(mktime(0,0,0,$month_num,$today,$year));

if ($date_today["mon"] != $month_num) {
$lastday = $today - 1;
$cont = false;
}

$today++;
}

// allow for form submission to the script for forward and backwards

echo"
<form action=\"calendar3.php\" method=\"POST\" name=\"calendar\">

<input type=\"hidden\" name=\"month_now\" value=\"$month_num\">
<input type=\"hidden\" name=\"year_now\" value=\"$year\">
<table width=\"200\">
<tr><td><input type=\"submit\" name=\"submit\" value=\"Prev\"></td>
    <td align=right><input
type=\"submit\" name=\"submit\" value=\"Next\"></td>
</tr>
</table>
</form>

<table width=\"160\" border=\"1\" cellspacing=0 cellpadding=2>
<tr><td colspan=\"7\">$month_name $year</td></tr>
<tr><td>Su</td><td>M</td><td>T</td><td>W</td><td>Th</td><td>F</td><td>Sat</td></
tr>";

// begin placement of days according to their beginning weekday

$day = 1;
$wday = $first_week_day;
$firstweek = true;
while ( $day <= $lastday) {
if ($firstweek) {
echo "<TR>";
for ($i=1; $i<=$first_week_day; $i++) {

echo "<TD>  </td>";
}
$firstweek = false;
}
if ($wday==0) {
echo "<tr>";
}

</body>
</html>
";
?>

Thanks,

Kevin.

BIOSTALL

i'm lost lol... wot are you trying to acheive in that last bit of code?? sorry 😛

BIOSTALL

obrienkev

There are Prev and Next buttons which should allow me to go from month to month. However, when I press these buttons the month days the same.

Any ideas?

BIOSTALL

if ($submit == "Prev") { 
$month_now--; 
} else { 
$month_now++; } 

$date = getdate(mktime(0,0,0,$month_now,1,$year_now)); 

} else { 
$date = getdate(); 
}

How can u increment or decrement $month_now if you dont assign it a value in the first place. If you want to get the month from the previous page, either set it as a session variable or pass it in the URL. Ask if you need more info.

BIOSTALL

obrienkev

Hey guys,

Been messing with the below script(courtesy of macromedia.com)

I want to select records from a database table based on whatever day of the month the user clicks on.

How is this done? Here is the calendar script - the user clicks on a date and should be taken to a page that displays the database records based on that date.

<?php

function build_calendar($month,$year,$day)
{
                  $daysOfWeek = array('Su','Mo','Tu','We','Th','Fr','Sa');
              $firstDayOfMonth = mktime(0,0,0,$month,1,$year);
                 $noDays = date('t',$firstDayOfMonth);
                 $dateComponents = getdate($firstDayOfMonth);

             $dayOfWeek = $dateComponents['wday'];
          $monthName = date('F',mktime(0,0,0,$month,1,$year));

             // compute the next and previous month
             if($month == 1)
             {
                               $mn=12;
                       $yn=$year-1;
             }
             else
             {
                           $mn=$month-1;
                       $yn=$year;
             }
             if($month == 12)
             {
                               $mn2=1;
                       $yn2=$year+1;
             }
             else
             {
                           $mn2=$month+1;
                       $yn2=$year;
             }

             // html table
             $calendar = "<table>";
          $calendar .= "<tr><td><a href=mac_calendar.php?m=$mn&y=$yn&d=$day><</a></td>";
          $calendar .="<td colspan=5 align=center>$monthName, $year</td>";
          $calendar .="<td><a href=mac_calendar.php?m=$mn2&y=$yn2&d=$day>></a></td></tr>";

             $calendar .="<tr>";

             // display days of week
             foreach($daysOfWeek as $day)
             {
             $calendar .= "<td>$day</td>";
             }

             $calendar .= "</tr>";

             $calendar .= "<tr>";

             // variable to move through days of month
             $currentDay = 1;

             // ensure table has 7 cols
             if ($dayOfWeek > 0)
             {
          $calendar .= "<td colspan='$dayOfWeek'> </td>";
             }

             // generate days of month
             while ($currentDay <= $noDays)
             {
                       if ($dayOfWeek == 7)
                   {
                               $dayOfWeek = 0;
                               $calendar .= "</tr><tr>";
                   }

                   $calendar .= "<td><a href='#'>$currentDay</a></td>";
                   $currentDay++;
                       $dayOfWeek++;
             }

             // check last day of month is last day of wk
             if ($dayOfWeek != 7)
             {
                          $remainingDays = 7 - $dayOfWeek;
                      $calendar .= "<td colspan='$remainingDays'> </td>";
             }

             $calendar .= "</table>";


             return $calendar;
} // end function

if (isset($_GET['m']) && isset($_GET['y']) && isset($_GET['d'])){
$month = $_GET['m'];
$year = $_GET['y'];
$day = $_GET['d'];
} else {
$dateComponents = getdate();
$month = $dateComponents['mon'];
$year = $dateComponents['year'];
$day = $dateComponents['mday'];
}

echo build_calendar($month,$year,$day);
?>

My database table uses type date. So guess query should be like this...
$query = "SELECT * from archive WHERE file_date = $date";

Thanks,

Kevin.

BIOSTALL

"SELECT * FROM tablename WHERE month_day='$required_variable'"