drfals1307 2018-09-15 04:21
浏览 50

FullCalendar - 如何为DB中的每个用户加载计划

I am using FullCalendar. When I add a schedule, I store the phone numbers of users in the database. When fetching, I want to fetch the schedule separated by user phone number in PHP. What should I do?

test.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");
                    }
                }
            });
        }
    }

});

fetch-event.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);
?>
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
    • ¥15 (希望可以解决问题)ma和mb文件无法正常打开,打开后是空白,但是有正常内存占用,但可以在打开Maya应用程序后打开场景ma和mb格式。
    • ¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
    • ¥20 腾讯企业邮箱邮件可以恢复么
    • ¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗?
    • ¥15 错误 LNK2001 无法解析的外部符号
    • ¥50 安装pyaudiokits失败
    • ¥15 计组这些题应该咋做呀
    • ¥60 更换迈创SOL6M4AE卡的时候,驱动要重新装才能使用,怎么解决?
    • ¥15 让node服务器有自动加载文件的功能