1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134
| <?php
function checkData()
{
$result = array();
$result['event_id'] = isset($_POST['id']) ? intval($_POST['id']) : false;
list($daydeb,$monthdeb,$yeardeb)=explode("-",$_POST['datepickerdeb']);
list($dayfin,$monthfin,$yearfin)=explode("-",$_POST['datepickerfin']);
$hour = isset($_POST['hour']) && $_POST['hour'] != '' ? $_POST['hour'] : false;
$minute = isset($_POST['minute']) && $_POST['minute'] != '' ? $_POST['minute'] : false;
$result['event_name'] = $_POST['name'] ? $_POST['name'] : false;
$result['event_comment'] = $_POST['comment2'] ? $_POST['comment2'] : false;
$result['event_allday'] = isset($_POST['allday']) ? $_POST['allday'] : false;
$result['check'] = false;
$result['event_date'] = $yeardeb.'-'.$monthdeb.'-'.$daydeb;
$result['event_time'] = $hour.':'.$minute.':00';
if ((empty($daydeb) || empty($monthdeb) || empty($yeardeb) || empty($dayfin) || empty($monthfin) || empty($yearfin) || empty($result['event_name']) || empty($result['event_comment'])))
$empty=true;
else $empty=false;
$result['empty']=$empty;
if ((checkdate($monthdeb, $daydeb, $yeardeb))&&(checkdate($monthfin, $dayfin, $yearfin) ))
{
if ($hour !== false && $minute !== false && $hour >= 0 && $hour < 24 && $minute > -1 && $minute < 60)
{
if (!empty($result['event_name']))
{
if (!empty($result['event_comment']))
{
$result['check'] = true;
}
}
}
}
return $result;
}
/***************************************************************************************/
function saveData($result)
{
include (dirname(__DIR__).'\includes\connect_mysql.php');
$result['event_date'] = quote_smart($result['event_date']);
$result['event_time'] = quote_smart($result['event_time']);
$result['event_name'] = quote_smart($result['event_name']);
$result['event_comment'] = quote_smart($result['event_comment']);
$result['event_allday'] = quote_smart($result['event_allday']);//var_dump($result);
$sql = '
UPDATE calendar_event
SET
event_date = :date,
event_time = :time,
event_name = :name,
event_comment = :comment,
event_allday = :allday
WHERE event_id = :id
';
$sql = $bdd->prepare($sql);;
$sql->execute(array(
':date' => $result['event_date'],
':time' => $result['event_time'],
':name' => $result['event_name'],
':comment' => $result['event_comment'],
':allday' => $result['event_allday'],
':id' => $result['event_id']
));
$error = $sql->errorInfo();
if ($error[0] !== '00000')
{
echo 'Une erreur s\'est produite.';
}
else
{
redirect_add_event();
}
}
/***************************************************************************************/
function displayForm($result = array(),$_POSTmodif)
{.
list($year,$month,$day)=explode("-",$result['event_date']);
$datepicker_form = $day."-".$month."-".$year;
$hour = isset($result['hour']) ? $result['hour'] : '';
$minute = isset($result['minute']) ? $result['minute'] : '';
$result['event_name'] = isset($result['event_name']) ? $result['event_name'] : '';
$result['event_comment'] = isset($result['event_comment']) ? $result['event_comment'] : '';
?>
<form id="form-add-event" method="post" action="action_modif-event.php">
<p>Date de début : <input type="text" id="datepickerdeb" name="datepickerdeb" value="<?php if (isset($datepicker_form)) echo $datepicker_form;?>"/></p>
<p>Date de fin : <input type="text" id="datepickerfin" name="datepickerfin" value="<?php if (isset($datepicker_form)) echo $datepicker_form;?>"/></p>
<p>
<label for="hour">Heure : </label>
<select name="hour">
<?php for ($i=0;$i<24;$i++) {
echo '<option value="'.$i.'"'; if ($hour==$i) {echo ' selected="selected"';}; echo '>' .$i.'</option>';
}
?>
</select>
<label for="minute">Minute : </label>
<select name="minute" value="<?php echo $minute;?>">
<?php for ($i=0;$i<60;$i++) {
echo '<option value="'.$i.'"'; if ($minute==$i) {echo ' selected="selected"';}; echo '>' .$i.'</option>';
}
?>
</select><br/>
ou l'événement dure toute la journée :<input type="checkbox" id="allday" value="<?php if (isset($result['event_allday'])) echo $result['event_allday'];?>" name="allday" size="1" <?php if (isset($_POST["allday"])) { if ($_POST["allday"] == "on") { echo "checked"; } };?> />
</p>
<p><label for="name">Nom : </label><input type="text" id="name" name="name" value="<?php echo $result['event_name']?>" /></p>
<p><label for="comment">commentaire : </label><textarea id="comment" name="comment2" cols="30" rows="5"><?php echo $result['event_comment']?></textarea></p>
<input type="hidden" name="id" value="<?php echo $_POSTmodif['id'];?>">
<p><input type="submit" name="submitModif" value="Ajouter l'événement"/></p>
<p><INPUT TYPE='button' value='Annuler' onclick="location.href='http://localhost/cal/index.php'"</p>
</form>
<?php }
/***************************************************************************************/
?> |
Partager