Skip to content

Integrating a JavaScript Scheduler with PHP and MySQL for Dynamic CRUD Operations

Notifications You must be signed in to change notification settings

SyncfusionExamples/Javascript-Scheduler-CRUD-PHP-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

21 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

How to integrate MySQL with Syncfusion Scheduler Application using PHP.

This repository contains a sample full-stack application demonstrating how to synchronize events between MySQL and the Syncfusion Scheduler component using PHP.

Prerequisites

Setup

Cloning the Repository

  • Clone the repository to your local machine:

MySQL Configuration

  • Create Username , Password and DataBase in MySQL
  • In server.php file update the username, password, and dbname as per the database configuration.
  • The SQL query required for creating the necessary table is being located in the scheduledb.sql file within the DB folder.
  • In your Database it automatically create a table with the necessary fields

Start Xampp Server

  • After the successful installation of the XAMPP server, launch the application and start the Apache server.
  • Move the Javascript-Scheduler-CRUD-PHP-MySQL repository files in the XAMPP server's root directory, specifically at C:\xampp\htdocs.
  • Upon completion, Launch a web browser and navigate to localhost, you will be able to see the server running.
  • Next, Navigate to localhost/Javascript-Scheduler-CRUD-PHP-MySQL in your web browser. You will now be able to access the running Syncfusion scheduler application.
  • Now, you can perform the CRUD operations it will be reflected on MySQL Database.

Running the application

  1. Start XAMPP services
  • Open XAMPP Control Panel
  • Start Apache
  1. Place project files
  • Copy the project folder Javascript-Scheduler-CRUD-PHP-MySQL into:
    C:\xampp\htdocs\
    
  1. Open in browser
  • Go to: http://localhost/

  • Then open the app:

    http://localhost/Javascript-Scheduler-CRUD-PHP-MySQL
    
  1. You can perform CRUD operation on the scheduler that will be reflected in the MySQL database table.

Output Preview

Frontend Preview Image illustrating the Syncfusion Scheduler Component

Database Preview Image illustrating the events of Syncfusion Scheduler in MySQL

Troubleshooting

  • Page Not Found:Check the file path correctly in the browser search bar
  • Apache Server port stopped in XAMPPSERVER: Change the Port no in config file and mentioned the port no in url and crudurl in index.php.
  • Refused to Connect with server: Check the url and crudurl in index.php.

About

Integrating a JavaScript Scheduler with PHP and MySQL for Dynamic CRUD Operations

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages