Ik heb na lang zoeken een script gevonden voor een kalder hier op PHP hulp.
Nu wil de datum naar 01-01-2001 hebben want mijn database is zo ingericht.
Ik heb de maand al goed gekregen maar de dag nog niet.
En de link naar de volgende pagina krijg ik ook niet werkend.
Kan iemand mij helpen?
<?PHP>
<HTML>
<HEAD>
<TITLE>Agenda</TITLE>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body,td,p,select,input,textarea {
color: #333333;
font-size: 11px;
font-family: Verdana, Arial, Helvetica, sans-serif;
margin:0,0,0,0;
}
a{
color: #333333;
font-size: 11px;
font-family: Verdana, Arial, Helvetica, sans-serif;
text-decoration:underline;
}
.style1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #0D4E95;
font-weight: bold;
padding-bottom:0px;
padding-top:0px;
}
a.topnav {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #333333;
font-weight: bold;
text-decoration:none;
}
a.topnav:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #333333;
font-weight: bold;
text-decoration:underline;
}
.sidered {color: #0D4E95; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif;}
.side {color: #333333; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif;}
a.sideredlinks{color: #0D4E95; font-size: 11px; font-family: Verdana, Arial, Helvetica, sans-serif; font-weight: bold;text-decoration:underline; }
h1 {
font-size: 18px;
color: #0D4E95;
}
.base {font-size: 10px;margin-left:28px;}
td.kalalg { padding: 0px; margin: 0px; center: top; font: 11px Verdana, Arial; font-weight: bold; background-color: #FFFFFF; color: #0000CC; line-height: 16px; }
td.kaltit { padding: 0px; margin: 0px; center: top; font: 11px Verdana, Arial; font-weight: normal; background-color: #FFFFFF; color: #AAAAAA; border-bottom: solid 1px #AAAAAA;}
td.kaltexr { width: 117px; padding: 0px; height: 100px; cursor: hand; margin: 0px; font: 11px Verdana, Arial; font-weight: normal; color: #0D4E95; }
-->
</style>
</HEAD>
<body>
<center>
<?php
// Connection mysql
include ('con.php');
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 class=\"kalalg\">";
if($_GET['thismonth'] != "" and $_GET['thisyear'] != "") {
$this_month = $_GET['thismonth'];
$this_year = $_GET['thisyear'];
if ($this_month == 13) {
$this_month = 01;
$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("m");
$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 - 01;
$next_month = $this_month + 01;
echo "<center>";
echo "<table width=\"800\"><tr><td align=\"left\" width=\"200\">\n";
echo "<a href=\"agenda.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=\"agenda.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 class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Maandag</td>";
echo "<td class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Dinsdag</td>";
echo "<td class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Woensdag</td>";
echo "<td class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Donderdag</td>";
echo "<td class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Vrijdag</td>";
echo "<td class=\"kaltit\" height=\"5\" style=\"text-align: center; border-right: solid #AAAAAA 1px;\">Zaterdag</td>";
echo "<td class=\"kaltit\" 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("d") and $this_month == date("m") and $this_year == date("Y"))
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#CDD2D9'\" bgcolor=#CDD2D9><b>$the_day</b><br>";
}
$querytris="SELECT titre FROM agenda WHERE date='$the_day/$this_month/$this_year' 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['titre']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT titre FROM agenda WHERE date='$the_day/$this_month' 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['titre']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE annif='$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 titre 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['titre']."</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("d") and $this_month == date("m") and $this_year == date("Y"))
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT titre FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='jour f�ri�' 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['titre']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT titre FROM agenda WHERE date='$the_day/$this_month' and genre='jour f�ri�' 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['titre']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE annif='$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 titre 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['titre']."</font></td></tr>";
}
echo "</table>";
}
echo "</td>";
echo "</tr>";
$the_day++;
}
else {
if ($the_day == date("d") and $this_month == date("m") and $this_year == date("Y"))
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT titre FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='jour f�ri�' 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['titre']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT titre FROM agenda WHERE date='$the_day/$this_month' 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['titre']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE annif='$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 titre FROM agenda WHERE date='$the_day/$this_month/$this_year' 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['titre']."</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("d") and $this_month == date("m") and $this_year == date("Y"))
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#FEFFBF';\" onMouseOut=\"this.style.backgroundColor='#FEFF97'\" bgcolor=#FEFF97><b>$the_day</b><br>";
}
else
{
echo "<td valign=\"top\" class=\"kaltexr\" onclick=\"window.location.href='jour.php?jour=$the_day&mois=$this_month&annee=$this_year'\" onMouseOver=\"this.style.backgroundColor='#E9ECEF';\" onMouseOut=\"this.style.backgroundColor='#C3C3C3'\" bgcolor=#C3C3C3><b>$the_day</b><br>";
}
$querytris="SELECT titre FROM agenda WHERE date='$the_day/$this_month/$this_year' and genre='jour f�ri�' 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['titre']."";
}
echo "</b></center></font><br>";
}
$queryquattro="SELECT titre FROM agenda WHERE date='$the_day/$this_month' 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['titre']."";
}
echo "</b></center></font><br>";
}
$query="SELECT login FROM members WHERE annif='$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 titre FROM agenda WHERE date='$the_day/$this_month/$this_year' 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['titre']."</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>
<?>
1.692 views