为NVD3加载mysql到json - load mysql to json for NVD3

load mysql to json for NVD3

本文关键字：json mysql 加载 NVD3 | 更新日期: 2023-09-27

    <?php
    $username = "root"; 
    $password = "pw";   
    $host = "localhost";
    $database="dbname";
    $server = mysql_connect($host, $username, $password);
    $connection = mysql_select_db($database, $server);
    $myquery = "
    SELECT  `name`, `useTime`, `e_usage` FROM `electric_usage`
    ";
    $query = mysql_query($myquery);
    if ( ! $query ) {
        echo mysql_error();
        die;
    }
    $data = array();
    for ($x = 0; $x < mysql_num_rows($query); $x++) {
        $data[] = mysql_fetch_assoc($query);
    }
    echo json_encode($data);     
    mysql_close($server);
?>

我使用上层php源代码将mysql加载到JSON

PHP页面的结果是

[{"name":"LED STAND","useTime":"2015-09-10 14:17:33","e_usage":"0.0599970581514709"},
{"name":"LED STAND","useTime":"2015-09-10 14:20:33","e_usage":"1.10919825898689"},
{"name":"LED STAND","useTime":"2015-09-10 14:23:33","e_usage":"1.9208018439918"}]

如何改变这种格式像这样(为nvd3线图)?

function cumulativeTestData() {
        return [
            {
                key: "LED STAND",
                values: [ [ 2015-09-10 14:17:33 , 2.974623048543] ,
                [ 2015-09-10 14:20:33 , 1.7740300785979]]
            }
}

或有简单的方法使NVD3线图从mySql数据库?

编辑:

 d3.json("./mysqljson/dbread.php", function(data) {
        var dataLoad =  d3.nest()
                        .key(function(d){return d.name})
                        .rollup(function(u){
                            return u.map(function(x){return [x.useTime,x.e_usage]})})
                        .entries(data);

    nv.addGraph(function() {
    var chart = nv.models.multiBarChart()
                  .x(function(d) {return d[0]})
                  .y(function(d) {return d[1]})
                  .margin({top: 50, bottom: 30, left: 40, right: 10});
    chart.xAxis
        .tickFormat(function(d) {
        return d3.time.format('%x')(new Date(d))
    });
    d3.select('#mainExample')
      .datum(dataLoad)
      .transition().duration(500)
      .call(chart);
    nv.utils.windowResize(chart.update);

    });

工作代码使用d3。Json和d3。巢功能

您可以通过使用d3的d3.nest()方法实现如下:

假设您使用d3.json接收到的数据结构是data，那么如果您这样做:

x=d3.nest()
    .key(function(d){return d.name})
    .rollup(function(u){
        return u.map(function(x){return [x.useTime,x.e_usage]})})
    .entries(data);

那么结果将是:

{
  key = "LED STAND"
  values =  [
         ["2015-09-10 14:17:33", "0.0599970581514709"], 
         ["2015-09-10 14:20:33", "1.10919825898689"], 
         ["2015-09-10 14:23:33", "1.9208018439918"]
  ]
}