Bonjour,
Je souhaiterai realiser un agenda unique pour chaque utilisateur avec la possibilite de le mettre a jour et consultable uniquement par cette utilisateur.
Merci.
<?
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, <?
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, @+