How can PHP be used to fill a graph with data from a MySQL database?

To fill a graph with data from a MySQL database using PHP, you can query the database to retrieve the necessary data and then format it in a way that can be easily consumed by a graphing library such as Chart.js or Google Charts. Once you have the data formatted correctly, you can pass it to the graphing library to render the graph on your webpage. 

<?php
// Connect to MySQL database
$connection = mysqli_connect("localhost", "username", "password", "database");

// Check connection
if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// Query to retrieve data from database
$query = "SELECT * FROM your_table";
$result = mysqli_query($connection, $query);

// Format data for graph
$data = array();
while ($row = mysqli_fetch_assoc($result)) {
    $data[] = array(
        'label' => $row['label'],
        'value' => $row['value']
    );
}

// Close connection
mysqli_close($connection);

// Pass data to graphing library to render graph
echo "<script>
    var data = " . json_encode($data) . ";
    // Code to render graph using data
</script>";
?>

Keywords

PHP MySQL graph data database

Related Questions