Code Monkey home page Code Monkey logo

fullcalendar-bs4-php-mysql-json's Introduction

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.

FullCalendar 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

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

JSON

  1. Copy files to localhost
  2. 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

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

License

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

Acknowledgments

fullcalendar-bs4-php-mysql-json's People

Contributors

inside-shellshock avatar waldronmatt avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

fullcalendar-bs4-php-mysql-json's Issues

Kinda new with this thing.

I just want to ask if how it is possible to make the time and date be picked by the user in separate fields ? Thank you.

SQL queries

I have been using this code for my project and it's been suggested that the code would be more secure if PDO or MYSQLi where used, as the existing SQL library will be depreciated at some point in the future!

Enhancement Idea

Hi,
Awesome project! As a novice coder I doubt I can help however if you have anything simple give me a shout!

I have a suggestion:
An event could be checkboxed for 'schedule later', on the calendar those unscheduled events would populate a list that can be dragged onto the calendar. I found a demo below.

https://fullcalendar.io/docs/external-dragging-demo

Monthly List View Rendering "aru6" instead of day dates

When enabling the Day labels in list view, for some reason instead of displaying the date of the day for each group of events, the link text is being rendered as the string "aru6" instead of the date numbers. The day label correctly shows the day name (saturday in the screenshot below). It looks like the actual link destination even goes to the correct date as shown in the code screenshot, but the actual text of the link always just says "aru6" no matter what the date is.

This is a weird bug that i couldn't find any fullcalendar documentation on, so i'm not sure if it's just specific to this build or fullcalendar in general.

aru6-bug

Monthly Recurrence Deletes all JSON Events (JSON Build)

I noticed in the index-json.php file the monthly recurrence option was commented out. I uncommented it because this is a feature i actually wanted, but when i tried to set a monthly event it deleted all the other events. I'm guessing this is why it was commented out, but is there any way to fix this? It would actually be a very useful feature, much more than the weekly recurrence.

If it doesn't work in the JSON build, would it by chance work in the SQL build? I tried the SQL version first but even though i set up all the database connections correctly it would redirect to a blank page upon event creation, so we went with the JSON build instead.

cant change date/time for entries

Hi,

I've followed your readme and it appears i cannot edit the date/time for any entry. is this something i've missed or is it a bug?

not sure i'm running xampp on a windows 10 machine but all files have read write.

Localisation

I can't do localisation as it is done in fullcalendar.io. Is ths supported in this version, which I realy like. I tried to get the localisation file from fullcalendar.io and put it into the indes.php file like
$('#calendar').fullCalendar({

		  var de = {
				    code: 'de',
				    week: {
				      dow: 1, // Monday is the first day of the week.
				      doy: 4, // The week that contains Jan 4th is the first week of the year.
				    },
				    buttonText: {
				      prev: 'Zurück',
				      next: 'Vor',
				      today: 'Heute',
				      year: 'Jahr',
				      month: 'Monat',
				      week: 'Woche',
				      day: 'Tag',
				      list: 'Terminübersicht',
				    },
				    weekText: 'KW',
				    allDayText: 'Ganztägig',
				    moreLinkText(n) {
				      return '+ weitere ' + n
				    },
				    noEventsText: 'Keine Ereignisse anzuzeigen',
				  };
	  
		locale: de;

but it did't work.

Is this supported at all?

Thanks

Recurring events

It would be nice if recurring events could be added to the calendar!

I know this is done slightly differently with V4.x!

Edit event from mobile

Hi!
I've tried to edit an event from mobile (iPhone XS Max iOS 12) but it does not work!
Can you help me?
Thank you in advance!

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.