Hi,
I need to help. Can you help me ?
I use to php and javascript and ajax, and i can’t run my code.
I want use to bar chart for json data.
My php code :
<?php
$output = array();
$SQL
=$connection->prepare("SELECT TOP(10) * FROM TEM32331 ORDER BY ALIS_YUZDE
DESC");
$SQL->execute();
$SQL_result = $SQL->fetchAll();
$data = array();
foreach ($SQL_result as $item)
{
$sub_array =
array();
$sub_array[] =
$item['UNVAN'];
$sub_array[] =
$item['NET_TUTAR'];
$sub_array[] =
$item['ALIS_YUZDE'];
$data[] =
$sub_array;
}
$output["gelen_dt"] = $data;
echo json_encode($output);
?>
And script :
var TEDCIROCHART = echarts.init(document.getElementById('TEDCIROCHART'));
option = {
dataset: {
source: [
['score', 'Net_Tutar', 'product'],
$.ajax ({
url: <url:%22chartselect3.php>
"chartselect3.php",
type:"POST",
dataType:"json",
success : function(data)
{
alert
(data.gelen_dt[0][0]);
}
}); ]
},
grid: { containLabel: true },
xAxis: { name: 'Net_Tutar' },
yAxis: { type: 'category' },
visualMap: {
orient: 'horizontal',
left: 'center',
min: 0,
max: 30,
text: ['High Score', 'Low Score'],
// Map the score column to color
dimension: 0,
inRange: {
color: ['#65B581', '#FFCE34', '#FD665F']
}
},
series: [
{
type: 'bar',
encode: {
// Map the "amount" column to X axis.
x: 'Net_Tutar',
// Map the "product" column to Y axis
y: 'product'
}
}
]
};
TEDCIROCHART.setOption(option);
But not working.
how can i fixed?
From: Ovilia <[email protected]>
Sent: Monday, October 31, 2022 5:52 AM
To: [email protected]; [email protected]
Subject: Re: About ECHARTS
Hi,
You do not need to pay for commercial use of Apache ECharts.
Please checkout https://github.com/apache/echarts/blob/master/LICENSE to learn
more about our license.
Thanks
Ovilia
On Thu, Oct 27, 2022 at 4:01 AM <[email protected]
<mailto:[email protected]> > wrote:
Hi,
We are a software company and We want use to ECHART from my Project.
This project will be distributed to multiple clients.
We have a question for this.
ECHART Do you have to pay for its use?
Thanks,
Best Regart.