display and edit events using fullcalendar event calendar

[mythri]

Hello ,

 

I am trying to display my planned events in calendar using full calendar json, jquery. But its not getting displayed, but its getting inserted. I am not very good at jquery or json. please somebody help me in this...

 

here is my code

 

in my calendar.php (display page)

 

<div class="span8">
                       <div class="w-box w-box-green">
                            <div class="w-box-header"></div>
                            <div class="w-box-content">
                                <div id='calendar_json'></div>
                            </div>
                            <div class="w-box-footer">
                                <p class="f-text">JSON events fetched from a script</p>
                            </div>
                        </div>
                    </div>  
                </div>

and in my calendar.js

 

 jsonEvents: function() {
            if($('#calendar_json').length) {
                $('#calendar_json').fullCalendar({
                    header: {
                        left: 'month,agendaWeek,agendaDay',
                        center: 'title',
                        right: 'prev,next'
                    },
                    buttonText: {
                        prev: '<i class="icon-chevron-left icon-white cal_prev" />',
                        next: '<i class="icon-chevron-right icon-white cal_next" />'
                    },
                    editable: true,
                    firstDay: 1, // 0 - Sunday, 1 - Monday
                    events: "php_helpers/json-events.php",
                    eventDrop: function(event, delta) {
                        alert(event.title + ' was moved ' + delta + ' days\n' +
                            '(should probably update your database)');
                    }
                });
            }

json-events.php

 

 

include("connect.php");
$year = date('Y');
$month = date('m');


//$db=public_db_connect();
$year = date('Y');
$month = date('m');


$command = "SELECT * FROM planner";


$result = mysql_query($command) or die (mysql_error());


while ($row = mysql_fetch_array($result)) {
echo "hi";
    //$start = date("D, j M Y G:i:s T", strtotime($row['start']));
    //$end = date("D, j M Y G:i:s T", strtotime($row['end_time'])); 
$start = date("Y-m-d", strtotime($row['from_time']));
//$start = "$year-$month-20";
    $myid =  $row['plan_id'];
$eventsArray['plan_id'] =  (int)trim($myid); 
    //$eventsArray['title'] = $row['title'];  
$title = $row['company']; 
//$title = $row['title']; 
//echo $title;
$eventsArray['company'] = $title; 
    $eventsArray['from_time'] = $start;
$eventsArray['to_time'] = $start;
    $eventsArray['url'] = "edit_calendar.php?calendarid=".$row['plan_id'];
    // $eventsArray['end'] = $end;
    // $eventsArray['allDay'] = false;
    $events[] = $eventsArray;
}


echo json_encode($events);