RE: About ECHARTS

[mu...@ertuncltd.com.INVALID]

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 <ov...@gmail.com> 
Sent: Monday, October 31, 2022 5:52 AM
To: dev@echarts.apache.org; murat.demirbilek@ertuncltd.com
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 <murat.demirbilek@ertuncltd.com.invalid <ma...@ertuncltd.com.invalid> > 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.