douzhuijing4911 2013-04-09 05:23
浏览 99

Flot饼图从数据库中获取数据

Hi i am trying to retrieve data from mysql database to create flot pie, i've data looks like this

data in array

$Array = array();

$Array[0] = array(); $Array[1] = array(); $Array[2] = array();

$Array[0]['label'] = 'Grade A'; $Array[1]['label'] = 'Grade B'; $Array[2]['label'] = 'Grade C';

$Array[0]['color'] = '#89A54E'; $Array[1]['color'] = '#AA4643'; $Array[2]['color'] = '#4572A7';

$Array[0]['data'][0] = array(1,700); $Array[1]['data'][0] = array(1,500); $Array[2]['data'][0] = array(1,600);

echo json_encode($Array);

and this mysql

$server = "localhost";
$user="root";
$password="";
$database = "db_test";

$connection = mysql_connect($server,$user,$password);
$db = mysql_select_db($database,$connection);

$query = "SELECT * FROM pie";
$result = mysql_query($query);        

while ($record = mysql_fetch_assoc($result)) {
    $event_array[] = array(
        'label' => $record['label'],
        'color' => $record['color'],
        'data' => $record['data']
    );
}

echo json_encode($event_array);

my flot js

    $.ajax
({
    type:'POST', 
    dataType: 'JSON', 
    url:'data.php',
    success: function(data) 
    {    
        $.plot($('#Pie'), data, 
        {
            series: 
            {
                pie: 
                {
                    show: true,
                    innerRadius: 0.4,
                    radius: 1,
                    label: {
                        show: true,
                        radius: 1,
                        formatter: function(label, series) 
                        {
                            return "<div style='font-size:11px; text-align:center; padding:2px; color:white;'>"+label+"<br/>"
                            +Math.round(series.percent)+"%</div>";
                        },

                        background: 
                        {
                            opacity: 0.8
                        }
                    }
                }
            },

            grid: 
            {
                hoverable: true
            },

            legend: 
            {
                show: false
            }
        });
    }
});

it won't display anything, does anyone can help me.

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥30 这是哪个作者做的宝宝起名网站
    • ¥60 版本过低apk如何修改可以兼容新的安卓系统
    • ¥25 由IPR导致的DRIVER_POWER_STATE_FAILURE蓝屏
    • ¥50 有数据,怎么建立模型求影响全要素生产率的因素
    • ¥50 有数据,怎么用matlab求全要素生产率
    • ¥15 TI的insta-spin例程
    • ¥15 完成下列问题完成下列问题
    • ¥15 C#算法问题, 不知道怎么处理这个数据的转换
    • ¥15 YoloV5 第三方库的版本对照问题
    • ¥15 请完成下列相关问题!