full calendar mysql,php – fullCalendar事件将方法发布到MySQL

我正在尝试使用fullCalendar和MySQL创建一个MySQL支持的事件接口.我试图操纵fullCalendar文档中的示例,并已成功从我的数据库创建事件订阅源.

我现在正在尝试创建一个eventDrop调用,它将事件id,标题和开始时间发送到数据库.我使用了之前的question中的代码来创建eventDrop调用,这里是整个callendar页面的JavaScript：

$(document).ready(function() {

/* initialize the external events

-----------------------------------------------------------------*/

$('#external-events div.external-event').each(function() {

// create an Event Object (http://arshaw.com/fullcalendar/docs/event_data/Event_Object/)

// it doesn't need to have a start or end

var eventObject = {

title: $.trim($(this).text()) // use the element's text as the event title

};

// store the Event Object in the DOM element so we can get to it later

$(this).data('eventObject', eventObject);

// make the event draggable using jQuery UI

$(this).draggable({

zIndex: 999,

revert: true, // will cause the event to go back to its

revertDuration: 0 // original position after the drag

});

});

/* initialize the calendar

-----------------------------------------------------------------*/

$('#calendar').fullCalendar({

header: {

left: 'prev,next today',

center: 'title',

right: 'month,agendaWeek,agendaDay'

},

editable: true,

droppable: true, // this allows things to be dropped onto the calendar !!!

drop: function(date, allDay) { // this function is called when something is dropped

// retrieve the dropped element's stored Event Object

var originalEventObject = $(this).data('eventObject');

// we need to copy it, so that multiple events don't have a reference to the same object

var copiedEventObject = $.extend({}, originalEventObject);

// assign it the date that was reported

copiedEventObject.start = date;

copiedEventObject.allDay = allDay;

// render the event on the calendar

// the last `true` argument determines if the event "sticks" (http://arshaw.com/fullcalendar/docs/event_rendering/renderEvent/)

$('#calendar').fullCalendar('renderEvent', copiedEventObject, true);

// if so, remove the element from the "Draggable Events" list

$(this).remove();

},

// events from mysql database

events: "/json-events.php",

// submit to database

eventDrop: function(calEvent, jsEvent, view) {

var method = 'POST';

var path = 'submit.php';

var params = new Array();

params['id'] = calEvent.id;

params['start'] = calEvent.start;

params['end'] = calEvent.end;

params['title'] = calEvent.title;

post_to_url( path, params, method);

}

});

});

我希望PHP文件接收POST数据并将其插入到数据库中,结束时间等于开始时间加上15分钟(在下面回答后编辑)：

mysql_connect("") or die(mysql_error());

mysql_select_db("") or die(mysql_error());

$id = $_POST["id"];

$title = $_POST["title"];

$start = $_POST["start"];

$end = date(Y-m-d T H:i:s , strtotime($start)+900);

$query = "INSERT INTO `events` VALUES (`$id`, `$title`, `$start`, `$end`, ``)";

mysql_query($query);

print $query;

?>

数据库未接收事件数据.