Forum

Cod: Selectaţi tot

<?php
include 'bd_cnx.php';
  $sql = "SELECT
            ...";
  $result = $conn->query($sql);
  if ($result->num_rows > 0){
  while($row = $result->fetch_assoc()){
    $ret[] =[$row['NUME_J'], floatval($row['TOTAL'])];
        }
  }
    echo json_encode($ret);
?>

Cod: Selectaţi tot

var data ;
$.ajax({
    method:"POST",
    url:"query.php",
    data:{},
    success:
         function(response){
             data=response;
             $('#container').highcharts({
                  chart: {
                     type: 'column'
                 },
                 xAxis: {
                     type: 'category',
                 },
                 yAxis: {
                     min: 0,
                 },
         ...
                 series: [{
                     data: data,
                 }]
             });
         },
});

Cod: Selectaţi tot

<?php
include 'bd_cnx.php';
$ret =[];
$sql = "SELECT ...";
$result = $conn->query($sql);
//...

Cod: Selectaţi tot

function(response){
  data=JSON.parse(response);
  //...
}

Cod: Selectaţi tot

$.ajax({
  type: 'POST',
  url: 'query_stoc_grafic_1.php',
  data: {},
  success: function (response) {
    document.getElementById('container').innerHTML=response;
    columnChart( JSON.parse(response));
  }
});

function columnChart(data_v){
  if(data_v.length >0){
    $(function () {
        $('#container').highcharts({
            chart: {
                type: 'column'
            },
            series: [{
                data: data_v,
            }]
        });
    });
  }
}

Cod: Selectaţi tot

function columnChart(data_v){
  if(data_v.length >0){
    $('#container').highcharts({
      chart: {
        type: 'column'
      },
      series: [{
        data: data_v,
      }]
    });
  }
}