2 Adding the PHP Code in HTML File | Chartjs Mysql Database Series

2 Adding the PHP Code in HTML File | Chartjs Mysql Database Series

In this video we will explore how to connect add the final part of PHP code to connect the chart js with a mysql database. In the first 2 videos we cover the standard parts of creating a database connection. Which is the foundation of getting the mysql database to work before we can connect it. We will be using a localhost and work with a mysql database and PHP.

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!

Interested to learn about how to create charts? Check out below!

⭐ Chart JS Udemy Course ⭐:

Chart JS tutorials for Beginners:

Chart JS tutorials for Intermediate:

Chart JS Dashboard Series:
👍 Most Liked Video Series:

Why did I created these Chart JS video tutorials?
Have you ever used Excel where charts appear almost magically with a click on a button. You notice if you look at a chart or graph you can absorb information within seconds which would take you minutes if it is a table with data.

"A picture is worth a thousand words"

We all know that pictures and colors spark the mind. However, if you try to draw or code a 📊 bar chart or a 📈 line chart, or any type of chart in a Javascript library it is a big challenge. The documentation makes it hard and the it is very hard to work with a canvas tag.

Which was both logical and creative at the same time. And this is why I love charts as well. A chart is the closes to translating logic into visuals. Making the chart interactive is the best way to communicate your message to others.

If we know about this why is coding charts so complicated?

Because computer programming language is based on 100% logic. This is why when you look at Chart.JS, D3.JS, Chartist and other chart libraries in JS you will need to basically explain in logic to a computer what to make visual.

How and where can I help?

My goal and focus is on creating easy to understand Chart.JS videos so you can start using Chart JS in all your website endeavors making Chart.JS a topnotch and leading JS library for the years to come. Just like any programming library once more people use Chart JS it will attract more people to contribute and grow. The videos on Youtube and my complete course on Udemy are here to give a helping hand.

Seeing Chart.JS evolve from Chart.JS 1.0 to Chart.JS 3.0 and with their currently new expansion to Chart.JS 3.0 we can expect more new exciting charts in the near future.

About Chart.JS 3 | Chart JS 3
Chart JS is one of the most use Javascript libraries for the drawing charts. It is designed to create charts in the canvas tag which is great but at the same time slightly challenging for most people. However, knowing how to draw a chart will give you a big edge and most dashboards are consistently adding charts along data tables. Chart JS makes your data more alive and visually more appealing.

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.

#chartjs

[ChartJS-tutorials]

If you want to copy the code see here the code:

<?php
// Attempt select query execution
try{
$sql = "SELECT * FROM chartjs.barchart";
$result = $pdo->query($sql);
if($result->rowCount() > 0) {
while($row = $result->fetch()) {
}

unset($result);
} else {
echo "No records matching your query were found.";
}
} catch(PDOException $e){
die("ERROR: Could not able to execute $sql. " . $e->getMessage());
}

// Close connection
unset($pdo);
?>

[abdulsamadmuyideen]

You have my utmost respect 👏🏾my client will be so thrilled when am done

[ChrisMario]

Great video series! I'm re-watching to tag-along, and I noticed you said something about having to either specify the database and table or just the table; I think this is because you specified database in your connection string, thus, you also need to include it in your "SELECT * FROM chartjs.barchart" - If your connection string didn't have a database set, having only "FROM barchart" would be sufficient. Alteast that worked for me, both ways. Don't ask me why, it's weird :b

[atan-widar]

Please make tutorial radar type Chartjs Mysql Database Series..Thanks

[Lukas-ixps]

Thanks you. This was very helpful for me. But how i can put a second sql query, so that a query can be made for the second bar?

[pramodsawant]

How connect date picker to chart for update chart