Dynamic data load on Column Chart using PHP and Google Chart API

Column charts are one of the most common and widely used chart types. It is a visual representation of data that uses bars to show the values of different categories.

Google charts API allows to create different types of charts like – pie, bar, line, column, etc. It takes Array type value as data.

In this tutorial, I show how you can create column chart using Google Chart API and load MySQL data dynamically using PHP with a live example.

Dynamic data load on Column Chart using PHP and Google Chart API

Read more

How to Create a PHP Event Calendar with FullCalendar JS Library

Event calendars are a powerful tool that keeps track of upcoming events, schedules, appointments, and deadlines.

I am using FullCalendar plugin to create a calendar layout and make it dynamic using PHP and MySQL. Plugin is not dependent on any library, responsive, and automatically fits on the page. Different types of options and events are available to customize and control it.

In this tutorial, I show how you can create an event, update and delete an existing event, and load events in the FullCalendar JavaScript library using PHP AJAX and MySQL.

I am using FullCalendar v6 in the example and sweetAlert library to display an alert box to add/edit events.

How to Create a PHP Event Calendar with FullCalendar JS Library

Read more

How to Add Select2 in CakePHP 4 and Load data using jQuery AJAX

Select2 is a popular jQuery plugin that makes the default HTML select element to lot more funtional. With <select > element it is not possible to search on the list and add an image to an option, customize the UI.

Select2 allows the loading of data dynamically from the server using AJAX when the user clicked on an element or search.

In this tutorial, I show how you can add select2 in CakePHP 4 and load data dynamically from the MySQL database using jQuery AJAX.

How to add Select2 in CakePHP 4 and Load data using jQuery AJAX

Read more

How to Add jQuery UI Autocomplete with AJAX in CakePHP 4

jQuery UI library provided different types of user interface widgets that are easy to implement on the page. One of the powerful widget is autocomplete.

It displays the suggestion list while typing in the input box. You can preload its data on the client side while initialization or load it dynamically using AJAX.

In this tutorial, I show how you can add jQuery UI Autocomplete in CakePHP 4 and load MySQL database data using jQuery AJAX.

How to Add jQuery UI Autocomplete with AJAX in CakePHP 4

Read more