14 berichten aan het bekijken - 1 tot 14 (van in totaal 14)
  • Q:
    Bijdrager
    Eduw

    php: kalender probleem

    Ik heb dus een kalender aangemaakt maar die wil niet werken:(
    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
    [code:1:8c4c4f0d08]<?php
    header("Cache-Control: no-cache, must-revalidate, no-storenPragma: no-cachen");
    ?><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>&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="kalender.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 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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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%;">&raquo; ".$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>[/code:1:8c4c4f0d08]

    kalenderdag.php
    [code:1:8c4c4f0d08]<?php
    header("Cache-Control: no-cache, must-revalidate, no-storenPragma: no-cachen");
    ?>
    <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>&raquo; 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>&raquo; ".$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>

    [/code:1:8c4c4f0d08]

    Bijdrager
    mac osx rules

    Ik ben eerlijk gezecht niet goed in codes, maar volgens mij mis je de dagen bij je comando’s

    ik heb er streepjes tussen gezet…

    [code:1:69bab4b553]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)) [/code:1:69bab4b553]

    Of zit ik er nu helemaal naast :sealed:

    Bijdrager
    vikking
    ”mac

    Of zit ik er nu helemaal naast :sealed:

    Mja ik denk het wel :P, Trouwens wat doet het verkeerd? Voor mij ziet dat er goed uit (die link)

    Bijdrager
    mac osx rules

    Ik had het gevoel dat hij (zoals op de code die ik ge citeerd had) iemands verjaardag (en andere dingen, zie de code) op een dag wou zetten, ik kon alleen nergens die dag vinden :sealed: dat is het probleem denk ik

    Bijdrager
    martijnG

    je inlog gegevens staan er nog in volgens mij:

    // Connection mysql
    $user = “XXX”;
    $dbpass = “XXX”;
    $host = “XXX”;
    $dbdb = “XXX”;

    als deze kloppen zou ik als ik jouw was dit zo snel mogelijk uit je post halen….

    Edit: erg dom van mij om om de gegevens te copy/pasten. Excusses…

    Bijdrager
    Lifelogger
    ”martijnG”

    je inlog gegevens staan er nog in volgens mij:

    // Connection mysql
    $user = “######”;
    $dbpass = “#####”;
    $host = “#####”;
    $dbdb = “#####”;

    als deze kloppen zou ik als ik jouw was dit zo snel mogelijk uit je post halen….

    Ha ha ha… dat is inderdaad niet zo heel erg slim.

    Bijdrager
    Eduw

    oeie:)
    ma nu staan ze wel nog alsang in je quote;)
    maar is er niemand die de fout ziet?
    de link werkt idd maar ik heb bvb op 1 januari nieuwjaarsdag ingevoerd en die komt er niet op :(

    Bijdrager
    dfI*)#[email protected](*_)$U#JHEN#[email protected]$(#@Halert(‘hi’);

    ik weet je antwoord niet maar je gegevens staan er ook nog in het kalenderdag.php deel.


    @lifelogger
    : En dat soort dingen moet je niet quoten

    Bijdrager
    Lifelogger

    Ik qoute slechts de buurman boven mij die de gegevens iets duidelijker gemaakt heeft!:-)

    Heb de post overigens aangepast.

    Bijdrager
    Eduw

    grrr ben er met men gedachten nie bij:)
    vlug pass veranderen voor de zekerheid;)
    khad het namelijk op een ander forum ook al geflikt
    Als iemand me eens zou willen helpen met men php :P
    mss dom om paar 100 regels code hier op te smijten maar je weet nooit dat er hier mensen zitten met een passie:p

    Bijdrager
    JanWeijers

    Zou het probleem kunnen zijn met hoe de gegevens in de database staan. al je in de database 01/01/2006 hebt staan en je zoekt naar 1/1/2006 zul je niets vinden.

    SELECT title FROM agenda WHERE date=’$the_day/$this_month’ and genre=’feestdag’ ORDER BY id”

    Deze query zal geen afspraken vinden tenzij er inderdaad afspraken zonder jaar in de tabel agenda staan. Gebruik anders eventueel

    WHERE date LIKE ‘$the_day/$this_month/%’

    Het % is de wildcard.

    Jan

    Bijdrager
    Eduw

    ja in de tabel staat het alleszins goed:)
    toch bedankt

    Bijdrager
    JanWeijers

    Toch gaat er iets niet goed met je queries, anders zou er toch wat in de kalender moeten staan. Deze viel mij ook nog op:

    SELECT title FROM agenda WHERE date=’$the_day/$this_month/$this_year’ and genre=’activité’ ORDER BY id

    Weet je zeker dat ‘activité’ ook als é in de database staat? Want elders zoek je naar “genre=’activiteit'” Dit soort karakters kan nog wel eens problemen opleveren omdat ze soms gecodeerd worden. Probeer eventueel genre LIKE ‘activ%’

    Overigens is je manier om de maand en dagnamen te tonen niet erg efficient. Je kunt beter setlocale(LC_ALL, “nl_NL”) in combinatie met strftime() gebruiken.

    Jan

    Bijdrager
    Eduw

    mja voor die activité ebbek zoiezo niets ingevoerd:)
    maar verjaardagen en feestdagen zouden toch al moeten getoond worden
    zal vanavond eens kijken voor die datum

14 berichten aan het bekijken - 1 tot 14 (van in totaal 14)

Je moet ingelogd zijn om een reactie op dit onderwerp te kunnen geven.