CODEWITHSUNDEEP
javascriptphplaravelfullcalendar
Dorian Daval
Dorian Daval

Reputation: 33

FullCalendar get events from database

Hi i am using FullCalendar in a laravel project and i need to display the events from the database.

I get all the events from the database and display them using json_encode.

There is the code i use :

My controller :


<?php

namespace App\Http\Controllers;
use App\Http\Gestionnaires\EventGestionnaire;
use Illuminate\Http\Request;

class EventController extends Controller
{
    public function afficher(){

        $eventGestionnaire = new EventGestionnaire;
        $listeEvents = $eventGestionnaire->getListeEvents();

        echo json_encode($listeEvents);


        return view('pages.calendar');

    }
}

And my script :


$calendar.fullCalendar({

    viewRender: function(view, element) {
        if (view.name != 'month'){

            $(element).find('.fc-scroller').perfectScrollbar();

        }
    },

    resourceEditable: true,
    eventLimit: true,
    editable: true,
    selectable: true,
    selectHelper: true,
    header: {
        left: 'month,agendaWeek,agendaDay',
        center: 'title',
        right: 'prev,next,today'
    },

    events: 'EventController.php',

The error :

jquery.min.js:3049 GET http://localhost/planner/public/EventController.php?start=2019-09-01&end=2019-10-13&_=1568831263931 404 (Not Found)

Upvotes: 3

Views: 2800

Answers (2)

latr.88
latr.88

Reputation: 859

I used it in the past, and using the same structure for the javascript side of it as previous answer shows. Once created your route to access it, see php code for responding to your ajax request:

    $results = [];

    foreach($calendar_events as $calendar_event)
    {
        $ev = [];
        $ev["title"] = $calendar_event->name;
        $ev["color"] = $calendar_event->calendar->color ?? "f47d30";

        $ev["start"] = Carbon::parse($calendar_event->start)->format("Y-m-d");
        $ev["end"]   = Carbon::parse($calendar_event->end)->format("Y-m-d");

        if (!$calendar_event->is_allday)
        {
            $ev["start"]  = Carbon::parse($calendar_event->start."T".$calendar_event->start_time)->format("Y-m-d\TH:i:s");
            $ev["end"]    = Carbon::parse($calendar_event->end."T".$calendar_event->end_time)->format("Y-m-d\TH:i:s");
            $ev["allDay"] = false;
        }

        if (!empty($calendar_event->url))
        {
            $ev["url"] = $calendar_event->url;
        }

        $results[] = $ev;
    }

    return response($results);

Upvotes: 2

user11897373
user11897373

Reputation:

From FullCallendar V3 DOCS to pass URL with JSON response use

$('#calendar').fullCalendar({

  eventSources: [

    // your event source
    {
      url: '/myfeed.php', // use the `url` property
      color: 'yellow',    // an option!
      textColor: 'black'  // an option!
    }

    // any other sources...

  ]

});

Upvotes: 0

Related Questions