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条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 opencv图像处理,需要四个处理结果图
    • ¥15 无线移动边缘计算系统中的系统模型
    • ¥15 深度学习中的画图问题
    • ¥15 java报错:使用mybatis plus查询一个只返回一条数据的sql,却报错返回了1000多条
    • ¥15 Python报错怎么解决
    • ¥15 simulink如何调用DLL文件
    • ¥15 关于用pyqt6的项目开发该怎么把前段后端和业务层分离
    • ¥30 线性代数的问题,我真的忘了线代的知识了
    • ¥15 有谁能够把华为matebook e 高通骁龙850刷成安卓系统,或者安装安卓系统
    • ¥188 需要修改一个工具,懂得汇编的人来。