Javascript图表从数据库中选择汇总数据(Javascript chart pick sum data from database)

Helloooo人，我坚持我有一个单一的线图，应该从数据库中的特定列中挑选数据并将其显示在图表中

这是选取数据的脚本（600,800,100等）

数据库名称为highmob_comenzi，它需要从2个表和列中选择数据并将其汇总为表1 - 球员，列totalvanzare

表2 - vanzari，列totalvanzare

任何ideea如何做到这一点？ :(

Helloooo Guys, im stuck with something I have a single line chart that should pick data from specific column on database sum it and display it in chart

This is the script that picks the data (600, 800, 100, etc)

the database name is highmob_comenzi it needs to pick data from 2 tables and colums and sum it table 1 - players , column totalvanzare

table 2 - vanzari , column totalvanzare

any ideea how to do it? :(

最满意答案

首先，您需要明确地进行数据库调用，以获得它的总和。然后你可以这样做：

$.ajax({ url: 'url', type: 'POST', //Change this base on your requirement data: { 'data', 'some data if you need' }, success: function (data) { var lineChartData = { labels: ["January", "February", "March", "April", "May", "June", "July", "August", "Septembrie", "Octombrie", "Noiembrie", "Decembrie"], datasets: [ { label: "Data set 1", fillColor: "rgba(220,220,220,0.2)", strokeColor: "rgb(23,127,255)", pointColor: "rgb(23,127,255)", pointStrokeColor: "#fff", pointHighlightFill: "#fff", pointHighlightStroke: "rgba(220,220,220,1)", data: [data1, data2, data3] } ] } var options = { showTooltips: true, onAnimationComplete: function () { this.showTooltip(this.datasets[0].points, true); render(); }, tooltipEvents: [], responsive: true, scaleFontColor: "#5BC236", scaleColor: "#000" } var ctx = document.getElementById("graph1").getContext("2d"); var chart = new Chart(ctx).Line(lineChartData, options); } function render() { var url = document.getElementById("graph1").toDataURL(); document.getElementById("url1").src = url; }

希望这可以帮助。

Well first you need to make a database call obviously that will get the sum of whatever it is. Then you can do this:

Hope this helps.

更多推荐