javascript 如何使用 MySQL 数据生成动态图表?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/5406983/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-25 17:05:48  来源:igfitidea点击:

How can I generate dynamic charts with MySQL data?

phpjavascriptmysqlgraphcharts

提问by anvd

This is not a question about the names of libraries for making graphs.

这不是关于制作图形的库名称的问题。

I have a project that needed a way to make graphs with data that comes from MySQL.

我有一个项目需要一种方法来使用来自 MySQL 的数据制作图表。

My question is: A library that provide a good integration and flexibility with external data, in this case MySQL data?

我的问题是:提供与外部数据(在本例中为 MySQL 数据)的良好集成和灵活性的库?

I need to calculate averages, make pie charts, change the data in real time, etc.

我需要计算平均值、制作饼图、实时更改数据等。

I would prefer a library that doesn't use JPEG images in final graphs. I would like something like http://raphaeljs.com/analytics.html(anyone know if there's MySQL integration for this library?).

我更喜欢在最终图形中不使用 JPEG 图像的库。我想要类似http://raphaeljs.com/analytics.html 的东西 (有人知道这个库是否有 MySQL 集成?)。

I saw the Google Charts API but I don't like the idea of not having library control on my server, and I read that it has limitations.

我看到了 Google Charts API,但我不喜欢在我的服务器上没有库控制的想法,我读到它有局限性。

采纳答案by Perfection

I would let jquery or dojo render the data in a graph therefore saving computing power on the server take a look at these links

我会让 jquery 或 dojo 在图表中呈现数据,从而节省服务器上的计算能力,看看这些链接

http://dojotoolkit.org/grids-charts

http://dojotoolkit.org/grids-charts

http://www.1stwebdesigner.com/css/top-jquery-chart-libraries-interactive-charts/

http://www.1stwebdesigner.com/css/top-jquery-chart-libraries-interactive-charts/