How to use HTML5/JavaScript resource calendar component to create a dynamic schedule. The calendar loads data (resources and events) using a REST API that is implemented using PHP and MySQL.
Feb 7, 2024
The PHP tutorials can help you with implementation of your own reservation or scheduling application with a PHP backend. Each tutorial includes a detailed explanation of the scheduling component configuration, UI layout and a REST backend implemented in PHP. You can also download the source code of the project and experiment with it on your machine. The project can serve as a starting point for your application or you can use it as a learning material to get a better idea about the component features and configuration options.
Some of the tutorials use plain JavaScript for the frontend implementation. This works well for simple applications without complex UI structure. It serves well for demonstration purposes because the tutorial can focus on the main logic and there is no boilerplate code.
For more advanced applications, the JavaScript code can become large and difficult to maintain. Many developers take advantage of one of the modern JavaScript frontend frameworks, such as Angular, React or Vue.
The scheduling projects use MySQL or SQLite as the backend database. The MySQL database initializes automatically if you first run the application. Just make sure sure that you configure your MySQL server connection details before you start the application. See _db.php file for database configuration settings. The tutorials also include dump of MySQL database schema (DDL script) that will give you an idea about the database layout.
In most tutorials, the PHP technology is limited to server-side implemented API. It’s not used to generate the client-side HTML - it only provides specific REST endpoints for database access. This lightweight approach lets you replace the backend easily with a different server-side technology, such as ASP.NET Core or Node.js. The tutorial text includes the API description, including the expected JSON response structure so you can use it as an example for implementation in other languages.
To get notified about new tutorials you can subscribe to e-mail notifications at news.daypilot.org.
A tutorial that shows how to create a PHP reservation system for hotel rooms with JavaScript/HTML5 frontend. The user interface includes a visual scheduling calendar with drag and drop support. MySQL and SQLite databases.
Dec 2, 2023
Weekly HTML5/JavaScript event calendar with CSS themes, drag and drop support, date navigator. Sample PHP and ASP.NET Core projects with REST backend implementation.
Nov 20, 2023
React application that lets you visually schedule shifts at multiple locations. The backend REST API is implemented using PHP and MySQL.
Jul 18, 2023
A tutorial that shows how to create a PHP shift planning system - a web application that lets you manage shifts for multiple locations using a visual JavaScript scheduler component.
Jun 4, 2023
HTML5/JavaScript event calendar with day, week, and month views and integrated date navigator. Includes a sample PHP backend with MySQL database.
Apr 4, 2023
Simple appointment scheduling application built using Angular. The calendar view is created using DayPilot Pro Angular Calendar component. The server-side backend is created using PHP and stores events in a MySQL or SQLite database.
Feb 15, 2022
This tutorial shows how to create a PHP application that will let users manage and schedule work orders using a visual interface implemented using JavaScript/HTML5.
Jan 10, 2022
Angular hotel room reservation application. The user interface supports managing rooms (create, edit, delete, change status) and reservations (create, edit, move, delete, change status). Includes a PHP/MySQL backend with token-based authentication.
Sep 16, 2021
How to enable on-demand event loading in the Vue Scheduler component. The Scheduler will load events for the current viewport. Additional data will be loaded during scrolling.
Aug 23, 2021
An Angular application that shows how to use DayPilot Scheduler with a PHP/MySQL backend.
Aug 23, 2021
Angular project that displays a Scheduler component with dynamic event data loading enabled. Event data are loaded on demand during scrolling to improve scalability.
Aug 3, 2021
PHP web application that allows to plan annual leave days using a visual HTML5 scheduler component.
Jun 18, 2021
This tutorial shows how to create a PHP web application for machine/production job scheduling. The visual HTML5 scheduling grid displays task assignments, duration and dependencies. Users can use drag and drop to change the schedule.
Jun 16, 2021
Drag and drop monthly event calendar for JavaScript/HTML5. Full calendar CSS styling support. Includes a sample PHP backend with SQL database.
Jun 16, 2021
Angular application that lets you manage restaurant table reservations. Includes a PHP/MySQL backend.
Jun 15, 2021
How to create a timesheet using the JavaScript/HTML5 timesheet component. Sample PHP/MySQL application source code for download.
Jun 11, 2021
HTML5/JavaScript Gantt chart control that lets you display a timeline for a hierarchy of tasks and milestones. Task dependencies, drag and drop support, inline task creating, custom CSS themes. Sample PHP/MySQL project available for download.
Jun 10, 2021
Simple web application that displays tennis court availability and lets the users create a reservation using drag and drop. Includes a PHP project with sample MySQL/SQLite database.
Jun 8, 2021
React application that will let you assign queued work orders to a specific employee and time slot. Includes a PHP backend with MySQL storage.
May 23, 2021
Articles 1-20 of 34
Next