How to Parse Dates from PHP MYSQL Database to Javascript to Chart JS

How to Parse Dates from PHP MYSQL Database to Javascript to Chart JS

In this video we will cover how to parse dates from PHP MYSQL to Javascript to Chart js. This is a more advanced topic and requires multiple skills. We will need a localhost or server as we are connecting to a database.

What we will do is build the connection and extract the values from the database into an array in PHP. From PHP we can make it JSON readable by encoding it. This will make the information understood by Javascript. From there on we will convert that into proper dates in Javascript so Chart js can read it.

Let's explore this right now!

▬ Chartjs Viewers Question Series ▬▬▬▬▬▬▬▬▬▬

▬ Materials/References ▬▬▬▬▬▬▬▬▬▬

To keep the video short we might expect you to know parts. These parts we have explained in other videos. You can find the references here below:

▬ Got a Question? Comment! ▬▬▬▬▬▬▬▬▬▬

Got a question or special request about a specific item? Comment below and tell me your question. I will make sure to follow up on you!

▬ Find Me Here ▬▬▬▬▬▬▬▬▬▬

Chart JS tutorials for Beginners:

Chart JS tutorials for Intermediate:

Chart JS Dashboard Series:
👍 Most Liked Video Series:

▬ About Us ▬▬▬▬▬▬▬▬▬▬▬▬

Why we created these #chartjs and #javascript video tutorials?

WHY
Creating charts in javascript is very rewarding but extremely challenging. The Chart JS library made it easier to render charts. However the chart js documentation is hard to understand for many. It requires a lot of different moving parts to work along. The canvas tag, javascript, arrays and Chart JS all need to be combined to draw an eye catching bar chart or line chart.

The videos explains the chart js documentation in a more visual and easy to understand way. You can follow along with the code and quickly grasp how it works. We cover the code in chart js but also what truly happens and why something happens when we write a line of code. This fundamental understanding gives clarity to you as a developer in chartjs. In short it is the Chart JS video documentation.

HOW
We answer questions from YOU (viewers) by creating an answer video that covers the questions YOU have posted in the comment section.

WHAT
Our goal is to help YOU learn how to draw charts in Chart JS by showing you in video format how to do it.

▬ Chart JS 3.6.0 ▬▬▬▬▬▬▬▬▬▬▬▬

Chart JS is a javascript library to draw charts in the canvas tag on your site. Presenting data in a visual manner such as charts is more effective and appealing. All the charts are always coded in the latest Chartjs version which is as of this recording Chart JS 3.6.0.

What type of charts can you make with Chart.JS?
With chart js you can make line chart, bar chart, pie chart, doughnut chart, scatter chart, polar area chart, radar chart, gauge chart and area chart. And with some clever tricks and visual adjustment more can be done.

[oludedavid]

Hello sir, I have a question: I am working with flask-sqlalchemy and mysql database, I have four different date object I got from the query
a) x:"Tue, 02 Mar 2022 10:21:19 GMT" for day;
b) x:3 for month;
c) x: 9 for week;
d) x:2022 for year,
this are the format in which they appear in javascript after fetching the data and converting to JSON from the database query in flaskalchemy. I have tried to parse this in chart.js but seems impossible or is there something am missing? is it possible to tell chart.js that the integer is march like representing 3 or there is more before that can happen

[abdulsamadmuyideen]

please how can i count number of male and female in database help please with a video or any resources thanks

[louietapao]

is it possible to add a date range picker on this tutorial like this video: