Bonjour,
svp est ce qu'il y aurait quelqu'un qui pourait m'aider à passer les jours et mois de cet agenda en francais :
<?
$Host = "";
$User = "";
$PassWord = "";
$DataBaseName = "";
$TableName = "";
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);
}
if(isset($_COOKIE["ID_UTILISATEUR"]))
{
$isLogged = true;
}
else
{
$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 = mysql_query(" select count(id) from agenda where day = '" . $day ."
' and month = '" . $month ."
' and year = '" . $year. "'");
$entry = mysql_fetch_array($Select);
if($entry[0] < 1)
{
if($text != "")
{
$Insert = "insert into " . $TableName . " (text, day, month, year, idutilisateur) values ('" . $text . "', " .
$day . ", " . $month . ", " . $year . " , " . $_COOKIE['ID_UTILISATEUR'] .")";
//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. " and idutilisateur = " . $_COOKIE['ID_UTILISATEUR'] ;
mysql_query($Update);
}
else
{
$Delete = "delete from " . $TableName . " where day = " . $day .
" and month = " . $month . " and year = " . $year. " and idutilisateur = " . $_COOKIE['ID_UTILISATEUR'] ;
//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=\"20\">\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\">" .
"<a " .
"href=\"agenda.php?month=" . $previous_month["mon"] . "&year=" . $previous_month["year"] . "\"><</a></td>\n";
//voir pour faire un lien en ajax
$schedule_html .= "<td colspan=\"5\" align=\"center\">" .
"<font class=\"agendadate\">" . $month_name . " " . $year . "</font></td>\n";
$schedule_html .= "<td align=\"center\">" .
"<a " .
"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> </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 align=\"center\"><font>" . $day_counter . "</font></td>\n";
else
$schedule_html .= "<td align=\"center\"> " .
"<a href=\"agenda.php?day=" . $day_counter . "&month=" . $month . "&year=" . $year . "\">" .
$day_counter . "</a> </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";
if($isLogged == true)
{
$schedule_html .= "<tr>";
$schedule_html .= "<td>";
$schedule_html .= "<input type=\"hidden\" name=\"save\" value=\"yes\" />";
$schedule_html .= "</td>";
$schedule_html .= "<td width=\"33%\"></td>";
$schedule_html .= "<td>";
$schedule_html .= "<input type=\"button\" value=\"enregistrer\" ";
$schedule_html .= "onclick=\"document.save.submit();\" />";
$schedule_html .= "</td>";
$schedule_html .= "</tr>\n";
}
else
{
header("Location: index.php");
}
$schedule_html .= "<form name=\"EmptyForm\" method=\"post\">\n";
$schedule_html .= "</form>\n";
$schedule_html .= "</table>\n";
$schedule_html .= "</td>\n";
$schedule_html .= "<td valign=\"top\" width=\"100%\"><table width=\"100%\" cellpadding=\"10\">\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 class=\"agendadate\" align=\"right\">";
$schedule_html .= $date["weekday"] . " " .
$date["month"] . " " .
$date["mday"] . ", " .
$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"] . "\" style=\"width:100%;overflow:auto;\" 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. " and idutilisateur = " . $_COOKIE['ID_UTILISATEUR'] ;;
$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;
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<script src="Scripts/AC_RunActiveContent.js" type="text/javascript"></script>
<script src="Scripts/ajax.js" type="text/javascript"></script>
<script src="Scripts/heure.js" type="text/javascript"></script>
<script src="Scripts/ongletmenu.js" type="text/javascript"></script>
</head>
<body onLoad="namosw_init_clock('partie1',2,'partie2',7);">
<? include('navig.php'); ?>
<div id="page">
<div id="agenda">
<?php echo $agenda; ?>
</div>
</div>
</body>
</html>