Home forums Report Bugs Cant Generate charts using database data

This topic contains 1 reply, has 2 voices, and was last updated by  Anjali 1 year, 4 months ago.

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #9171

    Nimal
    Member

    `<?php
    $servername = “localhost”;
    $username = “root”;
    $password = “”;
    $dbname = “assignment2”;
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
    die(“Connection failed: ” . $conn->connect_error);
    }
    //header(‘Content-Type: application/json’);

    // Check connection
    $data_points = array();

    $sql = “SELECT * FROM power1 sales”;

    $result = mysqli_query($conn,$sql);
    if (!$result) {
    echo ‘MySQL Error: ‘ . mysqli_error($conn);

    }
    ;

    while($row = mysqli_fetch_array($result))
    {
    $point = array(“label” => $row[‘product’] , “y” => $row[‘total_sales’]);

    array_push($data_points, $point);
    }

    echo json_encode($data_points, JSON_NUMERIC_CHECK);

    mysqli_close($con);

    ?>
    ————————————————————————–

    <!DOCTYPE html>
    <html >
    <head>

    <title>Untitled Document</title>
    <script type=”text/javascript” src=”canvasjs.min.js”></script>
    <script src=”source/jquery.js”></script>
    <script type=”text/javascript” src=”source/canvasjs.js”></script>

    <script type=”text/javascript”>
    $(document).(function () {

    $.getJSON(“data.php”, function (result) {

    var chart = new CanvasJS.Chart(“chartContainer”, {
    data: [
    {

    dataPoints: result
    }
    ]
    });

    chart.render();
    });
    });
    </script>
    </head>

    <body>
    <title></title>

    </body>
    </html>

    #9180

    Anjali
    Participant

    nimal,

    Your question has been answered in this thread.

    __
    Anjali

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.