javascript - FullCalendar - 如何为数据库中的每个用户加载计划
问题描述
我正在使用 FullCalendar。添加日程时,我将用户的电话号码存储在数据库中。获取时,我想获取由 PHP 中的用户电话号码分隔的时间表。我应该怎么办?
测试.js
var calendar = $('#calendar').fullCalendar({
height:650,
locale:'ko',
editable: true,
header:{
left:'prev,next today',
center:'title',
right:'month,agendaWeek,agendaDay,listDay'
},
events: function(start,end,callback){
var pno="2154421215";
$.ajax({
url: 'fetch-event.php',
data: {pno:pno},
type: "POST",
success: function (obj) {
var events = [];
$.each(obj, function(index, value) {
events.push({
id: value['id'],
start: value['start'],
title: value['title'],
end: value['end']
});
});
callback(events);
}
},
displayEventTime: true,
eventRender: function (event, element, view) {
if (event.allDay === 'true') {
event.allDay = true;
} else {
event.allDay = false;
}
},
eventLimit: true,
selectable: true,
selectHelper: true,
select: function (start, end, allDay) {
var title = prompt('input title:');
var pno="2154421215";
if (title) {
var start = $.fullCalendar.formatDate(start, "Y-MM-DD HH:mm:ss");
var end = $.fullCalendar.formatDate(end, "Y-MM-DD HH:mm:ss");
$.ajax({
url: 'add-event.php',
data: 'title=' + title + '&start=' + start + '&end=' + end + '&pno=' + pno ,
type: "POST",
success: function (data) {
alert("success");
}
});
calendar.fullCalendar('renderEvent',
{
title: title,
start: start,
end: end,
allDay: allDay
},
true
);
}
calendar.fullCalendar('unselect');
},
editable: false,
eventClick: function (event) {
var deleteMsg = confirm("delete?");
if (deleteMsg) {
$.ajax({
type: "POST",
url: "delete-event.php",
data: "&id=" + event.id,
success: function (response) {
if(parseInt(response) > 0) {
$('#calendar').fullCalendar('removeEvents', event.id);
alert("success");
}
}
});
}
}
});
获取事件.php
<?php
$`pno = `$_POST`['pno'];
$json = array();
$sqlQuery = "SELECT * FROM calendar WHERE pno='".$pno."' ORDER BY id";
$result = mysqli_query($conn, $sqlQuery);
$eventArray = array();
while ($row = mysqli_fetch_assoc($result)) {
array_push($eventArray, $row);
}
mysqli_free_result($result);
mysqli_close($conn);
echo json_encode($eventArray);
?>
解决方案
推荐阅读
- json - ASP.NET 从 JSON SerializerSettings 完全忽略
- php - 启用 SSL 认证 (HTTPS) 后 HTTP 附加 GET 输入两次
- javascript - Angularjs:如何在所有分页页面中保留 $index,因为它们在数据列表中
- android - 我无法完成活动
- javascript - Vue Router + Vuex:如何让 beforeEach 路由守卫等待 Vuex 状态变化?
- r - 如何将一个字符串按多个空格拆分为 R 中的列表元素?
- react-native - 使用 React Native 检测 iPhone iOS 暗模式
- java - 将变量添加到 framework.jar 后,它仍然无法访问
- matlab - findpeaks 函数给出太多结果
- python - AWS - S3 - GetBucketPolicy