我正在使用全日历JavaScript库来开发日历。我已经准备好前端，但是在将事件数据放到日历上之后，我不确定如何更新数据库中的事件数据。我对JavaScript还是很陌生，我已经提到了一些类似的问题，但是并没有得到我想要的东西。
这是我的代码：
**index.php**
<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<div id='external-events'>
<p>
<strong>Draggable Events</strong>
</p>
<div class='fc-event'>My Event 1</div>
<div class='fc-event'>My Event 2</div>
<div class='fc-event'>My Event 3</div>
<div class='fc-event'>My Event 4</div>
<div class='fc-event'>My Event 5</div>
<p>
<input type='checkbox' id='drop-remove' />
<label for='drop-remove'>remove after drop</label>
</p>
</div>
<div id='calendar-container'>
<div id='calendar'></div>
</div>
** main.js**
document.addEventListener('DOMContentLoaded', function() {
var Calendar = FullCalendar.Calendar;
var Draggable = FullCalendarInteraction.Draggable;
var containerEl = document.getElementById('external-events');
var calendarEl = document.getElementById('calendar');
var checkbox = document.getElementById('drop-remove');
new Draggable(containerEl, {
itemSelector: '.fc-event',
eventData: function(eventEl) {
return {
title: eventEl.innerText
};
}
});
var calendar = new Calendar(calendarEl, {
plugins: [ 'interaction', 'dayGrid', 'timeGrid' ],
header: {
left: 'prev,next today',
center: 'title',
right: 'dayGridMonth,timeGridWeek,timeGridDay'
},
editable: true,
droppable: true,
drop: function(info) {
if (checkbox.checked) {
info.draggedEl.parentNode.removeChild(info.draggedEl);
}
},
});
calendar.render();
});
**add_event.php**
require 'database.php';
echo $_POST['title'];
$title = $_POST['title'];
$start = $_POST['start'];
$end = $_POST['end'];
$conn = DB::databaseConnection();
$conn->beginTransaction();
$sqlInsert = "INSERT INTO Events (title, start, [end]) VALUES (:title, :start, :end)";
$stmt = $conn->prepare($sqlInsert);
$stmt->bindParam(':title', $title);
$stmt->bindParam(':start', $start);
$stmt->bindParam(':end', $end);
if ($stmt->execute()) {
$conn->commit();
return true;
} else {
$conn->rollback();
return false;
}
这是我提到的代码销的链接：https ://fullcalendar.io/docs/external-dragging-demo我不确定如何获取将JavaScript链接到insert函数的方法。因此，当事件被删除时，应该将其保存在数据库中。
您需要eventReceive在fullCalendar中处理回调。这将为您提供来自放置项的关联事件数据。然后，您可以将该数据发送到add_event.php使用AJAX。有关回调的更多详细信息，请参见https://fullcalendar.io/docs/eventReceive。
这样的事情应该起作用：
eventReceive: function( info ) {
//get the bits of data we want to send into a simple object
var eventData = {
title: info.event.title,
start: info.event.start,
end: info.event.end
};
//send the data via an AJAX POST request, and log any response which comes from the server
fetch('add_event.php', {
method: 'POST',
headers: {'Accept': 'application/json'},
body: encodeFormData(eventData)
})
.then(response => console.log(response))
.catch(error => console.log(error));
}
注意：我使用了现代的fetch（）函数来执行AJAX调用，而不是使用较早的XmlHttpRequest或任何依赖jQuery或其他外部库的东西。
这是上面的代码使用的encodeForm函数的代码（该想法的信息，请在本网站获得）：
const encodeFormData = (data) => {
var form_data = new FormData();
for ( var key in data ) {
form_data.append(key, data[key]);
}
return form_data;
}
演示：
document.addEventListener('DOMContentLoaded', function() {
var Calendar = FullCalendar.Calendar;
var Draggable = FullCalendarInteraction.Draggable;
var containerEl = document.getElementById('external-events');
var calendarEl = document.getElementById('calendar');
var checkbox = document.getElementById('drop-remove');
new Draggable(containerEl, {
itemSelector: '.fc-event',
eventData: function(eventEl) {
return {
title: eventEl.innerText
};
}
});
var calendar = new Calendar(calendarEl, {
plugins: ['interaction', 'dayGrid', 'timeGrid'],
header: {
left: 'prev,next today',
center: 'title',
right: 'dayGridMonth,timeGridWeek,timeGridDay'
},
editable: true,
droppable: true,
eventReceive: function(info) {
//get the bits of data we want to send into a simple object
var eventData = {
title: info.event.title,
start: info.event.start,
end: info.event.end
};
console.log(eventData);
//send the data via an AJAX POST request, and log any response which comes from the server
fetch('add_event.php', {
method: 'POST',
headers: {
'Accept': 'application/json'
},
body: encodeFormData(eventData)
})
.then(response => console.log(response))
.catch(error => console.log(error));
}
});
calendar.render();
});
const encodeFormData = (data) => {
var form_data = new FormData();
for (var key in data) {
form_data.append(key, data[key]);
}
return form_data;
}<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<link href='https://unpkg.com/@fullcalendar/[email protected]/main.min.css' rel='stylesheet' />
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<script src='https://unpkg.com/@fullcalendar/[email protected]/main.min.js'></script>
<div id='external-events'>
<p>
<strong>Draggable Events</strong>
</p>
<div class='fc-event'>My Event 1</div>
<div class='fc-event'>My Event 2</div>
<div class='fc-event'>My Event 3</div>
<div class='fc-event'>My Event 4</div>
<div class='fc-event'>My Event 5</div>
<p>
<input type='checkbox' id='drop-remove' />
<label for='drop-remove'>remove after drop</label>
</p>
</div>
<div id='calendar-container'>
<div id='calendar'></div>
</div>PS您还应该紧急修复PHP代码中的SQL注入漏洞，就像我在上面的评论中提到的那样。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句