jquery - fullcalendar adding events from mysql json - adding eventClick returns blank page -
i pulling events calendar using json , php. know trying add evenclicks or mouseover events the calendar , when blank page. js knowledge rather novice @ point i'm stuck
heres calendar script $(document).ready(function() {
$('#calendar').fullcalendar({ header: { left: 'prev,next today', center: 'title', right: 'month,basicweek,basicday' }, editable: false, events: "json-events.php", loading: function(bool) { if (bool) $('#loading').show(); else $('#loading').hide(); } }); });
pretty basic, , heres json
mysql_select_db($databasedb, $connectitdb); $sql= "select id, title, description, url, email, stime, etime, eventdate, date_format(eventdate, '%y-%m-%dt%h:%i' ) startdate events order startdate desc"; $check = mysql_db_query($databasedb, $sql, $connectitdb) or die(mysql_error()); $events = array(); while ($row = mysql_fetch_assoc($check)) { $eventarray['id'] = $row['id']; $eventarray['description'] = $row['description']; $eventarray['url'] = $row['url']; $eventarray['email'] = $row['email']; $eventarray['starttime'] = $row['stime']; $eventarray['endtime'] = $row['etime']; $eventarray['title'] = $row['stime'] . " " . $row['title']; $eventarray['start'] = $row['startdate']; $eventsarray['allday'] = ""; $events[] = $eventarray; } echo json_encode($events);
i'm sure has i'm adding events, info might tighten code main focus being able use eventclick
thanks in advance craig
probably this:
mysql_db_query
should be:
mysql_query
making this:
$check = mysql_query($sql) or die(mysql_error());
make sure put these lines on top of script see if there errors coming up:
ini_set('display_errors', true); error_reporting(e_all);
Comments
Post a Comment