http://www.phphulp.nl/php/scripts/3/347/
heb de gegevens in men tabel ingevoegd maar die komen gewoon niet in de kalender voor
De kalender zelf werkt maar hij blijft maar zeggen dat er geen activiteiten zijn.
Vind iemand de fout?
http://cock-front.fubart.be/new/kalender/kalender.php
tabel:
CREATE TABLE `agenda` (
`id` int(11) NOT NULL auto_increment,
`date` varchar(10) NOT NULL default '',
`genre` text NOT NULL,
`title` text NOT NULL,
`details` text NOT NULL,
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM PACK_KEYS=0;
kalender.php
<?php
header("Cache-Control: no-cache, must-revalidate, no-store\nPragma: no-cache\n");
?><HTML>
<HEAD>
<TITLE>Agenda</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</HEAD>
<body>
<center>
<?php
// Connection mysql
$user = "user";
$dbpass = "pass";
$host = "mysqlhost";
$dbdb = "datab";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $dbpass)))
{
echo "Connectie met de database mislukt.";
exit();
}
echo "<table width=\"200\">\n";
echo "<tr><td>";
if($_GET['thismonth'] != "" and $_GET['thisyear'] != "") {
$this_month = $_GET['thismonth'];
$this_year = $_GET['thisyear'];
if ($this_month == 13) {
$this_month = 1;
$this_year = $this_year + 1;
}
elseif ($this_month == 0)
{
$this_month = 12;
$this_year = $this_year - 1;
}
else
{
$this_month = $this_month;
}
}
else {
$this_month = date("n");
$this_year = date("Y");
}
$arraymonth = array(
"Januari",
"Februari",
"Maart",
"April",
"Mei",
"Juni",
"Juli",
"Augustus",
"September",
"Oktober",
"November",
"December"
);
$month_name = $arraymonth[$this_month-1];
/* Navigation */
$last_month = $this_month - 1;
$next_month = $this_month + 1;
echo "<center>";
echo "<table width=\"800\"><tr><td align=\"left\" width=\"200\">\n";
echo "<a href=\"kalender.php?thismonth=$last_month&thisyear=$this_year\" style=\"color:#0D4E95; font-family: Verdana, Arial, Helvetica, sans-serif;\"><b>« Vorige</b></a>";
echo "</td><td align=\"center\" width=\"400\">";
echo "<h1>$month_name $this_year</h1>";
echo "</td><td align=\"right\" width=\"200\">";
echo "<a href=\"kalender.php?thismonth=$next_month&thisyear=$this_year\" style=\"color:#0D4E95; font-family: Verdana, Arial, Helvetica, sans-serif;\"><b>Volgende »</b></a>";
echo "</td></tr></table>";
echo "</center>";
/* Titels van de kalender */
echo "<table width=\"820\" cellspacing=\"1\" cellpadding=\"0\" style=\"border: solid #AAAAAA 1px;\">\n";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Maandag</td>";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Dinsdag</td>";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Woensdag</td>";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Donderdag</td>";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Vrijdag</td>";
echo "<td height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Zaterdag</td>";
echo "<td height=\"5\" style=\"text-align: center;\">Zondag</td>";
echo "</td></tr>";
/* De maand berekenen */
$first_day = date("w", mktime(0, 0, 0, $this_month, 1, $this_year));
$total_days = date("t", mktime(0, 0, 0, $this_month, 1, $this_year));
$week_num = 1;
$day_num = 1;
$the_day = " ";
/* Het aantal weken overlopen (primaire teller in het proces) */
while ($week_num <= 6) {
echo "<tr>\n";
/* Het aantal weken overlopen (secundaire teller) */
for ( $i = 1; $i <= 6; $i++ ) {
if ($week_num == 1) {
if ($i < $first_day)
$the_day = " ";
else if ($i == $first_day) {
$the_day = 1;
}
} else {
if ($the_day > $total_days)
$the_day = " ";
}
/* De dagen weergeven */
if ($the_day != " ")
{
if ($the_day == date(j) and $this_month == date("n") and $this_year == date("Y"))
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#CDD2D9'\" bgcolor=#CDD2D9><b>$the_day</b><br>";
}
$querytris="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='feestdag' ORDER BY id";
$resulttris=mysql_query($querytris) or die(mysql_error());
if (mysql_num_rows($resulttris) >= 1)
{
echo "<font style=\"color:#404040; font-size:90%;\"><center><b>";
while ($rowtris = mysql_fetch_array($resulttris))
{
echo "".$rowtris['title']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT title FROM agenda WHERE date='$the_day/$this_month' and genre='feestdag' ORDER BY id";
$resultquattro=mysql_query($queryquattro) or die(mysql_error());
if (mysql_num_rows($resultquattro) >= 1)
{
echo "<font style=\"color:#404040;font-size:90%;\"><center><b>";
while ($rowquattro = mysql_fetch_array($resultquattro))
{
echo "".$rowquattro['title']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE verjaardag='$the_day/$this_month' ORDER BY id";
$result=mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Verjaardag:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($row = mysql_fetch_array($result))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$row['login']."</font></td></tr>";
}
echo "</table>";
}
$querybis="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='activité' ORDER BY id";
$resultbis=mysql_query($querybis) or die(mysql_error());
if (mysql_num_rows($resultbis) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Activiteiten:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($rowbis = mysql_fetch_array($resultbis))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$rowbis['title']."</font></td></tr>";
}
echo "</table>";
}
echo "</td>";
}
else
{
echo "<td valign=\"top\" bgcolor=\"#DFDFDF\"></td>";
}
/* De volgende dag berekenen */
if ($the_day != " ")
$the_day++;
}
if ($week_num == 1) {
if ($first_day == 0) {
$the_day = 1;
if ($the_day == date(j) and $this_month == date("n") and $this_year == date("Y"))
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='feestdag' ORDER BY id";
$resulttris=mysql_query($querytris) or die(mysql_error());
if (mysql_num_rows($resulttris) >= 1)
{
echo "<font style=\"color:#404040; font-size:90%;\"><center><b>";
while ($rowtris = mysql_fetch_array($resulttris))
{
echo "".$rowtris['title']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT title FROM agenda WHERE date='$the_day/$this_month' and genre='feestdag' ORDER BY id";
$resultquattro=mysql_query($queryquattro) or die(mysql_error());
if (mysql_num_rows($resultquattro) >= 1)
{
echo "<font style=\"color:#404040;font-size:90%;\"><center><b>";
while ($rowquattro = mysql_fetch_array($resultquattro))
{
echo "".$rowquattro['title']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE verjaardag='$the_day/$this_month' ORDER BY id";
$result=mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Verjaardag:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($row = mysql_fetch_array($result))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$row['login']."</font></td></tr>";
}
echo "</table>";
}
$querybis="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='activité' ORDER BY id";
$resultbis=mysql_query($querybis) or die(mysql_error());
if (mysql_num_rows($resultbis) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Activiteiten:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($rowbis = mysql_fetch_array($resultbis))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$rowbis['title']."</font></td></tr>";
}
echo "</table>";
}
echo "</td>";
echo "</tr>";
$the_day++;
}
else {
if ($the_day == date(j) and $this_month == date("n") and $this_year == date("Y"))
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='feestdag' ORDER BY id";
$resulttris=mysql_query($querytris) or die(mysql_error());
if (mysql_num_rows($resulttris) >= 1)
{
echo "<font style=\"color:#404040; font-size:90%;\"><center><b>";
while ($rowtris = mysql_fetch_array($resulttris))
{
echo "".$rowtris['title']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT title FROM agenda WHERE date='$the_day/$this_month' and genre='feestdag' ORDER BY id";
$resultquattro=mysql_query($queryquattro) or die(mysql_error());
if (mysql_num_rows($resultquattro) >= 1)
{
echo "<font style=\"color:#404040;font-size:90%;\"><center><b>";
while ($rowquattro = mysql_fetch_array($resultquattro))
{
echo "".$rowquattro['title']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE verjaardag='$the_day/$this_month' ORDER BY id";
$result=mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Verjaardag:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($row = mysql_fetch_array($result))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$row['login']."</font></td></tr>";
}
echo "</table>";
}
$querybis="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='activité' ORDER BY id";
$resultbis=mysql_query($querybis) or die(mysql_error());
if (mysql_num_rows($resultbis) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Activiteiten:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($rowbis = mysql_fetch_array($resultbis))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$rowbis['title']."</font></td></tr>";
}
echo "</table>";
}
echo "</td>";
echo "</tr>";
$the_day++;
}
}
elseif ($the_day > $total_days) {
$the_day = " ";
echo "<td valign=\"top\" bgcolor=\"#DFDFDF\"></td>";
echo "</tr>";
}
elseif ($the_day != " ") {
if ($the_day == date(j) and $this_month == date("n") and $this_year == date("Y"))
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" onclick=\"window.location.href='kalenderdag.php?day=$the_day&month=$this_month&year=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='feestdag' ORDER BY id";
$resulttris=mysql_query($querytris) or die(mysql_error());
if (mysql_num_rows($resulttris) >= 1)
{
echo "<font style=\"color:#404040; font-size:90%;\"><center><b>";
while ($rowtris = mysql_fetch_array($resulttris))
{
echo "".$rowtris['title']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT title FROM agenda WHERE date='$the_day/$this_month' and genre='feestdag' ORDER BY id";
$resultquattro=mysql_query($queryquattro) or die(mysql_error());
if (mysql_num_rows($resultquattro) >= 1)
{
echo "<font style=\"color:#404040;font-size:90%;\"><center><b>";
while ($rowquattro = mysql_fetch_array($resultquattro))
{
echo "".$rowquattro['title']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE verjaardag='$the_day/$this_month' ORDER BY id";
$result=mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Verjaardag:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($row = mysql_fetch_array($result))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$row['login']."</font></td></tr>";
}
echo "</table>";
}
$querybis="SELECT title FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='activité' ORDER BY id";
$resultbis=mysql_query($querybis) or die(mysql_error());
if (mysql_num_rows($resultbis) >= 1)
{
echo "<font style=\"sidered\" style=\"font-size:90%;\">Activiteiten:</font>";
echo "<br><table padding=\"0\" spacing=\"0\" style=\"margin-left: 2px; line-height: 60% ;\">";
while ($rowbis = mysql_fetch_array($resultbis))
{
echo "<tr><td><font style=\"color: black; font-size:90%;\">» ".$rowbis['title']."</font></td></tr>";
}
echo "</table>";
}
echo "</td>";
echo "</tr>";
$the_day++;
}
else {
$the_day = " ";
echo "<td valign=\"top\" bgcolor=\"#DFDFDF\"></td>";
echo "</tr>";
}
$week_num++;
}
echo "</table>";
echo "</td></tr>";
echo "</table>";
?>
<br>
</center>
</body>
</html>kalenderdag.php
<?php
header("Cache-Control: no-cache, must-revalidate, no-store\nPragma: no-cache\n");
?>
<HTML>
<HEAD>
<TITLE>Agenda</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</HEAD>
<body>
<center>
<?php
$day = $_GET['day'];
$month = $_GET['month'];
$year = $_GET['year'];
$jds = date("w", mktime(0, 0, 0, $month, $day, $year));
$arrayday = array(
"Zondag",
"Maandag",
"Dinsdag",
"Woensdag",
"Donderdag",
"Vrijdag",
"Zaterdag"
);
$day_name = $arrayday[$jds];
$arraymonth = array(
"januari",
"februari",
"maart",
"april",
"mei",
"juni",
"juli",
"augustus",
"september",
"oktober",
"november",
"december"
);
$month_name = $arraymonth[$month-1];
// Mysql connectie
$user = "user";
$dbpass = "pass";
$host = "mysqlhost";
$dbdb = "datab";
if (!mysql_select_db($dbdb, mysql_connect($host, $user, $dbpass)))
{
echo "Verbinding met de database mislukt.";
exit();
}
?>
<h1>Agenda</h1><br>
<center><table width="350" height="350"><tr><td height="15" style="padding: 0px; margin: 0px; font: 14px Verdana, Arial; font-weight: normal; background-color: #FFFFFF; color: #AAAAAA; border: solid 1px #AAAAAA;">
<?php
echo "<center>$day_name $day $month_name $year</center>";
?>
</td></tr>
<tr><td bgcolor="#CDD2D9" valign="top" style="padding: 5px; border: solid 1px #AAAAAA;">
<?php
$querytris="SELECT title FROM agenda WHERE date='$day/$month/$year' and genre='feestdag' ORDER BY id";
$resulttris=mysql_query($querytris) or die(mysql_error());
if (mysql_num_rows($resulttris) >= 1)
{
echo "<font style=\"color:#404040;\"><center><b>";
while ($rowtris = mysql_fetch_array($resulttris))
{
echo "".$rowtris['title']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT title FROM agenda WHERE date='$day/$month' and genre='feestdag' ORDER BY id";
$resultquattro=mysql_query($queryquattro) or die(mysql_error());
if (mysql_num_rows($resultquattro) >= 1)
{
echo "<font style=\"color:#404040;\"><center><b>";
while ($rowquattro = mysql_fetch_array($resultquattro))
{
echo "".$rowquattro['title']."";
}
echo "</b></center></font><br>";
}
$query="SELECT naam,voornaam,email,section FROM members WHERE verjaardag='$day/$month' ORDER BY id";
$result=mysql_query($query) or die(mysql_error());
if (mysql_num_rows($result) >= 1)
{
echo "<font><b>Verjaardag:</b></font><br>";
while ($row = mysql_fetch_array($result))
{
echo "<table><tr><td style=\"padding-left: 15px;\">";
echo "<font>» Verjaardag van ".$row['login']."</font><br>";
echo "<table><tr><td style=\"padding-left: 15px;\">".$row['voornaam']." ".$row['naam']."<br>";
echo "Afdeling: ".$row['section']."<br>";
echo "Email: ".$row['email']."</td></tr></table></td></tr></table>";
}
echo "<br>";
}
echo "<font><b>Activiteiten:</b></font><br>";
$querybis="SELECT title,details FROM agenda WHERE date='$day/$month/$year' and genre='activiteit' ORDER BY id";
$resultbis=mysql_query($querybis) or die(mysql_error());
if (mysql_num_rows($resultbis) >= 1)
{
while ($rowbis = mysql_fetch_array($resultbis))
{
echo "<table><tr><td style=\"padding-left: 15px;\">";
echo "<font>» ".$rowbis['title']."</font><br>";
echo "<table><tr><td style=\"padding-left: 15px;\">".$rowbis['details']."";
echo "</td></tr></table></td></tr></table>";
}
echo "<br>";
}
else
{
echo "<table><tr><td style=\"padding-left: 15px;\">";
echo "Geen activiteiten<br></td></tr></table>";
}
?>
</td></tr></table>
</center><br><br><br>
</center>
</body>
</html>
thx
