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

The Pros and Cons of Using Front-End Frameworks for Web Development

Web development has, for a while, been a breeze with the range of frameworks and tools available to create great projects with minimal effort. A front-end framework can be considered a toolbox filled with all kinds of valuable tools that developers can use to create a website or application quickly and efficiently. 

Like a carpenter needs his hammer and saw, a web developer needs their front-end framework to build a unique website or application. But much like any tool, both pros and cons are associated with using front-end frameworks for web development. 

This article will explore the benefits and drawbacks of using a front-end framework for your project. Let’s start by opening up this “toolbox” and looking at the pros and cons of using front-end frameworks for web development.

The Pros and Cons of Using Front-End Frameworks for Web Development

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