Today, We want to share with you how to create bar chart in php and mysql.In this post we will show you PHP Chart Data from Database, hear for Creating a Bar Chart using mySQL in PHP we will give you demo and example for implement.In this post, we will learn about how to create bar chart in php and mysql? with an example.

Php Google Bar Chart Tutorial

Contents

Step 1 : Create Table

CREATE TABLE `products` (
  `id` int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
  `name` varchar(70) NOT NULL,
  `number` int(11) NOT NULL,
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=latin1

Step 2 : Configuration

config.php

<?php

    $host = "localhost"; 
    $user = "jdksjjs";
    $password = "[email protected]"; 
    $dbname = "pakainfo";

    $con = mysqli_connect($host, $user, $password,$dbname);

    if (!$con) {
     die("Connection failed: " . mysqli_connect_error());
    }

    $chartQuery = "SELECT * FROM products";
    $chartQueryRecords = mysqli_query($con,$chartQuery);
?>

Step 3 : HTML & PHP Code

index.php

<?php
    include "config.php";
?>
<html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    
  <body style="text-align: center;">
    <h2 class="text-center">Generate Bar Chart in PHP</h2>

    <div id="regions_div" style="width: 900px; height: 500px;"></div>

    <div class="text-center">
        <h2>www.pakainfo.com</h2>
    </div>
    <script type="text/javascript">
      google.charts.load('current', {
        'packages':['imagebarchart'],
        'mapsApiKey': 'Ldfdioko-8dfuDkjdf85d5fdfdff8-a7eZSW0jkLKFIO'
      });
      google.charts.setOnLoadCallback(drawRegionsMap);

      function drawRegionsMap() {
        var data = google.visualization.arrayToDataTable([
             ['Year', 'Sales', 'Expenses'],
            <?php
                while($row = mysqli_fetch_assoc($chartQueryRecords)){
                    echo "['".$row['year']."',".$row['sales'].",".$row['expenses']."],";
                }
            ?>
        ]);

        var options = {
        };

        var chart = new google.visualization.ImageBarChart(document.getElementById('regions_div'));

        chart.draw(data, options);
      }
    </script>
  </head>
  </body>
</html>

How to Create a Bar Graph using PHP/MySQLi and ChartJS?

To create a bar graph using PHP/MySQLi and ChartJS, you can follow these steps:

Create a database table to store the data for your bar graph. The table should have columns for the label and value of each data point.

Populate the database table with some sample data.

Create a PHP script that queries the database to retrieve the data for the bar graph.

// Connect to the database
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// Query the database to retrieve the data for the bar graph
$result = mysqli_query($conn, "SELECT label, value FROM bar_graph_data");

// Create an array to store the label and value of each data point
$data = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = $row;
}

Include the ChartJS library in your HTML file.

<script src="https://cdn.jsdelivr.net/npm/chart.js"></script>

Create a canvas element to display the bar graph.

<canvas id="barChart"></canvas>

Create a JavaScript block that retrieves the data from your PHP script and creates the bar graph using ChartJS.

// Retrieve the data for the bar graph from the PHP script
$.ajax({
    url: "bar_graph_data.php",
    method: "GET",
    success: function(data) {
        var labels = [];
        var values = [];

        // Parse the data returned by the PHP script
        data = JSON.parse(data);
        data.forEach(function(item) {
            labels.push(item.label);
            values.push(item.value);
        });

        // Create a new bar chart using ChartJS
        var ctx = document.getElementById("barChart");
        var myChart = new Chart(ctx, {
            type: 'bar',
            data: {
                labels: labels,
                datasets: [{
                    label: 'Bar Graph',
                    data: values,
                    backgroundColor: 'rgba(255, 99, 132, 0.2)',
                    borderColor: 'rgba(255, 99, 132, 1)',
                    borderWidth: 1
                }]
            },
            options: {
                scales: {
                    yAxes: [{
                        ticks: {
                            beginAtZero: true
                        }
                    }]
                }
            }
        });
    }
});

In this JavaScript block, we use jQuery’s $.ajax() method to retrieve the data for the bar graph from our PHP script. We then parse the data using JSON.parse() and use the resulting arrays to create a new bar chart using ChartJS. The options for the chart, such as the chart type, data, and colors, are specified in the myChart object.

Also Read This 👉 Bootstrap Toggle switch with ajax update to mysql in Laravel

Once you have completed these steps, you should be able to see your bar graph on your webpage.

I hope you get an idea about How to Create a Bar Graph in PHP/MySQLi.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Php Google Bar Chart Tutorial

Step 2 : Configuration

Step 3 : HTML & PHP Code

How to Create a Bar Graph using PHP/MySQLi and ChartJS?

Related posts: