CODEWITHSUNDEEP
fullcalendar
user1545261
user1545261

Reputation: 3

Full Calendar not displaying my events from my database

The events from my database are not displayed on my Full Calendar. I used the codes from the examples that I've seen online so please bear with the codes that I have right now. I would appreciate all the help that I will get from you guys. Thanks!

<script>
                $(document).ready(function() {
                // page is now ready, initialize the calendar...

                $('#calendar').fullCalendar({
                    header: {
                        left: 'prev,next today',
                        center: 'title',
                        right: 'month,agendaWeek,agendaDay'
                    },editable: false,

                    events: "json_events.php",

                    eventDrop: function(event, delta) {
                            alert(event.title + ' was moved ' + delta + ' days\n' +
                            '(should probably update your database)');
                    },

                    loading: function(bool) {
                    if (bool) $('#loading').show();
                    else $('#loading').hide();
                }
                });
        });
   </script>

json_events.php

<?php
    include 'connect.php';
    session_start();
    $result = mysql_query("SELECT ID, title, startDate AS startDate FROM events");
    mysql_close();
    $events = array();
    while ($row=mysql_fetch_array($result)){
       $title = $row['title'];
       $eventsArray['id'] =  $row['ID'];
       $eventsArray['title'] = $title;
       $eventsArray['startDate'] = $row['startDate']; 
       $events[] = $eventsArray;
     }
  echo json_encode($events);
?>

Upvotes: 0

Views: 1589

Answers (1)

wojg21
wojg21

Reputation: 93

<?php
    include 'connect.php';
    session_start();
    $result = mysql_query("SELECT ID, title, startDate AS startDate FROM events");
    mysql_close();
    $events = array();
    while ($row=mysql_fetch_array($result)){            
        $id =  $row['ID'];
        $title = $row['title'];
        $start = $row['startDate']; 

        $events = array(
        'id' =>  "$id",
        'title' => "$title",
        'start' => "$start"
        );

    }
    echo json_encode($events);
?>

That should work for you. If you do not want the even to be all day just add 'allDay' => "" after the start statement.

Upvotes: 2

Related Questions