Calendar - ran into some problems.

[louisp]

I am editing an existing calendar so that it displays urls such as :

calendar.php?date=2003-12-08

I can do that alright but the calendar will not display anything other than January 1970. Please help.

<?php 
// Gather variables from 
// user input and break them 
// down for usage in our script 

if(!isset($_REQUEST['date'])){ 
   $date = date("Y-m-d",mktime(0,0,0,date('m'), date('d'), date('Y'))); 
} else { 
   $date = $_REQUEST['date']; 
} 

$day = date('d', $date); 
$month = date('m', $date); 
$year = date('Y', $date); 

// Get the first day of the month 
$month_start = mktime(0,0,0,$month, 1, $year); 

// Get friendly month name 
$month_name = date('F', $month_start); 

// Figure out which day of the week 
// the month starts on. 
$month_start_day = date('D', $month_start); 

switch($month_start_day){ 
    case "Sun": $offset = 0; break; 
    case "Mon": $offset = 1; break; 
    case "Tue": $offset = 2; break; 
    case "Wed": $offset = 3; break; 
    case "Thu": $offset = 4; break; 
    case "Fri": $offset = 5; break; 
    case "Sat": $offset = 6; break; 
} 

// determine how many days are in the last month. 
if($month == 1){ 
   $num_days_last = cal_days_in_month(0, 12, ($year -1)); 
} else { 
   $num_days_last = cal_days_in_month(0, ($month -1), $year); 
} 
// determine how many days are in the current month. 
$num_days_current = cal_days_in_month(0, $month, $year); 

// Build an array for the current days 
// in the month 
for($i = 1; $i <= $num_days_current; $i++){ 
    $num_days_array[] = $i; 
} 

// Build an array for the number of days 
// in last month 
for($i = 1; $i <= $num_days_last; $i++){ 
    $num_days_last_array[] = $i; 
} 

// If the $offset from the starting day of the 
// week happens to be Sunday, $offset would be 0, 
// so don't need an offset correction. 

if($offset > 0){ 
    $offset_correction = array_slice($num_days_last_array, -$offset, $offset); 
    $new_count = array_merge($offset_correction, $num_days_array); 
    $offset_count = count($offset_correction); 
} 

// The else statement is to prevent building the $offset array. 
else { 
    $offset_count = 0; 
    $new_count = $num_days_array; 
} 

// count how many days we have with the two 
// previous arrays merged together 
$current_num = count($new_count); 

// Since we will have 5 HTML table rows (TR) 
// with 7 table data entries (TD) 
// we need to fill in 35 TDs 
// so, we will have to figure out 
// how many days to appened to the end 
// of the final array to make it 35 days. 


if($current_num > 35){ 
   $num_weeks = 6; 
   $outset = (42 - $current_num); 
} elseif($current_num < 35){ 
   $num_weeks = 5; 
   $outset = (35 - $current_num); 
} 
if($current_num == 35){ 
   $num_weeks = 5; 
   $outset = 0; 
} 
// Outset Correction 
for($i = 1; $i <= $outset; $i++){ 
   $new_count[] = $i; 
} 

// Now let's "chunk" the $all_days array 
// into weeks. Each week has 7 days 
// so we will array_chunk it into 7 days. 
$weeks = array_chunk($new_count, 7); 


?>

[drawmack]

date() takes a timestamp not a Ymd string, convert the Ymd over to a timestamp and you'll be good to go.

[Pig]

strtotime is great for that.

[louisp]

Thank you guys.. Im now trying to include data from mysql database into the td cells for the days in the selected month.

This is my query:

include_once ('../connection.php');
$result = mysql_query("SELECT * FROM season_fixtures
							where date >= '$year-$month-01'
							and date <= '$year-$month-31'
						ORDER BY date ASC",$db) or die (mysql_error());

I did it like this to reduce the amount of results, hopefully reduces server load.

<?

 $i = 0; 

foreach($weeks AS $week){ 
       echo "<tr>\n"; 

   foreach($week as $d){ 



	 if($i < $offset_count){ 
        echo "<td class=\"nonmonthdays\">\n";
		echo suffix($d);

		echo "</td>\n"; 
     } 
     if(($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)){ 
        if($date == mktime(0,0,0,$month,$d,$year)){ 
		 echo "<td class=\"today\">";
		  echo suffix($d);
		  if($fixdate == date("Y-m-d",mktime(0,0,0,$month,$d,$year))){ 
		  echo $opposition;
		}      
		 echo "</td>\n"; 
       } else { 
           echo "<td class=\"days\">\n";
		   echo suffix($d);
		     if($fixdate == date("Y-m-d",mktime(0,0,0,$month,$d,$year))){ 
		  echo $opposition;
		}      

		   echo "<br>";

		   echo "<br></td>\n";  
       } 
    } elseif(($outset > 0)) { 
        if(($i >= ($num_weeks * 7) - $outset)){ 
           echo "<td class=\"nonmonthdays\">\n";
		   echo suffix($d);

		   echo "</td>\n";
       } 
    } 
    $i++; 
  } 


echo "</tr>\n";  


} 


?> 

I have the following snippets of code, but where ever I put them I get a parse error of somekind or error (even when to my knowledge there is no problem with the code).

if ($row = @mysql_fetch_array($result)) {
do {
	$fixid=$row["fixid"];
	$opposition=$row["opposition"];
	$competition=$row["competition"];
	$kickoff=$row["kickoff"];
	$fixdate=$row["date"];
	$venue=$row["venue"];

// End the database pull
      } while ($row = mysql_fetch_array($result));

} 

again if anyone can help me out, i'd be most grateful!!

[tekky]

Originally posted by louisp

I have the following snippets of code, but where ever I put them I get a parse error of somekind or error (even when to my knowledge there is no problem with the code).

if ($row = @mysql_fetch_array($result)) {
do {
	$fixid=$row["fixid"];
	$opposition=$row["opposition"];
	$competition=$row["competition"];
	$kickoff=$row["kickoff"];
	$fixdate=$row["date"];
	$venue=$row["venue"];

// End the database pull
      } while ($row = mysql_fetch_array($result));

} 

[/b]

if think your if there is causing some problem maybe... then again maybe not... I would think you would want to do...

do { if(blah) { $var=$row['var']; } } while ($row=blah);

[louisp]

Sorry, but I dont understand can you go into more detail please?

[Pig]

he's saying your do/while syntax is funky. I think he is right, but I never use do while since it is deprecated. Try it like this:

if( $row = @mysql_fetch_assoc($result) )
{
$fixid=$row["fixid"];
$opposition=$row["opposition"];
$competition=$row["competition"];
$kickoff=$row["kickoff"];
$fixdate=$row["date"];
$venue=$row["venue"];
}

[louisp]

Thanks, I feel I am getting somewhere now but at present only the 1st result is display (its displayed correctly too!)

<?
if ($row = @mysql_fetch_array($result)) { 

$fixid=$row["fixid"]; 
$opposition=$row["opposition"]; 
$competition=$row["competition"]; 
$kickoff=$row["kickoff"]; 
$fixdate=$row["date"]; 
$venue=$row["venue"];


 $i = 0; 

foreach($weeks AS $week){ 
       echo "<tr>\n"; 

   foreach($week as $d){ 



	 if($i < $offset_count){ 
        echo "<td class=\"nonmonthdays\">\n";
		echo suffix($d);
		echo "</td>\n"; 
     } 
     if(($i >= $offset_count) && ($i < ($num_weeks * 7) - $outset)){ 
        if($date == mktime(0,0,0,$month,$d,$year)){ 
		 echo "<td class=\"today\">";
		  echo suffix($d);
		  if($fixdate == date("Y-m-d",mktime(0,0,0,$month,$d,$year))){
		   echo "<br><b>$opposition ($venue)</b><br>";
		echo "$competition<br>";
		echo "$kickoff<br>";

				}      
		 echo "</td>\n"; 
       } else { 
           echo "<td class=\"days\">\n";
		   echo suffix($d);
		     if($fixdate == date("Y-m-d",mktime(0,0,0,$month,$d,$year))){ 
		  echo "<br><b>$opposition ($venue)</b><br>";
			echo "$competition<br>";
			echo "$kickoff<br>";
			echo "$fixdate<br>";
		}      

		   echo "<br>";

		   echo "<br></td>\n";  
       } 
    } elseif(($outset > 0)) { 
        if(($i >= ($num_weeks * 7) - $outset)){ 
           echo "<td class=\"nonmonthdays\">\n";
		   echo suffix($d);

		   echo "</td>\n";
       } 
    } 
    $i++; 
  } 


echo "</tr>\n";  


} 
// End the database pull 


}while ($row = mysql_fetch_array($result)); 


?>