<?php session_start(); require_once("../../inc/confNetisse.php"); $id_conseiller = isset($_POST['id_conseiller']) ? intval($_POST['id_conseiller']) : intval($_SESSION['id']); $id_agence = isset($_POST["id_agence"]) ? intval($_POST["id_agence"]) : '-1'; $title = isset($_POST["title"]) ? $_POST["title"] : ''; $start = isset($_POST["start"]) ? $_POST["start"] : ''; $end = (isset($_POST["end"]) && $_POST["end"]!="") ? $_POST["end"] : date('Y-m-d',$start)." 20:00:00"; $allDay = isset($_POST["allDay"]) ? $_POST["allDay"] : 0; //$allDay = ($allDay==false) ? 0 : 1; if($title != ''){ $query = "INSERT INTO ca_events (id_agence, id_conseiller, title, start, end, allDay) VALUES (:id_agence, :id_conseiller, :title, :startq, :endq, :allDay)"; $v = array(':id_agence'=>$id_agence, ':id_conseiller'=>$id_conseiller, ':title'=>$title, ':startq'=>$start, ':endq'=>$end, ':allDay'=>$allDay); $stmt = excuteQuery($query, $v); $res = excuteQuery($GLOBALS["cnx"], "SELECT LAST_INSERT_ID( ) AS 'id_event'"); if (!$res['status']) wts_die (var_dump($res['stmt']->errorInfo())); $id = $res['stmt']->fetchObject(); print $id->id_event; } else{ print "Requete non aboutie"; print "<br/>ID Agence: ".$id_agence."<br/>Titre: ".$title."<br/>Start: ".$start."<br/>End: ".$end."<br/>AllDay: ".$allDay; } //date('Y-m-d T H:i:s' , strtotime($start)+900) //print "INSERT INTO ca_events (id_agence, id_conseiller, title, start, end, allDay) VALUES ($id_agence, '$id_conseiller', '$title', '$start', '$end', '$allDay')"; ?>