My code is work fine in add new event to sql database .
but Not display the event stored in sql inside the calendar.
I WANT TO DISPLAY THE EVENT INSIDE THE CALENDAR
JS
JavaScript
x
$(document).ready(function() {
var myCalendar = $('#calendar').fullCalendar({
events: "<?php echo base_url('Shedule/getCalender/')?>",
type: 'GET',
defaultDate: '2018-09-28',
selectable: true,
selectHelper: true,
select: function(start, end) {
var title = prompt('Event Title:');
if (title) {
var eventData = {
title: title,
start: start.format(),
end: end.format()
};
$.ajax({
url: "<?php echo base_url('Shedule/addToCalendar/')?>",
type: 'POST',
data: eventData,
success: function(result) {
myCalendar.fullCalendar('refetchEvents');
},
Controller
JavaScript
function getCalender ()
{
$events=$this->Shedule_model->getCalender();
echo json_encode($events);
Model
JavaScript
function getCalender ()
{
$this->db->select("*");
$this->db->from("tbl_schedule");
$query = $this->db->get();
return $query->result();
}
Advertisement
Answer
I SOLVED MY PROBLEM BY MY SELF
MODEL
JavaScript
$this->db->select("`startdate` AS `start`, `enddate` AS `end`, `visittype AS `title`");
$this->db->from("tbl_schedule");
$query = $this->db->get();
return $query->result();
AJAX – ADD EVENT – DISPLAY EVENT – REFRESH CALENDAR
JavaScript
$(document).ready(function() {
refresh_calendar();
});
function refresh_calendar() {
var myCalendar = $('#calendar').fullCalendar({
header: {
left: 'prev,next today',
center: 'title',
right: 'month,agendaWeek,agendaDay'
},
events: "<?php echo base_url('Shedule/getCalender/')?>",
type: 'GET',
defaultDate: '2018-09-28',
selectable: true,
selectHelper: true,
success: function(result){
$('#calendar').fullCalendar(result);
}
select: function(start, end) {
var title = prompt('Event Title:');
if (title) {
var eventData = {
title: title,
start: start.format(),
end: end.format()
};
$.ajax({
url: "<?php echo base_url('Shedule/test/')?>",
type: 'POST',
data: eventData,
success: function(result) {
myCalendar.fullCalendar('refetchEvents');
},
error: function(xhr, status, msg) {
alert(msg);
}
});
}
}
});
}