Kalender problemer.
Hejjeg har et lille problem med min kalender, for jeg vil gerne have at man kan klikke på eventet også kan man læse mere det, men hvordan trækker jeg id´et ud?
Koden ser således ud:
<?php
setlocale(LC_ALL, "da_DK");
date_default_timezone_set("Europe/Copenhagen");
header("Content-Type: text/html; charset=ISO-8859-1");
$events = array();
$mysql_hostname = "localhost";
$mysql_username = "user";
$mysql_password = "pass";
$mysql_database = "database";
$db = new mysqli($mysql_hostname, $mysql_username, $mysql_password, $mysql_database);
$month = (int)$_GET["month"];
$year = (int)$_GET["year"];
if( !checkdate($month, 1, $year) )
$start = mktime(0, 0, 0, date("n"), 1, date("Y"));
else
$start = mktime(0, 0, 0, $month, 1, $year);
$end = mktime(23, 59, 59, date("n", $start), date("t", $start), date("Y", $start));
$sql = "SELECT * FROM pCalendar WHERE DATE(pDate) >= '".date("Y-m-d", $start)."' AND DATE(pDate) <= '".date("Y-m-d", $end)."' ORDER BY pDate";
$res = $db->query($sql);
if( $res->num_rows > 0)
{
while ($obj = $res->fetch_object())
{
$timestamp = strtotime($obj->pDate);
$events[date("d", $timestamp)][] = $obj->pDescription;
}
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<title>pCalendar</title>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1" />
<style type="text/css">
*
{
margin: 0px;
padding: 0px;
font-family: Calibri, Verdana, "Sans Serif";
font-size: 11px;
}
#pCalendar
{
width: 600px;
border: 1px solid #CECECE;
margin: 0px auto;
}
#pCalendar label
{
display: block;
color: #CECECE;
}
#pCalendar div
{
padding: 5px;
border-bottom: 1px dashed #CECECE;
}
#pCalendar div.pNavigation
{
text-align: center;
border: none;
}
a.pMonthPrev
{
float: left;
}
a.pMonthNext
{
float: right;
}
#pCalendar ul
{
list-style-type: square;
margin-left: 20px;
}
#pCalendar div.weekendDay
{
background-color: #DEDEDE;
}
</style>
</head>
<body>
<div id="pCalendar">
<div class="pNavigation">
<a class="pMonthPrev" href="?month=<?php echo date("n", ($start-3600)); ?>&year=<?php echo date("Y", ($start-3600)); ?>">Forrige</a>
<a class="pMonthNext" href="?month=<?php echo date("n", ($end+3600)); ?>&year=<?php echo date("Y", ($end+3600)); ?>">Næste</a>
<h1><?php echo ucfirst(strftime("%B", $start));?> <?php echo date("Y", $start); ?></h1>
</div>
<?php for($i = 1; $i <= date("t", $start); $i++):
$class = "";
if( date("w", mktime(0, 0, 0, date("n", $start), $i, date("Y", $start))) == 0 || date("w", mktime(0, 0, 0, date("n", $start), $i, date("Y", $start))) == 6 )
$class = "weekendDay";
?>
<div class="<?php echo $class; ?>">
<label><?php echo $i; ?>.</label>
<p>
<?php if(isset($events[$i])): ?>
<ul>
<?php foreach($events[$i] as $event): ?>
<li><?php echo $event; ?></li>
<?php endforeach; ?>
</ul>
<?php endif; ?>
</p>
</div>
<?php endfor; ?>
</div>
</body>
</html>