通过php从mysql检索数据以创建flot图 [英] Retrieve data from mysql by php to create flot graph

问题描述

我正在尝试从mysql数据库中检索数据以创建浮点图 任何人都可以引导我完成此过程，或者让我知道该怎么做 谢谢

Hi i am trying to retrieve data from mysql database to create flot graph can anyone walk me through this procedure or give me an idea of what to do thanks

推荐答案

您可能想要这样的东西.我没有使用过flot，但是我在此处中查看了示例.

You probably want something like this. I haven't used flot but I looked at the example here.

<?php
//create array of pairs of x and y values
$dataset1 = array();
while ($row = mysql_fetch_assoc()) { //or whatever
    $dataset1[] = array( $row['xvalue'], $row['yvalue'] );
}
?>

<script type="text/javascript">
    //put array into javascript variable
    var dataset1 = <?php echo json_encode($dataset1); ?>;

    //plot
    $(function () {
         $.plot($("#placeholder"), [ dataset1 ]);
    });
</script>

这篇关于通过php从mysql检索数据以创建flot图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！