Taal van de datum veranderen...

Martijntje · 5 mei 2010

Hi all!

Ik heb een agenda'tje op internet gevonden die ik graag wil gaan gebruiken, maar de datums worden in het engels weergegeven. Ik probeer al een tijdje om ze in het NL te krijgen, maar het lukt niet.

Hier iemand die me verder op weg kan helpen?

hier staat een testje...

Alvast bedankt!

Martijn

FYI:

PHP:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<?
$Host =           "localhost";
$User =           ""; 
$PassWord =       ""; 
$DataBaseName =   ""; 
$TableName =      "agenda";

mysql_connect($Host, $User, $PassWord);
mysql_select_db($DataBaseName);

//This below will create your table for you if it does not exist.
//Feel free to comment it out once the table is created.
$Tables = mysql_query("show tables like '" . $TableName . "'");

if(mysql_fetch_row($Tables) === false)
  {
  $create = "create table " . $TableName .
            "(" .
            "id int primary key auto_increment, " .
            "text text, " .
            "day int, " .
            "month int, " .
            "year int " .
            ")";
  
  mysql_query($create);
  }
		 
$Entered_UserName = "";
$Entered_PassWord = "";

if(isset($HTTP_COOKIE_VARS["UserName"]) &&
   isset($HTTP_COOKIE_VARS["PassWord"]))
  {
  $Entered_UserName = $HTTP_COOKIE_VARS["UserName"];
  $Entered_PassWord = $HTTP_COOKIE_VARS["PassWord"];
  }

$isLogged = true;
        	
if($Entered_UserName != $User || $Entered_PassWord != $PassWord)                      
   $isLogged = false;
  
//Execute MySQL queries if someone is logged in.
if($isLogged == true)
  {
  if(param("save") != "")   
    {
    for($week_day = 0; $week_day <= 7; $week_day++)
       {
       $day = param("day" . $week_day);
       $month = param("month" . $week_day);
       $year = param("year" . $week_day);
       $text = trim(param("text" . $week_day));
       
       $Select = "select count(id) from " . $TableName . " where day = " . $day .
                 " and month = " . $month .
                 " and year = " . $year;
                 
       $entries = mysql_query($Select);
       $entry = mysql_fetch_array($entries);
       
       if($entry[0] < 1)
         {
         if($text != "")
           {
           $Insert = "insert into " . $TableName . " (text, day, month, year) values ('" . $text . "', " .
                     $day . ", " . $month . ", " . $year . ")";
           //If there is no entry in the table for that day, create it.                     
           mysql_query($Insert);
           }
         }
       else
         {
         if($text != "")
           {
           $Update = "update " . $TableName . " set text ='" . $text . "' where day = " . $day .
                     " and month = " . $month . " and year = " . $year;
                      
           mysql_query($Update);
           }
         else
           {
           $Delete = "delete from " . $TableName . " where day = " . $day .
                     " and month = " . $month . " and year = " . $year;
           //No point in keeping empty records in the table.          
           mysql_query($Delete);
           }
         }       
       }
    }
  }

function schedule($date)
         {
         //If no parameter is passed use the current date.
         if($date == null)
            $date = getDate();
            
         $day = $date["mday"];
         $week_day = $date["wday"];
         $month = $date["mon"];
         $month_name = $date["month"];         
         $year = $date["year"];
         
         $today = getDate(mktime(0, 0, 0, $month, $day, $year));
         
         $sunday = $day - $week_day;
         $saturday = $day + (6 - $week_day);
                                                              
         $schedule_html = "<table height=\"100%\" width=\"100%\" cellspacing=\"0\">\n";
         
         $schedule_html .= "<tr><td align=\"right\" valign=\"top\">\n";
         
         global $previous_month;
         global $this_month;
         global $next_month;
		 
   
         $previous_month = getDate(mktime(0, 0, 0, $month - 1, 1, $year));
         $this_month = getDate(mktime(0, 0, 0, $month, 1, $year));
         $next_month = getDate(mktime(0, 0, 0, $month + 1, 1, $year));
         
         $first_week_day = $this_month["wday"];
         $days_in_this_month = round(($next_month[0] - $this_month[0]) / (60 * 60 * 24));
                          
         $schedule_html .= "<table>\n";
         
         $schedule_html .= "<tr><td align=\"center\" class=\"calendar_cell\">" .
                           "<a class=\"calendar_date\" " .
                           "href=\"agenda.php?month=" . $previous_month["mon"] . "&year=" . $previous_month["year"] . "\"><</a></td>\n";
         
         $schedule_html .= "<td colspan=\"5\" align=\"center\" class=\"calendar_cell\">" . 
                           "<font class=\"calendar_month\">" . $month_name . " " . $year . "</font></td>\n";
                           
         $schedule_html .= "<td align=\"center\" class=\"calendar_cell\">" .
                           "<a class=\"calendar_date\" " .
                           "href=\"agenda.php?month=" . $next_month["mon"] . "&year=" . $next_month["year"] . "\">></a></td></tr>\n";
                           
         $schedule_html .= "<tr>\n";
          
         //Fill the first week of the month with the appropriate number of blanks.       
         for($week_day = 0; $week_day < $first_week_day; $week_day++)
            {
            $schedule_html .= "<td class=\"calendar_cell\">&nbsp;</td>";   
            }
            
         $week_day = $first_week_day;
         for($day_counter = 1; $day_counter <= $days_in_this_month; $day_counter++)
            {
            $week_day %= 7;
            
            if($week_day == 0)
               $schedule_html .= "</tr><tr>\n";
            
            //Do something different for the current day.
            if($day == $day_counter)
               $schedule_html .= "<td class=\"calendar_current_cell\" align=\"center\"><font class=\"calendar_current_date\">" . $day_counter . "</font></td>\n";
            else
               $schedule_html .= "<td align=\"center\" class=\"calendar_cell\">&nbsp;" .
                                 "<a class=\"calendar_date\" href=\"agenda.php?day=" . $day_counter . "&month=" . $month . "&year=" . $year . "\">" . 
                                 $day_counter . "</a>&nbsp;</td>\n";
            
            $week_day++;
            }
            
         $schedule_html .= "</tr>\n";
         $schedule_html .= "</table>\n";
         
         $schedule_html .= "<br /><br />\n";
         
         //Login.
         global $isLogged;
         
//       $schedule_html .= "<table align=\"right\">\n";                  
         $schedule_html .= "<div class=\"login\">\n";                  
         if($isLogged == true)
           {           
           $schedule_html .= "<br /><br /><br /><br /><br />";
           $schedule_html .= "<br />";
           $schedule_html .= "<input type=\"hidden\" name=\"save\" value=\"yes\" />";
           $schedule_html .= "<input type=\"button\" value=\"Uitloggen\" class=\"calendar_cell\" ";
           $schedule_html .= "onclick=\"clearCookie('UserName');";
           $schedule_html .= "clearCookie('PassWord');";
           $schedule_html .= "document.EmptyForm.submit();\" />";           
           $schedule_html .= "<br />";
           $schedule_html .= "<br />";           
           $schedule_html .= "<br />";
           $schedule_html .= "<input type=\"button\" value=\"Opslaan\" class=\"calendar_cell\" ";
           $schedule_html .= "onclick=\"document.save.submit();\" />";
           $schedule_html .= "<br />";
           $schedule_html .= "<br />\n";
           }
         else
           {
           $schedule_html .= "<br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br /><br />";
		   $schedule_html .= "<form name=\"login\">";
           $schedule_html .= "Gebruikersnaam&nbsp;";
           $schedule_html .= "<input type=\"text\" name=\"UserName\" size=\"10\" class=\"input\" />";
           $schedule_html .= "<br /><br />";
           $schedule_html .= "Wachtwoord&nbsp;";
           $schedule_html .= "<input type=\"password\" size=\"10\" name=\"PassWord\" class=\"input\" />";
           $schedule_html .= "<br /><br />";
           $schedule_html .= "<input type=\"button\" value=\"Inloggen\" class=\"calendar_cell\" ";
           $schedule_html .= "onclick=\"setCookie('UserName', document.login.UserName.value);";
           $schedule_html .= "setCookie('PassWord', document.login.PassWord.value);";
           $schedule_html .= "document.EmptyForm.submit();\" />";           
           $schedule_html .= "</form>\n";           
           }
          
         $schedule_html .= "<form name=\"EmptyForm\" method=\"post\">\n";
         $schedule_html .= "</form>\n";
                              
         $schedule_html .= "</div>\n";
         
         $schedule_html .= "</td>\n";
         
         $schedule_html .= "<td valign=\"top\" width=\"100%\"><table height=\"500\" width=\"100%\" cellpadding=\"2\">\n";                  
         
         if($isLogged == true)
           {
           $schedule_html .= "<form name=\"save\" method=\"post\">\n";
           $schedule_html .= "<input type=\"hidden\" name=\"save\" value=\"save\">\n";
           }
            

         for($index = $sunday; $index <= $saturday; $index++)
            {
            $date = getDate(mktime(0, 0, 0, $month, $index, $year));
            
            $schedule_date = "schedule_date";
            $schedule_entry = "schedule_entry";
            if(($month > $date["mon"] && $year == $date["year"]) || $year > $date["year"])
              {
              $schedule_date = "schedule_date_previous";
              $schedule_entry = "schedule_entry_previous";
              }
            if(($month < $date["mon"] && $year == $date["year"]) || $year < $date["year"])
              {
              $schedule_date = "schedule_date_next";
              $schedule_entry = "schedule_entry_next";
              }
               
            $schedule_html .= "<tr><td height=\"30\" align=\"right\" class=\"" . $schedule_date . "\">";                        
         
            $schedule_html .= $date["weekday"] . " " .
                              $date["mday"] . " " .
                              $date["month"] . ", " .
                              $date["year"] . "\n";
            
            $schedule_html .= "</br>\n";
            
            $schedule_text = getSchedule($date["mday"], $date["mon"], $date["year"]);                        
               
            $readonly = "readonly";
            if($isLogged == true)
               $readonly = "";
            
            if($isLogged == true)
              {
              $schedule_html .= "<input type=\"hidden\" name=\"day" . $date["wday"] . "\" value=\"" . $date["mday"] . "\" />\n";
              $schedule_html .= "<input type=\"hidden\" name=\"month" . $date["wday"] . "\" value=\"" . $date["mon"] . "\" />\n";
              $schedule_html .= "<input type=\"hidden\" name=\"year" . $date["wday"] . "\" value=\"" . $date["year"] . "\" />\n";
              }
            
            $schedule_html .= "<textarea wrap=\"off\" name=\"text" . $date["wday"] . "\" class=\"" . 
                              $schedule_entry . "\" style=\"width:100%;overflow:auto;background-color:transparent;font-family: Verdana, Arial, Helvetica, sans-serif;color:#74477E;\" rows=\"" . 
                              rows($schedule_text) . "\" " . $readonly . ">\n" . 
                              $schedule_text . "</textarea>\n";
            
            $schedule_html .= "</td></tr>\n";
            }
         
         if($isLogged == true)
            $schedule_html .= "</form>\n";
         
         $schedule_html .= "</table></td></tr>\n";
         
         $schedule_html .= "</table>\n";
                   
         return($schedule_html);
         }
 
function getSchedule($day, $month, $year)
         {
         global $TableName;
         
         $Select = "select text from " . $TableName . " where " .
                   "day = " . $day . " and " .
                   "month = " . $month . " and " .
                   "year = " . $year;
         
         $Schedule = mysql_query($Select);
         
         if($Text = mysql_fetch_assoc($Schedule))
           {
           return($Text["text"]);
           }
         else
           {
           return("");
           }
         }
         
function rows($text)
         {
         return(substr_count($text, "\n") + 1);
         }
         
function param($Name)
         {
         global $HTTP_GET_VARS;
         global $HTTP_POST_VARS;         

         if(isset($HTTP_GET_VARS[$Name]))
            return($HTTP_GET_VARS[$Name]);

         if(isset($HTTP_POST_VARS[$Name]))
            return($HTTP_POST_VARS[$Name]);
            
         return("");         
         }
         
$day = param("day");
$month = param("month");
$year = param("year");

$date = null;

if($year != "")
  {
  if($day == "")
     $day = 1;
  if($month == "")
     $month = 1;
     
  $date = getDate(mktime(0, 0, 0, $month, $day, $year));
  }

$agenda = schedule($date);
  
$previous_month;
$this_month;
$next_month;

$body = Array
(
"background-color:eeeeff;",
"background-color:ffddee;",
"background-color:dddddd;",
"background-color:9999cc;",
"background-color:ccff99;",
"background-color:ffdd77;",
"background-color:ffee00;",
"background-color:eecc55;",
"background-color:dd9900;",
"background-color:000000;",
"background-color:aa7700;",
"background-color:ddffdd;"
);

$calendar_month = Array
(
"color:000000; font-weight:bold;",
"color:ff0000; font-weight:bold;",
"color:00ff00; font-weight:bold;",
"color:000099; font-weight:bold;",
"color:000000; font-weight:bold;",
"color:ff8800; font-weight:bold;",
"color:6666ff; font-weight:bold;",
"color:ff6600; font-weight:bold;",
"color:000000; font-weight:bold;",
"color:9900ee; font-weight:bold;",
"color:884400; font-weight:bold;",
"color:55dd55; font-weight:bold;"
);
  
$calendar_cell = Array
(
"border:1; border-style:solid; border-color:#74477E; color:000000;",
"background-color:eeeeff; border:1; border-style:solid; border-color:#900; color:ff0000;",
"background-color:999999; border:1; border-style:solid; border-color:#74477E; color:ffffff;",
"background-color:9999ff; border:1; border-style:solid; border-color:#900; color:0000dd;",
"background-color:ffdd77; border:1; border-style:solid; border-color:#74477E; color:000000;",
"background-color:99ff99; border:2; border-style:solid; border-color:#900; color:ff8800;",
"background-color:ffcccc; border:2; border-style:solid; border-color:#74477E; color:6666ff;",
"background-color:eecc55; border:2; border-style:solid; border-color:#900; color:ff6600;",
"background-color:ffcc00; border:2; border-style:solid; border-color:#74477E; color:000000;",
"background-color:dd9900; border:2; border-style:solid; border-color:#900; color:9900ee;",
"border:2; border-style:solid; border-color:#74477E; color:884400;",
"background-color:dd5555; border:2; border-style:solid; border-color:##900; color:55dd55;"
);

$calendar_current_cell = Array
(
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
"border:1; border-style:solid; border-color:#74477E;",
"border:1; border-style:solid; border-color:#900;",
);

$calendar_date = Array
(
"background-color:ffffff; color:000000; text-decoration:none;",
"background-color:eeeeff; color:ff0000; text-decoration:none;",
"background-color:999999; color:ffffff; text-decoration:none;",
"background-color:9999ff; color:0000dd; text-decoration:none;",
"background-color:ffdd77; color:000000; text-decoration:none;",
"background-color:99ff99; color:ff8800; text-decoration:none;",
"background-color:ffcccc; color:6666ff; text-decoration:none;",
"background-color:eecc55; color:ff6600; text-decoration:none;",
"background-color:ffcc00; color:000000; text-decoration:none;",
"background-color:dd9900; color:6600ee; text-decoration:none;",
"background-color:ffffff; color:884400; text-decoration:none;",
"background-color:dd5555; color:55dd55; text-decoration:none;"
);

$calendar_current_date = Array
(
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;",
"color:#74477E; text-decoration:none; font-weight:bold;"
);

$schedule_date = Array
(
"color:000000; font-weight:bold; border:1; border-style:solid; border-color:#74477E;",
"color:0000ff; font-weight:bold; border:2; border-style:solid; border-color:#900;",
"color:ffffff; font-weight:bold; background-color:999999; border:1; border-style:solid; border-color:#74477E;",
"color:000099; font-weight:bold; background-color:9999ff; border:1; border-style:solid; border-color:#900;",
"color:000000; font-weight:bold; background-color:ffdddd; border:1; border-style:solid; border-color:#74477E;",
"color:ff8800; font-weight:bold; background-color:99ff99; border:2; border-style:solid; border-color:#900;",
"color:6666ff; font-weight:bold; background-color:ffcccc; border:2; border-style:solid; border-color:#74477E;",
"color:ff6600; font-weight:bold; background-color:eecc55; border:2; border-style:solid; border-color:#900;",
"color:000000; font-weight:bold; background-color:00aa00; border:2; border-style:solid; border-color:#74477E;",
"color:dd9900; font-weight:bold; background-color:000000; border:2; border-style:solid; border-color:#900;",
"color:884400; font-weight:bold; border:2; border-style:solid; border-color:#74477E;",
"color:dd5555; font-weight:bold; background-color:ddffdd; border:2; border-style:solid; border-color:#900;"
);

$schedule_entry = Array
(
"color:#74477E; border-style:none;",
"color:#74477E; border-style:none;",
"color:#74477E; background-color:999999; border-style:none;",
"color:000099; background-color:9999ff; border-style:none;",
"color:000000; background-color:ffdddd; border-style:none;",
"color:ff8800; background-color:99ff99; border-style:none;",
"color:6666ff; background-color:ffcccc; border-style:none;",
"color:ff6600; background-color:eecc55; border-style:none;",
"color:000000; background-color:00aa00; border-style:none;",
"color:dd9900; background-color:000000; border-style:none;",
"color:884400; border-style:none;",
"color:dd5555; background-color:ddffdd; border-style:none;"
);

?>



<html>




<head>
<link rel="SHORTCUT ICON" href="http://www.nathalievisagie.nl/redhatberries/favicon.ico"/>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>test</title>
<link href="style.css" rel="stylesheet" type="text/css" />

<style>
body
{
<?= $body[$this_month["mon"] - 1] ?>
}

.calendar_month
{
<?= $calendar_month[$this_month["mon"] - 1] ?>
}

.calendar_cell
{
<?= $calendar_cell[$this_month["mon"] - 1] ?>
}

.calendar_current_cell
{
<?= $calendar_current_cell[$this_month["mon"] - 1] ?>
}

.calendar_date
{
<?= $calendar_date[$this_month["mon"] - 1] ?>
}

.calendar_current_date
{
<?= $calendar_current_date[$this_month["mon"] - 1] ?>
}

.schedule_date_previous
{
<?= $schedule_date[$previous_month["mon"] - 1] ?>
}

.schedule_date
{
<?= $schedule_date[$this_month["mon"] - 1] ?>
}

.schedule_date_next
{
<?= $schedule_date[$next_month["mon"] - 1] ?>
}

.schedule_entry_previous
{
<?= $schedule_entry[$previous_month["mon"] - 1] ?>
}

.schedule_entry
{
<?= $schedule_entry[$this_month["mon"] - 1] ?>
}

.schedule_entry_next
{
<?= $schedule_entry[$next_month["mon"] - 1] ?>
}

.input {
font-family: Verdana, Arial, Helvetica, sans-serif;	
color: #74477E;
}
</style>

<script>
function setCookie(name, value)
         {
         //If name is the empty string, it places a ; at the beginning
         //of document.cookie, causing clearCookies() to malfunction.
         if(name != '')
            document.cookie = name + '=' + value;
         }
         
function clearCookie(name)
         {
         expires = new Date();
         expires.setYear(expires.getYear() - 1);

         document.cookie = name + '=null' + '; expires=' + expires;
         }

</script>
</head>
<body>
<div class="content">
<div class="headr"></div>
<div class="menu"></div>
<div class="main">
<div class="agenda_left"> <?= $agenda ?> </div>
</div>
<div class="footer"></div>
</div>
</div>
</body>
</html>

Laurax · 5 mei 2010

Hoi Martijntje,

Hier was ik eerder ook mee bezig, toen vond ik dit : http://forum.codecall.net/php-tutorials/3435-translate-date-into-your-language.html

Helder verhaal. Volgens mij kan dit voor jou ook wel helpen.....

Laura

Martijntje · 6 mei 2010

Hi Laura & others,

Dat ziet er inderdaad overzichtelijk uit.
Ik heb er even mee zitten stoeien, maar ik heb geen idee hoe of waar ik het in mijn code moet plaatsen...

Any pointers... Anyone?

Thanx

Leon d · 6 mei 2010

Wat ik altijd gebruik.
Als in de database bijv. "january", "february" etc. staat

PHP:

$months = new array(
"january" => "januari",
"february" => "februari",
"march" => "maart"
)
//etc..

//dan toon je de maand, als volgt:
echo $months[$month];

hopelijk helpt het iets!

Frats · 6 mei 2010

Dit soort dingen zit gewoon standaard in PHP....

Zie: http://nl2.php.net/manual/en/function.setlocale.php

Daar kun je instellen welke taal PHP moet gebruiken voor dingen als datum/tijd, geld notatie, getallen, etc.

Als je de locale daar gewoon op 'nl_NL' gooit dan zou het allemaal netjes Nederlands moeten worden

Taal van de datum veranderen...

Martijntje

Gebruiker

Laurax

Gebruiker

Martijntje

Gebruiker

Leon d

Gebruiker

Frats

Terugkerende gebruiker

Nieuwste berichten

Wij waarderen jouw privacy