dougua3705 2018-10-25 11:12
浏览 61

饼图基于复选框数组

Hi i have a project where am making pie chart in my dashboard.the problem am facing is that i have one column that accepts multiple checkbox value.

I have attached an image on how it appears Pie chart So i was asking if somebody would help me so the values can be presented individually not as group.` This is my source code

include("fusioncharts.php");
$hostdb = "localhost";  // MySQl host
$userdb = "root";  // MySQL username
$passdb = "";  // MySQL password
$namedb = "school";  // MySQL database name

$dbhandle = new mysqli($hostdb, $userdb, $passdb, $namedb);
if ($dbhandle->connect_error) {
    exit("There was an error with your connection: ".$dbhandle->connect_error);
}

$strQuery = "SELECT combination, COUNT(combination) FROM schools GROUP BY  combination order by COUNT(combination)";
$result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");

if ($result) {
    $arrData = array(
        "chart" => array(
            "caption" => "Numbers of Schools Based on Different Combination",
            "theme" => "fusion",
            "caption" => "",
            "showPercentInTooltip" => "0",
            "enableMultiSlicing" =>"1",
        )
    );
    $data = array();
    $arrData["data"] = array();
    while($row = mysqli_fetch_array($result)) {
        array_push($arrData["data"], array(
                "label" =>$row["combination"] ,
                "value" =>  $row["COUNT(combination)"]
            )
        );
    }

    $jsonEncodedData = json_encode($arrData);

    $columnChart = new FusionCharts("pie3D", "myFirstChart" , 900, 500, "chart-1", "json", $jsonEncodedData);
    $columnChart->render();
    $dbhandle->close();
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么
    • ¥15 banner广告展示设置多少时间不怎么会消耗用户价值
    • ¥16 mybatis的代理对象无法通过@Autowired装填
    • ¥15 可见光定位matlab仿真
    • ¥15 arduino 四自由度机械臂
    • ¥15 wordpress 产品图片 GIF 没法显示
    • ¥15 求三国群英传pl国战时间的修改方法
    • ¥15 matlab代码代写,需写出详细代码,代价私
    • ¥15 ROS系统搭建请教(跨境电商用途)
    • ¥15 AIC3204的示例代码有吗,想用AIC3204测量血氧,找不到相关的代码。