nadiam Posted April 22, 2014 Share Posted April 22, 2014 <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. Quote Link to comment https://forums.phpfreaks.com/topic/287928-fetch-data-from-database-and-display-in-fullcalendar/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.