Search the Community
Showing results for tags 'php fullcalendar json array'.
Found 1 result
-
<link rel="stylesheet" type="text/css" media="all" href="css/fullcalendar.css"> <script type="text/javascript" src="js/jquery.1.7.2.js"></script> <script type="text/javascript" src="js/fullcalendar.js"></script> <script type="text/javascript" src="js/fullcalendar.min.js"></script> <script type="text/javascript"> $(document).ready(function() { var date = new Date(); var d = date.getDate(); var m = date.getMonth(); var y = date.getFullYear(); $('#calendar').fullCalendar( { header: { left: 'prev,next today', center: 'title', right: 'month,basicWeek,basicDay' }, editable :true, events: "http://localhost/EMS2/home.php", }); }) </script> <body> <div id="calendar"></div> </body> <?php require "connection.php"; $query = "select * from event "; $res = mysql_query($query) or die(mysql_error()); $events = array(); while ($row = mysql_fetch_assoc($res)) { $start = $row['start']; $end = $row['end']; $title = $row['event_name']; $eventsArray['title'] = $title; $eventsArray['start'] = $start; $eventsArray['end'] = $end; $events[] = $eventsArray; } echo json_encode($events); ?> im trying to get data from my database and display them into the fullcalendar but with no success. i tried with the coding above but at the top of my page [{"title":"Game of Thrones","start":"9\/5\/2014 8:30pm","end":"9\/5\/2014 12:30am","allDay":""}] and my calendar empty. any help is much appreciated.
