FORUMS

Select any forum below to ask question

Home › Forums › Chart Support › PHP MySQL Dynamic data

PHP MySQL Dynamic data

Viewing 1 post (of 1 total)
  • January 8, 2014 at 1:30 pm #5602

    pentul

    give me advice for scritps no run json..
    this my Code PHP:
    <?
    $data_points = array();
    $query = “SELECT id_unit, name_unit,
    MAX(CASE WHEN STAT = ’employee’ THEN total ELSE NULL END) employee,
    MAX(CASE WHEN STAT = ‘Non_employee’ THEN total ELSE NULL END) Non_employe
    FROM
    (SELECT user.id_unit,
    unit_work.name_unit,
    status_peg.STAT,
    COUNT(user.id_employe) total
    FROM user
    INNER JOIN unit_work ON user.id_unit = unit_work.id_unit
    INNER JOIN stat ON user.id_stat = stat.id_stat
    GROUP BY unit_work.name_unit, user.id_stat
    order by user.id_unit_work, user.id_stat) aa
    GROUP BY name_unit
    order by id_unit_work”;
    $result = mysql_query($query);

    while($row = mysql_fetch_array($result)){

    $point = array(“label” => $row[‘name_unit’] , “y” => $row[’employee’]);
    array_push($data_points,$point );

    }
    ?>
    ==========================
    HTML:
    <!DOCTYPE html>
    <html xmlns=”http://www.w3.org/1999/xhtml&#8221; >
    <head>
    <title></title>
    <script src=”jquery.js”></script>
    <script src=”canvasjs.js”></script>

    <script type=”text/javascript”>
    window.onload = function () {
    var chartemploye = new CanvasJS.Chart(“Container”, {
    data: [
    {
    type: “bar”,
    name: “employee”,
    showInLegend: true,
    dataPoints: [<?=$data_points;?>]
    }
    ]
    });

    chartemploye.render();

    }
    </script>
    </head>
    <body>

    <div id=”Container” style=”width: 100%; height: 380px;”></div>

    </body>
    </html>

    Please given me advice.. thanks

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.