doushuzd3033 2015-01-15 07:57
浏览 37

将数组传递给flot

I have been trying to make a graph plot with flot, and have ran into a problem.I Think the problem is with the way m using the php variable with flot Aside from that the graph isn't showing so I must have done something wrong. Below is the graph code: 

<!DOCTYPE html>     
<html>    
<head>    
   <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
   <title>Flot Examples</title>
   <link href="layout.css" rel="stylesheet" type="text/css">
   <!--[if lte IE 8]><script language="javascript" type="text/javascript" src="../excanvas.min.js"></script><![endif]-->
   <script language="javascript" type="text/javascript" src="./flot/jquery.js"></script>
   <script language="javascript" type="text/javascript" src="./flot/jquery.flot.js"></script>
   <script language="javascript" type="text/javascript" src="./flot/jquery.flot.categories.js"></script>
</head>

<body>

<?php 

//CONNECTING TO THE SERVER
   $servername = "XXX";
   $username = "YYY";
   $password = "ZZZ";
   conn = new mysqli($servername, $username, $password);

   $sql = "SELECT NAME, AGE FROM pro_db";
   $result = $conn->query($sql);
   $wt=array();

   if ($result->num_rows > 0) {

   while($row = $result->fetch_assoc()) {
  //storing the values in the array
  $wt[]=$row;//is this the right way
  }
} else {
   echo "0 results";
}

?>
  <div id="placeholder" style="width:600px;height:300px;"></div>

  <script type="text/javascript">
  $(function () {
//accessing the array
    var data = <?php echo $wt; ?>; 

    $.plot($("#placeholder"), [data], {
    series: {
        bars: {
            show: true,
            barWidth: 0.6,
            align: "center" }
    },
    xaxis: {
        mode: "categories",
        tickLength: 0
    }
  });
 });
 </script>

</body>
</html>``
  • 写回答

1条回答 默认 最新

  • dongshan4518 2015-01-15 08:04
    关注

    Here's completely working example i made. If something doesn't work - there's some error with data. Try var_dump how your $wt array looks like in the end;

    $data = [
    ['Andrew', 31],
    ['Helen', 29],
    ['Dasha', 24],
    ['Denis', 23]
];

?>

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
</head>
<body>
    <div id="canvas" style="width: 600px; height: 400px;"></div>
    <script src="bower_components/jquery/dist/jquery.min.js"></script>
    <script src="bower_components/flot/jquery.flot.js"></script>
    <script src="bower_components/flot/jquery.flot.categories.js"></script>
    <script>
        var data = <?php echo json_encode($data) ?>;
        $("#canvas").plot([data], {
            series: {
                bars: {
                    show: true,
                    barWidth: 0.6,
                    align: "center"
                }
            },
            xaxis: {
                mode: "categories",
                tickLength: 0
            }
        });
    </script>
</body>
</html>
    评论

报告相同问题？

悬赏问题

  • ¥15 #MATLAB仿真#车辆换道路径规划
  • ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
  • ¥15 数据可视化Python
  • ¥15 要给毕业设计添加扫码登录的功能！！有偿
  • ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗？
  • ¥15 微信公众号自制会员卡没有收款渠道啊
  • ¥100 Jenkins自动化部署—悬赏100元
  • ¥15 关于#python#的问题：求帮写python代码
  • ¥20 MATLAB画图图形出现上下震荡的线条
  • ¥15 关于#windows#的问题：怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘