par
Frantz » 01 déc. 2006, 21:08
Est tu sûr de vouloir le faire toi même ?
C'est assez complexe à réaliser, voici quelques pistes :
- Dès que tu crées un utilisateur, tu crées en même temps
une table agenda, voici un script sql avec une bonne
config de table agenda :
<?
if (isset($_POST['login']))
{
mysql_connect("","","");
mysql_select_db("ta_db");
mysql_query("CREATE TABLE CALENDRIER_".$_POST['login']." (
ID int(11) NOT NULL auto_increment,
DATE date NOT NULL default '0000-00-00',
HEURE tinytext NOT NULL,
MINUTE tinytext NOT NULL,
TACHE mediumtext NOT NULL,
REPEAT tinyint(1) NOT NULL default '0',
INDEX(id),
KEY repeat (repeat))");
}
?>
Bon allez, je suis sympa, je te donne un exemple d'agenda,
ceci pour que tu te rendes compte de la difficulté. Essaies de
le remanier à ta façon, tu comprendras le mécanisme.
Pour t'en servir, remplace les valeurs de connections et
crée une session d'authentification sur un utilisateur.
Tu peux créer un test avec une table appelé CALENDRIER_BOB
Tu te connect ensuite en tant que bob, tu vas sur l'agenda ....
<?
function getMicroTime()
{
$microsecondes=microtime();
list($micro,$time)=explode(' ',$microsecondes);
return($micro+$time);
}
$mt_start=getMicroTime();
$mysqlconnectid=mysql_connect("tonhost","tonuser","tonpass");
mysql_select_db("tadb",$mysqlconnectid);
$mois=array("","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
$nb_jours=array("",31,28,31,30,31,30,31,31,30,31,30,31);
$jours["Mon"]="Lundi";$jours["Tue"]="Mardi";$jours["Wed"]="Mercredi";$jours["Thu"]="Jeudi";$jours["Fri"]="Vendredi";$jours["Sat"]="Samedi";$jours["Sun"]="Dimanche";
if (isset($_GET['c_jour'])){$c_jour=$_GET['c_jour'];}
if (isset($_GET['c_mois'])){$c_mois=$_GET['c_mois'];}
if (isset($_GET['c_annee'])){$c_annee=$_GET['c_annee'];}
if(!(isset($c_jour)))
{$c_jour=date("d");}
if(!(isset($c_mois)))
{$c_mois=date("m");}
if(!(isset($c_annee)))
{$c_annee=date("Y");}
$c_jour=round($c_jour);$c_mois=round($c_mois);$c_jour=round($c_jour);
if($c_jour>$nb_jours["$c_mois"])
{$c_jour=$nb_jours["$c_mois"];}
if($c_jour<1 AND isset($c_jour))
{$c_jour=1;}
$c_jour=doubleval($c_jour);
$c_mois=doubleval($c_mois);
$c_annee=doubleval($c_annee);
if($c_jour>$nb_jours[$c_mois])
{$c_jour=$c_jour-$nb_jours[$c_mois];$c_mois++;}
if($c_mois>12)
{$c_mois=1;$c_annee++;}
if(($c_annee-2000)%4==0)
{$nb_jours[2]++;}
$temp=mktime(1,1,1,$c_mois,$c_jour,$c_annee);
echo"<center>
<table cellspacing=\"1\" cellpadding=\"1\" border=\"0\" bgcolor=\"#AAAAAA\">
<tr class=\"texte1\" bgcolor=\"#666666\">
<td colspan=\"7\"><b>".$jours[date("D",$temp)]." $c_jour $mois[$c_mois] $c_annee</b> :";
if($c_jour.$c_mois.$c_annee!=date("dmY"))
{echo"<a href=\"index.php?c_jour=".date("d")."&c_mois=".date("m")."&c_annee=".date("Y")."\" class=\"lien1\">Revenir à aujourd'hui</a>";}
echo"</td>";
echo "<td bgcolor=\"#333333\" rowspan=\"9\" valign=\"top\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
for($index=1;$index<=12;$index++)
{
if($index==$c_mois)
{echo "<tr bgcolor=\"#000000\" class=\"texte1\">";}
else
{echo "<tr class=\"texte1\" bgcolor=\"#333333\">";}
echo "<td width=\"70\"><a href=\"index.php?c_jour=$c_jour&c_mois=$index&c_annee=$c_annee\" class=\"lien1\">$mois[$index]</a></td></tr>";
}
echo"</table></td>";
echo "<td bgcolor=\"#333333\" rowspan=\"9\" valign=\"top\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
for($index=date("Y");$index<=date("Y")+6;$index++)
{
if($index==$c_annee)
{echo "<tr bgcolor=\"#000000\" class=\"texte1\">";}
else
{echo "<tr class=\"texte1\" bgcolor=\"#333333\">";}
echo "<td width=\"70\"><a href=\"index.php?c_jour=$c_jour&c_mois=$c_mois&c_annee=$index\" class=\"lien1\">$index</a></td></tr>";
}
echo"</table></td></tr>
<tr class=\"texte1\" bgcolor=\"#666666\"><td align=\"center\" width=\"65\">Lundi</td><td align=\"center\" width=\"65\">Mardi</td><td align=\"center\" width=\"65\">Mercredi</td><td align=\"center\" width=\"65\">Jeudi</td><td align=\"center\" width=\"65\">Vendredi</td><td align=\"center\" width=\"65\">Samedi</td><td align=\"center\" width=\"65\">Dimanche</td></tr>
<tr class=\"texte1\" bgcolor=\"#333333\">";
$pos=0;
for($time=mktime(1,1,1,$c_mois,1,$c_annee);date("D",$time)!="Mon";$time-=86400)
{
print("<td bgcolor=\"#666666\"> </td>");
$pos++;
$temp++;
}
$pos++;
unset($tjour);
$result=mysql_query("SELECT DISTINCT DAYOFMONTH(date) FROM CALENDRIER_".$_SESSION['login']." WHERE (MONTH(date)='$c_mois' AND YEAR(date)='$c_annee') OR (MONTH(date)='$c_mois' AND repeat='2') OR repeat='1' ORDER BY date DESC");
while($row=mysql_fetch_row($result))
{$tjour[($row[0])]=1;}
for($index=1;$index<=$nb_jours[$c_mois];"")
{
while($pos<=7 AND $index<=$nb_jours[$c_mois])
{
print("<td align=\"center\"");
if($index==$c_jour)
{print(" bgcolor=\"#000000\"");}
elseif(isset($tjour[$index]))
{print(" bgcolor=\"#333333\"");}
echo "><a href=\"index.php?c_jour=$index&c_mois=$c_mois&c_annee=$c_annee\" class=\"lien1\">$index</a></td>";
$index++;
$pos++;
}
if($index>$nb_jours[$c_mois])
{
while($pos<=7)
{
echo "<td bgcolor=\"#666666\"> </td>";
$index++;
$pos++;
}
}
$pos=1;
echo "</tr><tr class=\"texte1\" bgcolor=\"#333333\">";
}
echo "<td align=\"right\" colspan=\"7\" valign=\"bottom\"><br>Jour ";
$c_jour1=$c_jour-1;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1<1)
{
$c_mois1--;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
$c_jour1=$nb_jours[$c_mois1];
}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">précédent</a> / ";
$c_jour1=$c_jour+1;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1>$nb_jours[$c_mois1])
{$c_jour1=1;$c_mois1++;}
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">suivant</a> <br>";
$c_jour1=$c_jour- 7;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1<1)
{
$c_mois1--;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
$c_jour1=$c_jour1+$nb_jours[$c_mois1];
}
echo "<br><a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">-7 jours</a> / ";
$c_jour1=$c_jour+7;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1>$nb_jours[$c_mois1])
{$c_jour1=$c_jour1-$nb_jours[$c_mois1];$c_mois1++;}
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">+7 jours</a> <br> ";
$c_jour1=$c_jour;
$c_mois1=$c_mois-1;
$c_annee1=$c_annee;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
echo"<br>Mois <a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">précédent</a> / ";
$c_jour1=$c_jour;
$c_mois1=$c_mois+1;
$c_annee1=$c_annee;
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
print("<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">suivant</a> </td></tr>
</table>");
$c_value="";
$c_value=htmlentities($c_value);
if (isset($_POST['c_action'])){$c_action=$_POST['c_action'];}
if (isset($_POST['heure'])){$heure=$_POST['heure'];}
if (isset($_POST['minute'])){$minute=$_POST['minute'];}
if (isset($_POST['c_id'])){$c_id=$_POST['c_id'];}
if (isset($_POST['c_repeat'])){$c_repeat=$_POST['c_repeat'];}
if (isset($_POST['c_value'])){$c_value=$_POST['c_value'];}
if (isset($_GET['c_action'])){$c_action=$_GET['c_action'];}
if (isset($_GET['heure'])){$heure=$_GET['heure'];}
if (isset($_GET['minute'])){$minute=$_GET['minute'];}
if (isset($_GET['c_id'])){$c_id=$_GET['c_id'];}
if (isset($_GET['c_repeat'])){$c_repeat=$_GET['c_repeat'];}
if (isset($_GET['c_value'])){$c_value=$_GET['c_value'];}
if (isset($c_action))
{
if($c_action=="Enregistrer")
{$query=mysql_query("INSERT INTO CALENDRIER_".$_SESSION['login']."(HEURE,MINUTE,DATE,TACHE,REPEAT) VALUES('$heure','$minute','$c_annee-$c_mois-$c_jour','$c_value','$c_repeat')");}
elseif($c_action=="Modifier")
{$query=mysql_query("UPDATE CALENDRIER_".$_SESSION['login']." SET HEURE='$heure', MINUTE='$minute', TACHE='$c_value' WHERE id='$c_id'");}
elseif($c_action=="Effacer")
{$query=mysql_query("DELETE FROM CALENDRIER_".$_SESSION['login']." WHERE ID='$c_id'");}
}
$ok=0;
$result=mysql_query("SELECT ID,TACHE,HEURE,MINUTE,REPEAT FROM CALENDRIER_".$_SESSION['login']." WHERE DATE='$c_annee-$c_mois-$c_jour' OR (MONTH(DATE)='$c_mois' AND DAYOFMONTH(DATE)='$c_jour' AND repeat='2') OR (DAYOFMONTH(DATE)='$c_jour' AND repeat='1') ORDER BY HEURE,MINUTE");
if(mysql_num_rows($result))
{
echo "<table cellspacing=\"1\" cellpadding=\"0\" border=\"0\" bgcolor=\"#082800\"><tr><td bgcolor=\"#333333\"><table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" bgcolor=\"#333333\">";
while($row=mysql_fetch_row($result))
{
if ($row[2] == "00"){$select_h00 = "selected";}else{$select_h00 = "";}
if ($row[2] == "01"){$select_h01 = "selected";}else{$select_h01 = "";}
if ($row[2] == "02"){$select_h02 = "selected";}else{$select_h02 = "";}
if ($row[2] == "03"){$select_h03 = "selected";}else{$select_h03 = "";}
if ($row[2] == "04"){$select_h04 = "selected";}else{$select_h04 = "";}
if ($row[2] == "05"){$select_h05 = "selected";}else{$select_h05 = "";}
if ($row[2] == "06"){$select_h06 = "selected";}else{$select_h06 = "";}
if ($row[2] == "07"){$select_h07 = "selected";}else{$select_h07 = "";}
if ($row[2] == "08"){$select_h08 = "selected";}else{$select_h08 = "";}
if ($row[2] == "09"){$select_h09 = "selected";}else{$select_h09 = "";}
if ($row[2] == "10"){$select_h10 = "selected";}else{$select_h10 = "";}
if ($row[2] == "11"){$select_h11 = "selected";}else{$select_h11 = "";}
if ($row[2] == "12"){$select_h12 = "selected";}else{$select_h12 = "";}
if ($row[2] == "13"){$select_h13 = "selected";}else{$select_h13 = "";}
if ($row[2] == "14"){$select_h14 = "selected";}else{$select_h14 = "";}
if ($row[2] == "15"){$select_h15 = "selected";}else{$select_h15 = "";}
if ($row[2] == "16"){$select_h16 = "selected";}else{$select_h16 = "";}
if ($row[2] == "17"){$select_h17 = "selected";}else{$select_h17 = "";}
if ($row[2] == "18"){$select_h18 = "selected";}else{$select_h18 = "";}
if ($row[2] == "19"){$select_h19 = "selected";}else{$select_h19 = "";}
if ($row[2] == "20"){$select_h20 = "selected";}else{$select_h20 = "";}
if ($row[2] == "21"){$select_h21 = "selected";}else{$select_h21 = "";}
if ($row[2] == "22"){$select_h22 = "selected";}else{$select_h22 = "";}
if ($row[2] == "23"){$select_h23 = "selected";}else{$select_h23 = "";}
if ($row[3] == "00"){$select_m00 = "selected";}else{$select_m00 = "";}
if ($row[3] == "05"){$select_m05 = "selected";}else{$select_m05 = "";}
if ($row[3] == "10"){$select_m10 = "selected";}else{$select_m10 = "";}
if ($row[3] == "15"){$select_m15 = "selected";}else{$select_m15 = "";}
if ($row[3] == "20"){$select_m20 = "selected";}else{$select_m20 = "";}
if ($row[3] == "25"){$select_m25 = "selected";}else{$select_m25 = "";}
if ($row[3] == "30"){$select_m30 = "selected";}else{$select_m30 = "";}
if ($row[3] == "35"){$select_m35 = "selected";}else{$select_m35 = "";}
if ($row[3] == "40"){$select_m40 = "selected";}else{$select_m40 = "";}
if ($row[3] == "45"){$select_m45 = "selected";}else{$select_m45 = "";}
if ($row[3] == "50"){$select_m50 = "selected";}else{$select_m50 = "";}
if ($row[3] == "55"){$select_m55 = "selected";}else{$select_m55 = "";}
print("<tr class=\"texte1\" bgcolor=\"#666666\"><form method=\"post\" action=\"index.php\" name=\"form".$row[0]."\">
<input type=\"hidden\" name=\"c_action\" value=\"Modifier\">
<input type=\"hidden\" name=\"c_jour\" value=\"$c_jour\">
<input type=\"hidden\" name=\"c_mois\" value=\"$c_mois\">
<input type=\"hidden\" name=\"c_annee\" value=\"$c_annee\">
<input type=\"hidden\" name=\"c_id\" value=\"$row[0]\"><td>
<select name=\"heure\" class=\"form1\">
<option value =\"00\" $select_h00>00</option>
<option value =\"01\" $select_h01>01</option>
<option value =\"02\" $select_h02>02</option>
<option value =\"03\" $select_h03>03</option>
<option value =\"04\" $select_h04>04</option>
<option value =\"05\" $select_h05>05</option>
<option value =\"06\" $select_h06>06</option>
<option value =\"07\" $select_h07>07</option>
<option value =\"08\" $select_h08>08</option>
<option value =\"09\" $select_h09>09</option>
<option value =\"10\" $select_h10>10</option>
<option value =\"11\" $select_h11>11</option>
<option value =\"12\" $select_h12>12</option>
<option value =\"13\" $select_h13>13</option>
<option value =\"14\" $select_h14>14</option>
<option value =\"15\" $select_h15>15</option>
<option value =\"16\" $select_h16>16</option>
<option value =\"17\" $select_h17>17</option>
<option value =\"18\" $select_h18>18</option>
<option value =\"19\" $select_h19>19</option>
<option value =\"20\" $select_h20>20</option>
<option value =\"21\" $select_h21>21</option>
<option value =\"22\" $select_h22>22</option>
<option value =\"23\" $select_h23>23</option>
</select>
H
<select name=\"minute\" class=\"form1\">
<option value =\"00\" $select_m00>00</option>
<option value =\"05\" $select_m05>05</option>
<option value =\"10\" $select_m10>10</option>
<option value =\"15\" $select_m15>15</option>
<option value =\"20\" $select_m20>20</option>
<option value =\"25\" $select_m25>25</option>
<option value =\"30\" $select_m30>30</option>
<option value =\"35\" $select_m35>35</option>
<option value =\"40\" $select_m40>40</option>
<option value =\"45\" $select_m45>45</option>
<option value =\"50\" $select_m50>50</option>
<option value =\"55\" $select_m55>55</option>
</select>
<input type=\"text\" name=\"c_value\" class=\"form1\" value=\"$row[1]\" size=\"82\"> <a href=\"#\" class=\"bouton1\" OnClick=\"document.form".$row[0].".c_action.value='Modifier';document.form".$row[0].".submit();\">Modifier</a>");
if($row[4])
{print("<a href=\"#\" class=\"bouton1\" OnClick=\"javascript:if(confirm('Vous tentez de supprimer une tâche récurrente.\\nEn la supprimant, vous supprimerez aussi toutes les taches associées (chaque mois ou chaque année).\\nÊtes vous vraiment sûr de bien vouloir la supprimer ?')) document.location.replace('index.php?c_action=Effacer&c_jour=$c_jour&c_mois=$c_mois&c_annee=$c_annee&c_id=$row[0]');\">Effacer</a>");}
else
{print(" <a href=\"#\" class=\"bouton1\" onClick=\"document.form".$row[0].".c_action.value='Effacer';document.form".$row[0].".submit();\">Effacer</a>");}
print("</td></form></tr>");
}
echo " </table>
</td>
</tr>
</table>";
}
echo"<img src=\"../images/invisible.gif\" width=\"10\" height=\"10\">
<form method=\"post\" action=\"index.php\">
<input type=\"hidden\" name=\"c_action\" value=\"Enregistrer\">
<input type=\"hidden\" name=\"c_jour\" value=\"$c_jour\">
<input type=\"hidden\" name=\"c_mois\" value=\"$c_mois\">
<input type=\"hidden\" name=\"c_annee\" value=\"$c_annee\">
<table cellspacing=\"1\" cellpadding=\"1\" border=\"0\" bgcolor=\"#082800\">
<tr class=\"texte1\" bgcolor=\"#333333\">
<td align=\"right\"><select name=\"heure\" class=\"form1\">
<option value =\"00\">00</option>
<option value =\"01\">01</option>
<option value =\"02\">02</option>
<option value =\"03\">03</option>
<option value =\"04\">04</option>
<option value =\"05\">05</option>
<option value =\"06\">06</option>
<option value =\"07\">07</option>
<option value =\"08\">08</option>
<option value =\"09\">09</option>
<option value =\"10\">10</option>
<option value =\"11\">11</option>
<option value =\"12\">12</option>
<option value =\"13\">13</option>
<option value =\"14\">14</option>
<option value =\"15\">15</option>
<option value =\"16\">16</option>
<option value =\"17\">17</option>
<option value =\"18\">18</option>
<option value =\"19\">19</option>
<option value =\"20\">20</option>
<option value =\"21\">21</option>
<option value =\"22\">22</option>
<option value =\"23\">23</option>
</select>
H
<select name=\"minute\" class=\"form1\">
<option value =\"00\">00</option>
<option value =\"05\">05</option>
<option value =\"10\">10</option>
<option value =\"15\">15</option>
<option value =\"20\">20</option>
<option value =\"25\">25</option>
<option value =\"30\">30</option>
<option value =\"35\">35</option>
<option value =\"40\">40</option>
<option value =\"45\">45</option>
<option value =\"50\">50</option>
<option value =\"55\">55</option>
</select>
<input type=\"text\" name=\"c_value\" class=\"form1\" size=\"89\"> <a href=\"#\" class=\"bouton1\" onClick=\"submit();\">Enregistrer</a><br>
<select name=\"c_repeat\" class=\"form1\">
<option value=\"0\">Ne pas répéter cette tâche</option>
<option value=\"1\">Répéter cette tâche tous les mois</option>
<option value=\"2\">Répéter cette tâche tous les ans</option>
</select></td></form></tr>
</table>";
?>
Bon courage, @+
Est tu sûr de vouloir le faire toi même ?
C'est assez complexe à réaliser, voici quelques pistes :
- Dès que tu crées un utilisateur, tu crées en même temps
une table agenda, voici un script sql avec une bonne
config de table agenda :
[php]<?
if (isset($_POST['login']))
{
mysql_connect("","","");
mysql_select_db("ta_db");
mysql_query("CREATE TABLE CALENDRIER_".$_POST['login']." (
ID int(11) NOT NULL auto_increment,
DATE date NOT NULL default '0000-00-00',
HEURE tinytext NOT NULL,
MINUTE tinytext NOT NULL,
TACHE mediumtext NOT NULL,
REPEAT tinyint(1) NOT NULL default '0',
INDEX(id),
KEY repeat (repeat))");
}
?>[/php]
Bon allez, je suis sympa, je te donne un exemple d'agenda,
ceci pour que tu te rendes compte de la difficulté. Essaies de
le remanier à ta façon, tu comprendras le mécanisme.
Pour t'en servir, remplace les valeurs de connections et
crée une session d'authentification sur un utilisateur.
Tu peux créer un test avec une table appelé CALENDRIER_BOB
Tu te connect ensuite en tant que bob, tu vas sur l'agenda ....
[php]<?
function getMicroTime()
{
$microsecondes=microtime();
list($micro,$time)=explode(' ',$microsecondes);
return($micro+$time);
}
$mt_start=getMicroTime();
$mysqlconnectid=mysql_connect("tonhost","tonuser","tonpass");
mysql_select_db("tadb",$mysqlconnectid);
$mois=array("","Janvier","Février","Mars","Avril","Mai","Juin","Juillet","Août","Septembre","Octobre","Novembre","Décembre");
$nb_jours=array("",31,28,31,30,31,30,31,31,30,31,30,31);
$jours["Mon"]="Lundi";$jours["Tue"]="Mardi";$jours["Wed"]="Mercredi";$jours["Thu"]="Jeudi";$jours["Fri"]="Vendredi";$jours["Sat"]="Samedi";$jours["Sun"]="Dimanche";
if (isset($_GET['c_jour'])){$c_jour=$_GET['c_jour'];}
if (isset($_GET['c_mois'])){$c_mois=$_GET['c_mois'];}
if (isset($_GET['c_annee'])){$c_annee=$_GET['c_annee'];}
if(!(isset($c_jour)))
{$c_jour=date("d");}
if(!(isset($c_mois)))
{$c_mois=date("m");}
if(!(isset($c_annee)))
{$c_annee=date("Y");}
$c_jour=round($c_jour);$c_mois=round($c_mois);$c_jour=round($c_jour);
if($c_jour>$nb_jours["$c_mois"])
{$c_jour=$nb_jours["$c_mois"];}
if($c_jour<1 AND isset($c_jour))
{$c_jour=1;}
$c_jour=doubleval($c_jour);
$c_mois=doubleval($c_mois);
$c_annee=doubleval($c_annee);
if($c_jour>$nb_jours[$c_mois])
{$c_jour=$c_jour-$nb_jours[$c_mois];$c_mois++;}
if($c_mois>12)
{$c_mois=1;$c_annee++;}
if(($c_annee-2000)%4==0)
{$nb_jours[2]++;}
$temp=mktime(1,1,1,$c_mois,$c_jour,$c_annee);
echo"<center>
<table cellspacing=\"1\" cellpadding=\"1\" border=\"0\" bgcolor=\"#AAAAAA\">
<tr class=\"texte1\" bgcolor=\"#666666\">
<td colspan=\"7\"><b>".$jours[date("D",$temp)]." $c_jour $mois[$c_mois] $c_annee</b> :";
if($c_jour.$c_mois.$c_annee!=date("dmY"))
{echo"<a href=\"index.php?c_jour=".date("d")."&c_mois=".date("m")."&c_annee=".date("Y")."\" class=\"lien1\">Revenir à aujourd'hui</a>";}
echo"</td>";
echo "<td bgcolor=\"#333333\" rowspan=\"9\" valign=\"top\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
for($index=1;$index<=12;$index++)
{
if($index==$c_mois)
{echo "<tr bgcolor=\"#000000\" class=\"texte1\">";}
else
{echo "<tr class=\"texte1\" bgcolor=\"#333333\">";}
echo "<td width=\"70\"><a href=\"index.php?c_jour=$c_jour&c_mois=$index&c_annee=$c_annee\" class=\"lien1\">$mois[$index]</a></td></tr>";
}
echo"</table></td>";
echo "<td bgcolor=\"#333333\" rowspan=\"9\" valign=\"top\"><table cellspacing=\"0\" cellpadding=\"0\" border=\"0\">";
for($index=date("Y");$index<=date("Y")+6;$index++)
{
if($index==$c_annee)
{echo "<tr bgcolor=\"#000000\" class=\"texte1\">";}
else
{echo "<tr class=\"texte1\" bgcolor=\"#333333\">";}
echo "<td width=\"70\"><a href=\"index.php?c_jour=$c_jour&c_mois=$c_mois&c_annee=$index\" class=\"lien1\">$index</a></td></tr>";
}
echo"</table></td></tr>
<tr class=\"texte1\" bgcolor=\"#666666\"><td align=\"center\" width=\"65\">Lundi</td><td align=\"center\" width=\"65\">Mardi</td><td align=\"center\" width=\"65\">Mercredi</td><td align=\"center\" width=\"65\">Jeudi</td><td align=\"center\" width=\"65\">Vendredi</td><td align=\"center\" width=\"65\">Samedi</td><td align=\"center\" width=\"65\">Dimanche</td></tr>
<tr class=\"texte1\" bgcolor=\"#333333\">";
$pos=0;
for($time=mktime(1,1,1,$c_mois,1,$c_annee);date("D",$time)!="Mon";$time-=86400)
{
print("<td bgcolor=\"#666666\"> </td>");
$pos++;
$temp++;
}
$pos++;
unset($tjour);
$result=mysql_query("SELECT DISTINCT DAYOFMONTH(date) FROM CALENDRIER_".$_SESSION['login']." WHERE (MONTH(date)='$c_mois' AND YEAR(date)='$c_annee') OR (MONTH(date)='$c_mois' AND repeat='2') OR repeat='1' ORDER BY date DESC");
while($row=mysql_fetch_row($result))
{$tjour[($row[0])]=1;}
for($index=1;$index<=$nb_jours[$c_mois];"")
{
while($pos<=7 AND $index<=$nb_jours[$c_mois])
{
print("<td align=\"center\"");
if($index==$c_jour)
{print(" bgcolor=\"#000000\"");}
elseif(isset($tjour[$index]))
{print(" bgcolor=\"#333333\"");}
echo "><a href=\"index.php?c_jour=$index&c_mois=$c_mois&c_annee=$c_annee\" class=\"lien1\">$index</a></td>";
$index++;
$pos++;
}
if($index>$nb_jours[$c_mois])
{
while($pos<=7)
{
echo "<td bgcolor=\"#666666\"> </td>";
$index++;
$pos++;
}
}
$pos=1;
echo "</tr><tr class=\"texte1\" bgcolor=\"#333333\">";
}
echo "<td align=\"right\" colspan=\"7\" valign=\"bottom\"><br>Jour ";
$c_jour1=$c_jour-1;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1<1)
{
$c_mois1--;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
$c_jour1=$nb_jours[$c_mois1];
}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">précédent</a> / ";
$c_jour1=$c_jour+1;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1>$nb_jours[$c_mois1])
{$c_jour1=1;$c_mois1++;}
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">suivant</a> <br>";
$c_jour1=$c_jour- 7;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1<1)
{
$c_mois1--;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
$c_jour1=$c_jour1+$nb_jours[$c_mois1];
}
echo "<br><a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">-7 jours</a> / ";
$c_jour1=$c_jour+7;
$c_mois1=$c_mois;
$c_annee1=$c_annee;
if($c_jour1>$nb_jours[$c_mois1])
{$c_jour1=$c_jour1-$nb_jours[$c_mois1];$c_mois1++;}
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
echo "<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">+7 jours</a> <br> ";
$c_jour1=$c_jour;
$c_mois1=$c_mois-1;
$c_annee1=$c_annee;
if($c_mois1<1)
{$c_mois1=12;$c_annee1--;}
echo"<br>Mois <a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">précédent</a> / ";
$c_jour1=$c_jour;
$c_mois1=$c_mois+1;
$c_annee1=$c_annee;
if($c_mois1>12)
{$c_mois1=1;$c_annee1++;}
print("<a href=\"index.php?c_jour=$c_jour1&c_mois=$c_mois1&c_annee=$c_annee1\" class=\"lien1\">suivant</a> </td></tr>
</table>");
$c_value="";
$c_value=htmlentities($c_value);
if (isset($_POST['c_action'])){$c_action=$_POST['c_action'];}
if (isset($_POST['heure'])){$heure=$_POST['heure'];}
if (isset($_POST['minute'])){$minute=$_POST['minute'];}
if (isset($_POST['c_id'])){$c_id=$_POST['c_id'];}
if (isset($_POST['c_repeat'])){$c_repeat=$_POST['c_repeat'];}
if (isset($_POST['c_value'])){$c_value=$_POST['c_value'];}
if (isset($_GET['c_action'])){$c_action=$_GET['c_action'];}
if (isset($_GET['heure'])){$heure=$_GET['heure'];}
if (isset($_GET['minute'])){$minute=$_GET['minute'];}
if (isset($_GET['c_id'])){$c_id=$_GET['c_id'];}
if (isset($_GET['c_repeat'])){$c_repeat=$_GET['c_repeat'];}
if (isset($_GET['c_value'])){$c_value=$_GET['c_value'];}
if (isset($c_action))
{
if($c_action=="Enregistrer")
{$query=mysql_query("INSERT INTO CALENDRIER_".$_SESSION['login']."(HEURE,MINUTE,DATE,TACHE,REPEAT) VALUES('$heure','$minute','$c_annee-$c_mois-$c_jour','$c_value','$c_repeat')");}
elseif($c_action=="Modifier")
{$query=mysql_query("UPDATE CALENDRIER_".$_SESSION['login']." SET HEURE='$heure', MINUTE='$minute', TACHE='$c_value' WHERE id='$c_id'");}
elseif($c_action=="Effacer")
{$query=mysql_query("DELETE FROM CALENDRIER_".$_SESSION['login']." WHERE ID='$c_id'");}
}
$ok=0;
$result=mysql_query("SELECT ID,TACHE,HEURE,MINUTE,REPEAT FROM CALENDRIER_".$_SESSION['login']." WHERE DATE='$c_annee-$c_mois-$c_jour' OR (MONTH(DATE)='$c_mois' AND DAYOFMONTH(DATE)='$c_jour' AND repeat='2') OR (DAYOFMONTH(DATE)='$c_jour' AND repeat='1') ORDER BY HEURE,MINUTE");
if(mysql_num_rows($result))
{
echo "<table cellspacing=\"1\" cellpadding=\"0\" border=\"0\" bgcolor=\"#082800\"><tr><td bgcolor=\"#333333\"><table cellspacing=\"0\" cellpadding=\"2\" border=\"0\" bgcolor=\"#333333\">";
while($row=mysql_fetch_row($result))
{
if ($row[2] == "00"){$select_h00 = "selected";}else{$select_h00 = "";}
if ($row[2] == "01"){$select_h01 = "selected";}else{$select_h01 = "";}
if ($row[2] == "02"){$select_h02 = "selected";}else{$select_h02 = "";}
if ($row[2] == "03"){$select_h03 = "selected";}else{$select_h03 = "";}
if ($row[2] == "04"){$select_h04 = "selected";}else{$select_h04 = "";}
if ($row[2] == "05"){$select_h05 = "selected";}else{$select_h05 = "";}
if ($row[2] == "06"){$select_h06 = "selected";}else{$select_h06 = "";}
if ($row[2] == "07"){$select_h07 = "selected";}else{$select_h07 = "";}
if ($row[2] == "08"){$select_h08 = "selected";}else{$select_h08 = "";}
if ($row[2] == "09"){$select_h09 = "selected";}else{$select_h09 = "";}
if ($row[2] == "10"){$select_h10 = "selected";}else{$select_h10 = "";}
if ($row[2] == "11"){$select_h11 = "selected";}else{$select_h11 = "";}
if ($row[2] == "12"){$select_h12 = "selected";}else{$select_h12 = "";}
if ($row[2] == "13"){$select_h13 = "selected";}else{$select_h13 = "";}
if ($row[2] == "14"){$select_h14 = "selected";}else{$select_h14 = "";}
if ($row[2] == "15"){$select_h15 = "selected";}else{$select_h15 = "";}
if ($row[2] == "16"){$select_h16 = "selected";}else{$select_h16 = "";}
if ($row[2] == "17"){$select_h17 = "selected";}else{$select_h17 = "";}
if ($row[2] == "18"){$select_h18 = "selected";}else{$select_h18 = "";}
if ($row[2] == "19"){$select_h19 = "selected";}else{$select_h19 = "";}
if ($row[2] == "20"){$select_h20 = "selected";}else{$select_h20 = "";}
if ($row[2] == "21"){$select_h21 = "selected";}else{$select_h21 = "";}
if ($row[2] == "22"){$select_h22 = "selected";}else{$select_h22 = "";}
if ($row[2] == "23"){$select_h23 = "selected";}else{$select_h23 = "";}
if ($row[3] == "00"){$select_m00 = "selected";}else{$select_m00 = "";}
if ($row[3] == "05"){$select_m05 = "selected";}else{$select_m05 = "";}
if ($row[3] == "10"){$select_m10 = "selected";}else{$select_m10 = "";}
if ($row[3] == "15"){$select_m15 = "selected";}else{$select_m15 = "";}
if ($row[3] == "20"){$select_m20 = "selected";}else{$select_m20 = "";}
if ($row[3] == "25"){$select_m25 = "selected";}else{$select_m25 = "";}
if ($row[3] == "30"){$select_m30 = "selected";}else{$select_m30 = "";}
if ($row[3] == "35"){$select_m35 = "selected";}else{$select_m35 = "";}
if ($row[3] == "40"){$select_m40 = "selected";}else{$select_m40 = "";}
if ($row[3] == "45"){$select_m45 = "selected";}else{$select_m45 = "";}
if ($row[3] == "50"){$select_m50 = "selected";}else{$select_m50 = "";}
if ($row[3] == "55"){$select_m55 = "selected";}else{$select_m55 = "";}
print("<tr class=\"texte1\" bgcolor=\"#666666\"><form method=\"post\" action=\"index.php\" name=\"form".$row[0]."\">
<input type=\"hidden\" name=\"c_action\" value=\"Modifier\">
<input type=\"hidden\" name=\"c_jour\" value=\"$c_jour\">
<input type=\"hidden\" name=\"c_mois\" value=\"$c_mois\">
<input type=\"hidden\" name=\"c_annee\" value=\"$c_annee\">
<input type=\"hidden\" name=\"c_id\" value=\"$row[0]\"><td>
<select name=\"heure\" class=\"form1\">
<option value =\"00\" $select_h00>00</option>
<option value =\"01\" $select_h01>01</option>
<option value =\"02\" $select_h02>02</option>
<option value =\"03\" $select_h03>03</option>
<option value =\"04\" $select_h04>04</option>
<option value =\"05\" $select_h05>05</option>
<option value =\"06\" $select_h06>06</option>
<option value =\"07\" $select_h07>07</option>
<option value =\"08\" $select_h08>08</option>
<option value =\"09\" $select_h09>09</option>
<option value =\"10\" $select_h10>10</option>
<option value =\"11\" $select_h11>11</option>
<option value =\"12\" $select_h12>12</option>
<option value =\"13\" $select_h13>13</option>
<option value =\"14\" $select_h14>14</option>
<option value =\"15\" $select_h15>15</option>
<option value =\"16\" $select_h16>16</option>
<option value =\"17\" $select_h17>17</option>
<option value =\"18\" $select_h18>18</option>
<option value =\"19\" $select_h19>19</option>
<option value =\"20\" $select_h20>20</option>
<option value =\"21\" $select_h21>21</option>
<option value =\"22\" $select_h22>22</option>
<option value =\"23\" $select_h23>23</option>
</select>
H
<select name=\"minute\" class=\"form1\">
<option value =\"00\" $select_m00>00</option>
<option value =\"05\" $select_m05>05</option>
<option value =\"10\" $select_m10>10</option>
<option value =\"15\" $select_m15>15</option>
<option value =\"20\" $select_m20>20</option>
<option value =\"25\" $select_m25>25</option>
<option value =\"30\" $select_m30>30</option>
<option value =\"35\" $select_m35>35</option>
<option value =\"40\" $select_m40>40</option>
<option value =\"45\" $select_m45>45</option>
<option value =\"50\" $select_m50>50</option>
<option value =\"55\" $select_m55>55</option>
</select>
<input type=\"text\" name=\"c_value\" class=\"form1\" value=\"$row[1]\" size=\"82\"> <a href=\"#\" class=\"bouton1\" OnClick=\"document.form".$row[0].".c_action.value='Modifier';document.form".$row[0].".submit();\">Modifier</a>");
if($row[4])
{print("<a href=\"#\" class=\"bouton1\" OnClick=\"javascript:if(confirm('Vous tentez de supprimer une tâche récurrente.\\nEn la supprimant, vous supprimerez aussi toutes les taches associées (chaque mois ou chaque année).\\nÊtes vous vraiment sûr de bien vouloir la supprimer ?')) document.location.replace('index.php?c_action=Effacer&c_jour=$c_jour&c_mois=$c_mois&c_annee=$c_annee&c_id=$row[0]');\">Effacer</a>");}
else
{print(" <a href=\"#\" class=\"bouton1\" onClick=\"document.form".$row[0].".c_action.value='Effacer';document.form".$row[0].".submit();\">Effacer</a>");}
print("</td></form></tr>");
}
echo " </table>
</td>
</tr>
</table>";
}
echo"<img src=\"../images/invisible.gif\" width=\"10\" height=\"10\">
<form method=\"post\" action=\"index.php\">
<input type=\"hidden\" name=\"c_action\" value=\"Enregistrer\">
<input type=\"hidden\" name=\"c_jour\" value=\"$c_jour\">
<input type=\"hidden\" name=\"c_mois\" value=\"$c_mois\">
<input type=\"hidden\" name=\"c_annee\" value=\"$c_annee\">
<table cellspacing=\"1\" cellpadding=\"1\" border=\"0\" bgcolor=\"#082800\">
<tr class=\"texte1\" bgcolor=\"#333333\">
<td align=\"right\"><select name=\"heure\" class=\"form1\">
<option value =\"00\">00</option>
<option value =\"01\">01</option>
<option value =\"02\">02</option>
<option value =\"03\">03</option>
<option value =\"04\">04</option>
<option value =\"05\">05</option>
<option value =\"06\">06</option>
<option value =\"07\">07</option>
<option value =\"08\">08</option>
<option value =\"09\">09</option>
<option value =\"10\">10</option>
<option value =\"11\">11</option>
<option value =\"12\">12</option>
<option value =\"13\">13</option>
<option value =\"14\">14</option>
<option value =\"15\">15</option>
<option value =\"16\">16</option>
<option value =\"17\">17</option>
<option value =\"18\">18</option>
<option value =\"19\">19</option>
<option value =\"20\">20</option>
<option value =\"21\">21</option>
<option value =\"22\">22</option>
<option value =\"23\">23</option>
</select>
H
<select name=\"minute\" class=\"form1\">
<option value =\"00\">00</option>
<option value =\"05\">05</option>
<option value =\"10\">10</option>
<option value =\"15\">15</option>
<option value =\"20\">20</option>
<option value =\"25\">25</option>
<option value =\"30\">30</option>
<option value =\"35\">35</option>
<option value =\"40\">40</option>
<option value =\"45\">45</option>
<option value =\"50\">50</option>
<option value =\"55\">55</option>
</select>
<input type=\"text\" name=\"c_value\" class=\"form1\" size=\"89\"> <a href=\"#\" class=\"bouton1\" onClick=\"submit();\">Enregistrer</a><br>
<select name=\"c_repeat\" class=\"form1\">
<option value=\"0\">Ne pas répéter cette tâche</option>
<option value=\"1\">Répéter cette tâche tous les mois</option>
<option value=\"2\">Répéter cette tâche tous les ans</option>
</select></td></form></tr>
</table>";
?>[/php]
Bon courage, @+