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>&laquo; 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 &raquo;</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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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%;\">&raquo; ".$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>
<?>
Het makkelijkste is om een datumtekst te veranderen is het volgende
<?php
$datum = new DateTime('2010-01-01');
echo $datum->format('d-m-Y'); // voor alle geldige karakters zie: http://php.net/manual/en/function.date.php
?>

Je post hier 464 regels code en zegt er niet bij waar je problemen zitten. Geef dus nog even aan waar we moeten kijken in de code.
Het navigatie probleem zit volgens mij hier.
Want hij post bv 7 ipv 07
Maar ik kan er niet van maken:

<?php
$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>&laquo; 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 &raquo;</b></a>";
echo "</td></tr></table>";
echo "</center>";


?>
<?php
// hier ga je met de waardes rekenen waardoor PHP de tekst '01' zal omzetten naar het getal 1 en dus raak je altijd je voorloop nul kwijt.
$last_month = $this_month - 01;
$next_month = $this_month + 01;

// Maar met str_pad() kun je weer voorloop-nullen genereren. Verander bovenstaande regels dus voor deze
$last_month = str_pad($this_month -1, 2, '0', STR_PAD_LEFT);
$next_month = str_pad($this_month +1, 2, '0', STR_PAD_LEFT);
?>
Jurgen de Brouwer op 16/07/2014 19:07:10

Nu wil de datum naar 01-01-2001 hebben want mijn database is zo ingericht.


Dan ben je dus fout begonnen.

Een datum is DATE of DATETIME.
Zoals je het nu hebt kun je nooit sorteren en de vele datumfunctions niet gebruiken.
Volgens mij werkt je code dan nog niet echt goed want dan kun je na maand 12 gewoon naar maand 13,14,15 enz
En andersom ook: van maand 1 naar maand 0, -1, -2 enz.
The San: Ik bedoel natuurlijk 2001-01-01 want anders werkt het date niet in mysql

Frank:
Dit word al opgelost:
<?php>
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");
}
?>
Jurgen de Brouwer op 16/07/2014 19:07:10

Nu wil de datum naar 01-01-2001 hebben want mijn database is zo ingericht.

Wil je daarmee zeggen dat je een datum opslaat in de database als string? Dan zou ik heel erg snel opnieuw beginnen als ik jou was. Elk database systeem (MySQL ook) heeft speciale datatypes om datums in op te slaan en die zijn er niet voor niets. Zo kan je er tenminste correct mee sorteren, selecteren, berekenen etc. Sla je het op als string dan kan je al dat soort acties genoegelijk vaarwel zeggen.

Edit: te lang open laten staan, was inmiddels al aangekaart door anderen....
- SanThe - op 16/07/2014 19:54:21

Dan ben je dus fout begonnen.


Of een fout script gekopieerd.

Het handigste is inderdaad om gewoon met het object DateTime te werken en daarmee dus ook te gaan rekenen met datums: http://php.net/manual/en/class.datetime.php

Let vooral op de functies
add()
sub()
format()
Ik heb ooit zelf een kalender gemaakt, ik wou het nog implementeren met MySQL maar het was later niet nodig. Er zit wel WAT voor in, maar dat was meer test. Er worden bv al urls gemaakt e.d. maar ik doe er verder nog niks mee.

Kijk eens of je hier wat aan hebt: klik

Reageren