Calendar problem - not showing all events

csteff24 · December 27, 2009

I have a calendar that allows users to create events - However, if a specific date has multiple events, it only shows one

How can I get them to all show up? preferably as a list...

<?php
...


define("ADAY", (60*60*24));
if ((!isset($_POST["month"])) || (!isset($_POST["year"]))) {
     $nowArray = getdate();
     $month = $nowArray["mon"];
     $year = $nowArray["year"];
}
else {
$month = $_POST["month"];
$year = $_POST["year"];
}
$start = mktime (12, 0, 0, $month, 1, $year);
$firstDayArray = getdate($start);
?>
<html>
<head>
<title><?php echo "Calendar: ".$firstDayArray["month"]."
".$firstDayArray["year"]; ?></title>
<script type="text/javascript">
function eventWindow(url) {
event_popupWin = window.open(url, 'event', 'resizeable=yes, scrollbars=yes, toolbar=no, width=400, height=400');
event_popupWin.opener = self;
}
</script>
<head>
<body>
<h1>Select a Month/Year Combination</h1>
<form method="post" action="<?php echo $_SERVER["PHP_SELF"]; ?>">
<select name="month">
<?php
$months = Array("January","February","March","April","May","June","July","August","September","October","November","December");
for ($x=1; $x <= count($months); $x++) {
echo"<option value=\"$x\"";
if ($x == $month) {
echo " selected";
}
echo ">".$months[$x - 1]."</option>";
}
?>
</select>
<select name="year">
<?php
for ($x=2009; $x<=2015; $x++) {
echo"<option";
if ($x == $year) {
echo " selected";
}
echo ">$x</option>";
}
?>
</select>
<input type="submit" name="submit" value="Go!">
</form>
<br />
<?php
$days = Array("Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat");
echo "<table border=\"1\" cellpadding=\"5\"><tr>\n";
foreach ($days as $day) {
echo "<td style=\"background-color: #CCCCCC;
text-align: center; width: 14%\"><strong>$day</strong></td>\n";
}
for ($count=0; $count < (6*7); $count++) {
$dayArray = getdate($start);
if (($count % 7) == 0) {
if ($dayArray["mon"] != $month) {
break;
} else {
echo "</tr><tr>\n";
}
}
if ($count < $firstDayArray["wday"] || $dayArray["mon"] != $month) {
echo "<td> </td>\n";
} else {
$chkEvent_sql = "SELECT event_title FROM calendar_events WHERE month(event_start) = '".$month."' AND dayofmonth(event_start) = '".$dayArray["mday"]."' AND year(event_start) = '".$year."' ORDER BY event_start";
$chkEvent_res = mysqli_query($mysqli, $chkEvent_sql)
or die(mysqli_error($mysqli));

if (mysqli_num_rows($chkEvent_res) > 0) {
$event_title = "<br/>";
while ($ev = mysqli_fetch_array($chkEvent_res)) {
$event_title = stripslashes($ev["event_title"])."<br/>";
}
mysqli_free_result($chkEvent_res);
} else {
$event_title = "";
}
echo"<td valign=\"top\"><a href=\"javascript:eventWindow
('event.php?m=".$month."&d=".$dayArray["mday"]."&y=$year');\">".$dayArray["mday"]."</a><br/>".$event_title."</td>\n";

unset($event_title);
$start += ADAY;
}
}

echo "</tr></table>";
mysqli_close($mysqli);
?>
</body>
</html>

laffin · December 27, 2009

problem code

while ($ev = mysqli_fetch_array($chkEvent_res)) {
$event_title = stripslashes($ev["event_title"])."<br/>";
}

Reason: your reassigning $event_title so only the last event is shown.

Solution: use concatenation

 $event_title .= stripslashes($ev["event_title"])."<br/>";

Sign In

Calendar problem - not showing all events

Recommended Posts

csteff24

Link to comment

Share on other sites

laffin

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information