weixin_33701251 2015-11-07 23:43 采纳率: 0%
浏览 21

从数据库中绘制图表

I'm trying to implement a FLOT chart from database, but I'm having a few problems...

I have a database with 2 rows: Data, Pcr

My files .php:

Datas.php

$dates=array();

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $date=$row['Date'];
    $pcrs=(float)$row['Pcr'];
    $dates[] = array(strtotime($date)*1000,$pcrs);
}
echo json_encode($dates);

I get the array:

[[1434240000000,7.2],[1434758400000,4.83],[1443052800000,4.85],[1445817600000,4.56],[1446163200000,4.5]]

I would like to get a chart from this array, but I don't know how to do that...

I have this file, and I know that it is incomplete...

Flot.php

<script>
        $(document).ready(function(){ 
               $.ajax({
                    type:’post’,
         dataType:'json',
                    url:'datas.php',

                    success:function(data){
        var datasets = {
            "pcr": {
            label: "Pcr",
            data: dates
            }
        };

Could someone help me to do this chart?

Thank you very much

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥60 许可证msc licensing软件报错显示已有相同版本软件,但是下一步显示无法读取日志目录。
    • ¥15 Attention is all you need 的代码运行
    • ¥15 一个服务器已经有一个系统了如果用usb再装一个系统,原来的系统会被覆盖掉吗
    • ¥15 使用esm_msa1_t12_100M_UR50S蛋白质语言模型进行零样本预测时,终端显示出了sequence handled的进度条,但是并不出结果就自动终止回到命令提示行了是怎么回事:
    • ¥15 前置放大电路与功率放大电路相连放大倍数出现问题
    • ¥30 关于<main>标签页面跳转的问题
    • ¥80 部署运行web自动化项目
    • ¥15 腾讯云如何建立同一个项目中物模型之间的联系
    • ¥30 VMware 云桌面水印如何添加
    • ¥15 用ns3仿真出5G核心网网元