NOTE: I will no longer be supporting this repository. FullCalendar's newest API contains significant improvements over version 3 including better recurrence capabilities to wire into your backend.

FullCalendar-BS4-PHP-MySQL-JSON

A drag & drop event calendar with data permanence.

Purpose

MySQL/JSON integration with FullCalendar and event recurrence capabilities.

Features

Repeating events (NEW!)
- Supports weekly recurrences
- Supports regular, all-day, and multi-day events
- Supports recurrence editing - deletion only
- Available for JSON
Event scheduling
- JSON scheduling added
FC updated from v2.6.1 to v3.9.0
BS3 to BS4 update
Event title/description hover added
Added description field

Getting Started

MySQL

Copy files to localhost
Create a table in DB called calendar, and create the tables found in calendar.sql
Open auth.php and enter your DB credentials
Open index.php from browser

JSON

Copy files to localhost
Open index-json.php from browser

Note: If event editing not "sticking" on refresh, verify file permissions are sufficient. ls -l

Event Structure

JSON Object Event

[{"id":4,
  "rid":4,
  "eventType":"single event",
  "title":"Meeting",
  "description":"some text for meeting",
  "start":"2019-01-11 10:30:00",
  "end":"2019-01-11 12:30:00",
  "color":"#000"
}]

MySQL Event Schema

('id', 'title', 'description', 'color', 'start', 'end')
(5, 'Meeting', 'some text for meeting', '#000', '2019-01-11 10:30:00', '2019-01-11 12:30:00')

Additional Readings & Resources

FullCalendar documentation: https://fullcalendar.io/docs#toc
FullCalendar repo: https://github.com/fullcalendar/fullcalendar
FullCalendar with MySQL event scheduling: https://github.com/jamelbaz/FullCalendar-BS3-PHP-MySQL

Built With

FC v3.9.0
BS4
PHP 5/7
MySQL/JSON
JavaScript/jQuery
HTML/CSS

Contributing

Submit a PR and I'll review. Look for untagged/unassigned issues to help with.

Versioning

Version 1.2.0

Authors

Matthew Waldron - (http://waldronmatthew.com)
FullCalendar - (https://fullcalendar.io)
jamelbaz https://github.com/jamelbaz/FullCalendar-BS3-PHP-MySQL

License

This project is licensed under the MIT License - see the LICENSE.md file for details.

Acknowledgments

Repo built on Adam Shaw's FC: https://github.com/fullcalendar/fullcalendar
Repo forked from jamelbaz's repository: https://github.com/jamelbaz/FullCalendar-BS3-PHP-MySQL

waldronmatt/FullCalendar-BS4-PHP-MySQL-JSON