Home Forums Chart Support PHP MySQL Dynamic data

PHP MySQL Dynamic data

Viewing 1 post (of 1 total)
  • #5602

    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
    (SELECT user.id_unit,
    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 );

    <!DOCTYPE html>
    <html xmlns=”http://www.w3.org/1999/xhtml&#8221; >
    <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;?>]



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


    Please given me advice.. thanks

Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.