Clipper On Line • Ver Tópico - PHP: exibir gráfico com dados obtidos de uma tabela MySQL
Página 1 de 2

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 01:21
por cjp
Pessoal, estou tentando usar um exemplo que vi na internet para exibir um gráfico com cotações. Juntei este exemplo com um outro que achei em outro site, que exibe o gráfico, mas não estou sabendo colocar a array que peguei aqui para exibir no gráfico. Alguém pode me ajudar?

Veja como fiz:

<?php
include("conexao.php");

conectk("","");

$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='PETR3' and compvenda=0"; //$result = $conn->query($sql);

$results = array((object) array( 'dtcotacao' => $row["dtcotacao"], 'cotacao' =>
$row["cotacao"] ));

//$conn->close(); ?>

google.charts.load('current', {'packages':['corechart']});
google.charts.setOnLoadCallback(drawChart);

  function drawChart() {
    var data = google.visualization.arrayToDataTable([array(object)]);

    var options = {
      title: 'Cotações de PETR3',
      curveType: 'function',
    };

    var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

    chart.draw(data, options);
  }


Alguém pode me ajudar?

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 08:15
por ANDRIL
Esse código parece estar meio furado. Voce fez a query e não usou ela em momento algum. O $results esta usando campos de onde???
Quando arrumar o que disse acima e se é que o preenchimento após corrigido seja o correto coloque

var data = google.visualization.arrayToDataTable(<? echo( [array(object)] ) ?>);

A parte de código do google me parece ser Javascript então terá que printar o valor php na página usando a dica acima.

De uma forma geral poderia ver o que o gráfico em javascript pede como parâmetro, montar a string no php e printar ela no javascript.

<? 
$coluna = "var eixos = [[1,2,3],[a,b,c]];" ;
?>


Na parte de javascript da página

<script language="javascript">
function MeuGrafico(){
   <? echo( $coluna); ?>
   alert(eixos);
}
</script>

Até+

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 09:15
por cjp
Desculpe, mas é que meu conhecimento de PHP é muitíssimo limitado.

Tentei fazer assim:

<?php

include("conexao.php");

conectk("","");

$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='PETR3' and compvenda=0";
$rs=mysql_query($sql);
if (!$rs)
{  echo '<BR>';
  echo mysql_error();
  echo '<BR>';

   echo '<BR>';
  echo $sql;
  echo '<BR>';
exit("Error in SQL");}

$rs = array((object) array(
      'dtcotacao' => $row["dtcotacao"],
      'cotacao' => $row["cotacao"]
    ));

?>    

  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);
    
      function drawChart() {
       var data = google.visualization.arrayToDataTable(<? echo( [array(object)] ) ?>);

        var options = {
          title: 'Cotações de PETR3',
          curveType: 'function',
        };

        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>


Entretanto, está dando
Parse error: syntax error, unexpected '(object)' (object) (T_OBJECT_CAST), expecting '(' in /home/inaciocarvalho/www/php/grafico.php on line 42


Mas o object não está definido?

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 10:27
por ANDRIL
Fiz de cabeça sem testar, mais esse é o caminho
<?
$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='PETR3' and compvenda=0";
$rs=mysql_query($sql);

$obj = "['Dt.Cotacao', 'Cotacao'],";
while ($l = mysql_fetch_array($rs)){
   $obj.="['".$l['dtcotacao']."','".$l['cotacao']."'],";
}
$obj = "[".substr($obj,0,strlen($obj)-1)."]";

?>


Altere esta linha

var data = google.visualization.arrayToDataTable(<? echo( [array(object)] ) ?>);
para
var data = google.visualization.arrayToDataTable(<? echo( $obj ) ?>);

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 11:22
por cjp
Deu este erro:

Data column(s) for axis #0 cannot be of type string

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 12:09
por ANDRIL
Esse erro já é do próprio gráfico. O motivo deve ser ou por que sua query não esteja trazendo dados ou o formato que o gráfico exige esta errado na montagem da construção no PHP.

$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='PETR3' and compvenda=0";
$rs=mysql_query($sql);

$obj = "['Dt.Cotacao', 'Cotacao'],";
if (mysql_num_rows($rs)==0){
   $obj.="['Nenhuma data', 0],";
}else{
   while ($l = mysql_fetch_array($rs)){
      $obj.="['".$l['dtcotacao']."',".$l['cotacao']."],";
   }
}
$obj = "[".substr($obj,0,strlen($obj)-1)."]";

Use este novo código tratado.

O esquema de montagem no PHP esta ok, agora veja como o gráfico que esta montando precisa dos campos. Verifique se tem que adicionar colunas com o tipo de dados (string, date, numeric etc). Consulte o manual do gráfico em questão.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 13:54
por cjp
Agora, aparentemente, funcionou.
Mas o gráfico não ficou correto. Veja a imagem anexa.
O mesmo select, no HeidiSQL, fornece os dados corretamente, conforme anexo.
Não entendo disso, mas vi no modelo inicial do gráfico que ele usava uma array comum, com data e valor.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 14:45
por ANDRIL
Não sei o que voce espera do gráfico, o meu teste aqui ficou assim
FORUM - GRAFICO INACIO.jpg


Da um echo($obj) no seu código php, o meu esta saindo assim:
[['Dt.Cotacao', 'Cotacao'],['2020-03-26',14.24],['2020-03-27',13.45],['2020-03-31',14.01],['2020-04-01',14.19],['2020-04-02',15.16],['2020-04-03',15.07],['2020-04-04',15.32],['2020-04-05',15.32],['2020-04-06',15.32],['2020-04-07',16.15],['2020-04-08',16.56],['2020-04-09',17.50]]


esses são os dados que seu gráfico espera no Javascript.
Até+

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 15:46
por cjp
Sim, o gráfico que eu esperava era exatamente assim como vc mostrou. Vc obteve esse gráfico com os mesmos dados que estou usando?

echo $obj resultou isto:

[['Dt.Cotacao', 'Cotacao'],['2016-03-24',9.70],['2016-04-01',10.26],['2016-04-01',10.30],['2016-04-15',11.97],['2016-04-18',11.66],['2016-04-22',12.84],['2016-04-26',12.90],['2016-04-29',13.27],['2016-05-02',13.00],['2016-05-05',13.45],['2016-05-09',11.78],['2016-05-12',10.25],['2016-05-16',12.65],['2016-05-18',12.31],['2016-05-19',11.61],['2016-05-24',11.07],['2016-05-31',10.31],['2016-06-01',10.14],['2016-06-02',10.67],['2016-06-03',10.80],['2016-06-07',11.17],['2016-06-08',12.03],['2016-06-10',11.35],['2016-06-15',10.79],['2016-06-17',11.42],['2016-06-20',11.39],['2016-06-21',11.50],['2016-06-23',11.91],['2016-06-24',12.05],['2016-06-26',11.43],['2016-06-28',11.34],['2016-06-30',11.57],['2016-07-04',12.06],['2016-07-05',11.62],['2016-07-08',11.97],['2016-07-11',12.52],['2016-07-21',13.65],['2016-07-27',13.92],['2016-08-01',14.09],['2016-08-04',13.58],['2016-08-10',13.75],['2016-08-12',13.91],['2016-08-16',14.43],['2016-08-19',15.13],['2016-08-22',14.63],['2016-08-25',14.73],['2016-08-29',15.11],['2016-09-01',14.87],['2016-09-05',15.94],['2016-09-09',16.05],['2016-09-13',15.78],['2016-09-13',14.81],['2016-09-19',15.10],['2016-09-27',14.65],['2016-10-02',15.14],['2016-10-25',19.35],['2016-11-09',17.28],['2016-11-30',18.32],['2016-12-01',19.01],['2016-12-08',18.28],['2016-12-12',18.59],['2016-12-19',17.38],['2016-12-26',16.77],['2017-02-09',15.51],['2017-04-06',15.36],['2017-08-11',13.51],['2017-08-21',13.85],['2017-08-31',14.12],['2017-09-06',15.24],['2017-09-25',16.34],['2017-10-03',16.31],['2017-10-04',16.45],['2017-10-05',16.64],['2017-10-16',16.77],['2017-10-23',16.59],['2017-10-30',17.42],['2017-11-22',16.60],['2017-12-01',16.18],['2017-12-28',16.91],['2018-01-30',21.09],['2018-02-19',21.18],['2018-02-26',23.08],['2018-03-22',23.53],['2018-04-02',22.88],['2018-04-05',23.55],['2018-04-06',23.31],['2018-04-10',23.31],['2018-04-10',23.74],['2018-04-11',24.29],['2018-04-11',24.28],['2018-04-16',23.07],['2018-04-18',24.17],['2018-04-19',24.34],['2018-04-25',23.42],['2018-04-26',24.08],['2018-05-09',25.90],['2018-05-09',27.53],['2018-05-10',29.11],['2018-05-11',29.45],['2018-05-14',29.91],['2018-05-14',30.16],['2018-05-14',30.30],['2018-05-15',30.50],['2018-05-15',30.78],['2018-05-15',31.21],['2018-05-18',30.49],['2018-05-21',29.47],['2018-05-22',28.38],['2018-05-22',28.32],['2018-05-23',27.68],['2018-05-23',9999.99],['2018-05-24',24.04],['2018-05-24',23.60],['2018-05-24',23.35],['2018-05-24',23.50],['2018-05-24',23.16],['2018-05-25',24.25],['2018-05-25',23.52],['2018-05-26',23.03],['2018-05-28',21.95],['2018-05-29',21.24],['2018-05-29',22.04],['2018-05-29',21.99],['2018-05-29',22.01],['2018-05-29',21.91],['2018-05-29',22.20],['2018-05-30',21.93],['2018-05-30',22.39],['2018-06-01',22.00],['2018-06-01',19.05],['2018-06-01',18.74],['2018-06-01',19.20],['2018-06-04',20.20],['2018-06-04',20.19],['2018-06-06',19.29],['2018-06-06',19.09],['2018-06-07',19.03],['2018-06-07',18.92],['2018-06-07',18.72],['2018-06-07',18.27],['2018-06-07',18.59],['2018-06-08',18.70],['2018-06-08',18.24],['2018-06-08',18.05],['2018-06-08',18.17],['2018-06-08',18.25],['2018-06-08',18.55],['2018-06-09',18.04],['2018-06-11',18.06],['2018-06-11',18.35],['2018-06-13',17.77],['2018-06-18',17.33],['2018-06-19',17.90],['2018-06-19',15.50],['2018-06-20',18.29],['2018-06-20',16.27],['2018-06-21',18.05],['2018-06-21',17.85],['2018-06-21',17.72],['2018-06-22',18.09],['2018-06-22',17.95],['2018-06-22',17.88],['2018-06-22',17.76],['2018-06-23',17.76],['2018-06-25',18.01],['2018-06-25',17.68],['2018-06-25',18.11],['2018-06-26',18.41],['2018-06-26',18.33],['2018-06-26',18.01],['2018-06-26',18.28],['2018-06-26',18.26],['2018-06-26',18.37],['2018-06-28',19.21],['2018-06-28',19.18],['2018-06-29',19.10],['2018-06-29',19.10],['2018-07-02',19.38],['2018-07-04',19.55],['2018-07-05',20.09],['2018-07-06',20.10],['2018-07-09',20.22],['2018-07-10',20.57],['2018-07-11',20.39],['2018-07-11',20.52],['2018-07-11',20.33],['2018-07-12',20.02],['2018-07-12',20.30],['2018-07-12',20.42],['2018-07-12',20.66],['2018-07-13',20.60],['2018-07-13',20.60],['2018-07-13',20.52],['2018-07-13',20.53],['2018-07-13',20.46],['2018-07-16',20.58],['2018-07-16',20.20],['2018-07-16',20.07],['2018-07-16',20.08],['2018-07-16',20.12],['2018-07-16',20.14],['2018-07-16',20.29],['2018-07-17',20.93],['2018-07-19',20.60],['2018-07-19',20.52],['2018-07-19',20.53],['2018-07-19',20.70],['2018-07-19',20.55],['2018-07-19',20.52],['2018-07-20',21.31],['2018-07-20',21.34],['2018-07-21',21.42],['2018-07-23',21.48],['2018-07-24',22.09],['2018-07-24',21.90],['2018-07-24',21.84],['2018-07-24',21.83],['2018-07-24',21.89],['2018-07-25',21.90],['2018-07-25',21.95],['2018-07-25',22.11],['2018-07-25',22.10],['2018-07-25',22.09],['2018-07-26',21.80],['2018-07-26',21.79],['2018-07-26',21.72],['2018-07-26',21.62],['2018-07-27',22.06],['2018-07-27',22.01],['2018-07-27',22.01],['2018-07-27',22.10],['2018-07-30',22.37],['2018-07-30',21.94],['2018-07-30',22.09],['2018-07-30',22.06],['2018-07-31',22.06],['2018-07-31',21.90],['2018-07-31',21.63],['2018-07-31',21.63],['2018-07-31',21.90],['2018-07-31',21.94],['2018-08-01',21.94],['2018-08-01',21.70],['2018-08-01',21.99],['2018-08-01',21.81],['2018-08-01',21.84],['2018-08-01',21.84],['2018-08-01',21.86],['2018-08-01',21.82],['2018-08-01',22.03],['2018-08-02',22.07],['2018-08-02',22.07],['2018-08-02',22.37],['2018-08-02',22.56],['2018-08-03',23.60],['2018-08-03',23.23],['2018-08-03',23.33],['2018-08-03',23.19],['2018-08-03',23.24],['2018-08-03',23.25],['2018-08-03',23.22],['2018-08-06',23.50],['2018-08-06',23.55],['2018-08-06',23.53],['2018-08-07',23.43],['2018-08-08',23.13],['2018-08-08',22.89],['2018-08-09',22.82],['2018-08-09',22.65],['2018-08-09',22.49],['2018-08-09',22.76],['2018-08-10',22.38],['2018-08-10',22.23],['2018-08-10',22.16],['2018-08-13',22.16],['2018-08-13',22.11],['2018-08-13',22.30],['2018-08-13',22.25],['2018-08-13',22.41],['2018-08-14',22.64],['2018-08-14',22.27],['2018-08-14',22.24],['2018-08-14',22.40],['2018-08-15',22.26],['2018-08-15',21.57],['2018-08-15',21.58],['2018-08-15',21.72],['2018-08-15',21.76],['2018-08-16',21.38],['2018-08-16',21.31],['2018-08-16',21.48],['2018-08-16',21.37],['2018-08-16',21.31],['2018-08-16',21.23],['2018-08-16',21.29],['2018-08-17',21.04],['2018-08-17',20.94],['2018-08-17',21.02],['2018-08-17',21.00],['2018-08-17',20.95],['2018-08-17',20.95],['2018-08-20',20.95],['2018-08-20',20.95],['2018-08-20',20.79],['2018-08-20',20.70],['2018-08-20',20.87],['2018-08-20',20.86],['2018-08-21',21.00],['2018-08-21',20.93],['2018-08-21',21.02],['2018-08-21',20.87],['2018-08-21',20.65],['2018-08-22',9999.99],['2018-08-22',20.67],['2018-08-22',20.91],['2018-08-22',21.12],['2018-08-22',21.23],['2018-08-23',21.19],['2018-08-23',21.04],['2018-08-23',21.14],['2018-08-23',21.00],['2018-08-24',21.19],['2018-08-24',21.02],['2018-08-24',20.98],['2018-08-27',21.06],['2018-08-27',21.25],['2018-08-27',21.31],['2018-08-27',21.35],['2018-08-27',21.31],['2018-08-27',21.34],['2018-08-27',21.36],['2018-08-27',21.43],['2018-08-27',21.32],['2018-08-28',21.45],['2018-08-28',21.45],['2018-08-28',21.45],['2018-08-28',21.39],['2018-08-28',21.33],['2018-08-28',21.28],['2018-08-28',21.42],['2018-08-28',21.45],['2018-08-28',21.42],['2018-08-28',21.37],['2018-08-28',21.30],['2018-08-29',21.24],['2018-08-29',21.68],['2018-08-29',21.82],['2018-08-29',21.88],['2018-08-29',21.88],['2018-08-29',22.19],['2018-08-29',22.24],['2018-08-29',22.20],['2018-08-29',22.19],['2018-08-29',22.17],['2018-08-30',22.17],['2018-08-30',22.17],['2018-08-30',21.93],['2018-09-03',21.69],['2018-09-06',21.74],['2018-09-10',22.54],['2018-09-10',22.39],['2018-09-12',22.16],['2018-09-12',22.27],['2018-09-12',22.16],['2018-09-13',22.16],['2018-09-13',22.25],['2018-09-17',22.36],['2018-09-20',23.11],['2018-09-24',23.22],['2018-09-24',23.59],['2018-09-24',23.43],['2018-09-24',23.41],['2018-09-24',23.18],['2018-09-25',23.15],['2018-09-25',23.15],['2018-09-25',23.17],['2018-09-25',23.17],['2018-09-25',23.31],['2018-09-25',23.27],['2018-09-26',23.27],['2018-09-26',23.27],['2018-09-26',23.40],['2018-09-26',23.22],['2018-09-26',23.10],['2018-09-26',23.36],['2018-09-26',23.36],['2018-09-27',23.36],['2018-09-27',23.36],['2018-09-27',24.34],['2018-09-27',24.32],['2018-09-27',24.24],['2018-09-27',24.31],['2018-09-28',24.50],['2018-09-28',24.86],['2018-09-28',24.72],['2018-09-28',24.70],['2018-09-28',24.30],['2018-09-28',24.23],['2018-10-01',24.23],['2018-10-01',24.23],['2018-10-01',23.97],['2018-10-01',24.04],['2018-10-01',24.12],['2018-10-02',25.78],['2018-10-04',26.44],['2018-10-04',26.64],['2018-10-08',29.11],['2018-10-08',29.00],['2018-10-08',29.06],['2018-10-08',29.14],['2018-10-15',28.10],['2018-10-15',28.85],['2018-10-17',29.51],['2018-10-18',28.81],['2018-10-18',28.88],['2018-10-23',29.14],['2018-10-23',29.27],['2018-10-26',29.10],['2018-10-26',29.86],['2018-10-29',29.24],['2018-10-31',30.28],['2018-10-31',30.10],['2018-11-01',30.00],['2018-11-06',30.04],['2018-11-06',30.10],['2018-11-08',29.61],['2018-11-09',27.71],['2018-11-12',28.13],['2018-11-12',28.13],['2018-11-12',28.13],['2018-11-12',28.08],['2018-11-12',28.36],['2018-11-12',28.04],['2018-11-13',27.99],['2018-11-13',27.99],['2018-11-13',27.61],['2018-11-13',27.15],['2018-11-13',26.94],['2018-11-13',27.01],['2018-11-14',27.20],['2018-11-14',27.19],['2018-11-16',27.79],['2018-11-19',28.18],['2018-11-20',28.03],['2018-11-20',28.03],['2018-11-20',28.03],['2018-11-20',28.03],['2018-11-21',27.36],['2018-11-21',27.18],['2018-11-21',27.24],['2018-11-21',27.27],['2018-11-21',26.97],['2018-11-21',26.78],['2018-11-21',26.79],['2018-11-21',26.73],['2018-11-21',26.76],['2018-11-21',26.91],['2018-11-21',27.06],['2018-11-21',27.17],['2018-11-21',27.14],['2018-11-21',27.13],['2018-11-21',27.21],['2018-11-21',27.24],['2018-11-21',27.18],['2018-11-22',27.38],['2018-11-22',27.38],['2018-11-22',27.30],['2018-11-22',27.41],['2018-11-22',27.35],['2018-11-22',27.26],['2018-11-22',27.20],['2018-11-22',27.23],['2018-11-22',27.15],['2018-11-22',27.38],['2018-11-23',26.70],['2018-11-23',26.20],['2018-11-23',26.24],['2018-11-23',26.22],['2018-11-23',26.24],['2018-11-23',26.59],['2018-11-23',26.63],['2018-11-23',26.37],['2018-11-23',26.47],['2018-11-23',26.44],['2018-11-23',26.44],['2018-11-23',26.45],['2018-11-23',26.50],['2018-11-23',26.56],['2018-11-23',26.57],['2018-11-23',26.64],['2018-11-23',26.58],['2018-11-26',26.69],['2018-11-26',26.69],['2018-11-26',27.13],['2018-11-26',27.17],['2018-11-26',26.97],['2018-11-26',27.09],['2018-11-26',27.11],['2018-11-26',26.85],['2018-11-26',26.87],['2018-11-26',26.98],['2018-11-27',27.10],['2018-11-27',27.14],['2018-11-27',27.53],['2018-11-27',27.66],['2018-11-27',28.01],['2018-11-28',28.28],['2018-11-28',28.15],['2018-11-28',27.50],['2018-11-28',27.68],['2018-11-28',27.59],['2018-11-28',27.64],['2018-11-29',27.67],['2018-11-29',27.47],['2018-11-29',27.67],['2018-11-29',27.67],['2018-11-29',27.67],['2018-11-29',27.81],['2018-11-29',27.87],['2018-11-29',27.85],['2018-11-29',27.55],['2018-11-29',27.46],['2018-11-29',27.69],['2018-11-29',27.72],['2018-11-29',27.78],['2018-11-29',27.84],['2018-11-29',27.84],['2018-11-30',27.85],['2018-11-30',27.85],['2018-11-30',27.80],['2018-11-30',27.77],['2018-11-30',27.85],['2018-11-30',27.83],['2018-11-30',27.65],['2018-11-30',27.77],['2018-11-30',27.77],['2018-11-30',27.93],['2018-11-30',28.10],['2018-11-30',28.18],['2018-11-30',28.15],['2018-11-30',28.19],['2018-12-03',28.13],['2018-12-03',29.18],['2018-12-03',29.16],['2018-12-03',29.13],['2018-12-03',29.15],['2018-12-03',29.16],['2018-12-03',29.17],['2018-12-03',29.16],['2018-12-03',29.14],['2018-12-03',28.74],['2018-12-04',29.08],['2018-12-04',28.52],['2018-12-04',28.50],['2018-12-04',28.42],['2018-12-05',28.42],['2018-12-05',28.42],['2018-12-05',27.98],['2018-12-05',28.23],['2018-12-05',28.22],['2018-12-05',28.42],['2018-12-05',28.56],['2018-12-05',28.54],['2018-12-06',27.86],['2018-12-06',27.99],['2018-12-06',27.13],['2018-12-06',27.29],['2018-12-06',27.29],['2018-12-07',28.05],['2018-12-07',28.38],['2018-12-07',28.33],['2018-12-07',27.84],['2018-12-10',27.61],['2018-12-10',27.54],['2018-12-10',26.71],['2018-12-10',26.67],['2018-12-10',26.62],['2018-12-11',26.85],['2018-12-12',26.59],['2018-12-12',26.39],['2018-12-13',26.45],['2018-12-13',26.41],['2018-12-13',26.39],['2018-12-17',26.58],['2018-12-18',25.75],['2018-12-18',25.68],['2018-12-18',25.60],['2018-12-18',25.65],['2018-12-18',25.70],['2018-12-18',25.59],['2018-12-18',25.42],['2018-12-19',25.07],['2018-12-19',24.92],['2018-12-19',24.54],['2018-12-19',24.98],['2018-12-19',25.46],['2018-12-19',25.64],['2018-12-19',24.76],['2018-12-20',24.55],['2018-12-20',24.22],['2018-12-21',23.90],['2018-12-21',24.66],['2018-12-26',23.41],['2018-12-26',23.61],['2018-12-26',24.08],['2018-12-28',25.22],['2018-12-28',25.25],['2018-12-28',25.17],['2018-12-28',25.29],['2018-12-28',25.60],['2019-01-01',25.40],['2019-01-02',25.40],['2019-01-02',25.27],['2019-01-02',25.15],['2019-01-02',25.48],['2019-01-02',25.90],['2019-01-02',26.78],['2019-01-02',26.79],['2019-01-02',26.81],['2019-01-02',26.78],['2019-01-02',26.71],['2019-01-03',26.65],['2019-01-03',27.16],['2019-01-03',27.19],['2019-01-03',26.77],['2019-01-03',26.81],['2019-01-03',26.74],['2019-01-03',26.65],['2019-01-03',27.20],['2019-01-04',27.20],['2019-01-04',27.20],['2019-01-04',27.20],['2019-01-04',27.24],['2019-01-04',27.41],['2019-01-04',27.36],['2019-01-04',27.23],['2019-01-04',27.29],['2019-01-04',27.33],['2019-01-04',27.32],['2019-01-04',27.50],['2019-01-07',27.97],['2019-01-07',28.01],['2019-01-07',28.07],['2019-01-07',28.54],['2019-01-08',28.65],['2019-01-08',28.34],['2019-01-08',28.57],['2019-01-08',28.57],['2019-01-08',28.49],['2019-01-09',28.67],['2019-01-09',28.60],['2019-01-09',28.84],['2019-01-09',28.95],['2019-01-09',28.87],['2019-01-10',28.65],['2019-01-10',28.49],['2019-01-10',28.65],['2019-01-10',28.56],['2019-01-10',28.68],['2019-01-11',28.68],['2019-01-11',28.51],['2019-01-11',28.39],['2019-01-11',28.41],['2019-01-11',28.50],['2019-01-14',28.20],['2019-01-14',28.53],['2019-01-14',28.56],['2019-01-14',28.50],['2019-01-15',28.62],['2019-01-15',28.58],['2019-01-16',28.22],['2019-01-16',28.38],['2019-01-16',28.40],['2019-01-17',28.72],['2019-01-17',28.71],['2019-01-17',28.76],['2019-01-17',28.78],['2019-01-17',28.78],['2019-01-18',29.16],['2019-01-18',28.97],['2019-01-18',28.97],['2019-01-21',28.92],['2019-01-21',28.84],['2019-01-21',28.90],['2019-01-21',29.13],['2019-01-22',28.96],['2019-01-22',29.02],['2019-01-22',29.04],['2019-01-22',28.89],['2019-01-22',28.90],['2019-01-23',28.85],['2019-01-23',29.16],['2019-01-23',29.29],['2019-01-23',29.24],['2019-01-23',28.99],['2019-01-24',29.26],['2019-01-24',29.33],['2019-01-25',29.46],['2019-01-25',29.46],['2019-01-25',29.46],['2019-01-25',29.46],['2019-01-28',29.46],['2019-01-28',29.24],['2019-01-28',29.39],['2019-01-28',28.79],['2019-01-28',28.42],['2019-01-28',28.52],['2019-01-28',28.54],['2019-01-29',28.42],['2019-01-29',28.88],['2019-01-29',29.20],['2019-01-29',29.12],['2019-01-29',29.29],['2019-01-29',29.37],['2019-01-30',29.62],['2019-01-30',29.50],['2019-01-30',29.37],['2019-01-30',29.53],['2019-01-31',29.44],['2019-01-31',29.81],['2019-01-31',29.79],['2019-01-31',29.74],['2019-01-31',29.69],['2019-01-31',29.87],['2019-01-31',29.61],['2019-02-01',29.55],['2019-02-01',29.53],['2019-02-01',29.77],['2019-02-01',29.77],['2019-02-01',29.70],['2019-02-01',29.89],['2019-02-04',29.98],['2019-02-04',29.85],['2019-02-04',30.17],['2019-02-04',30.41],['2019-02-05',30.36],['2019-02-05',30.31],['2019-02-05',30.27],['2019-02-05',30.48],['2019-02-05',30.68],['2019-02-06',30.55],['2019-02-06',30.55],['2019-02-06',30.11],['2019-02-06',30.28],['2019-02-06',30.31],['2019-02-07',30.01],['2019-02-07',30.01],['2019-02-07',30.54],['2019-02-07',30.16],['2019-02-07',29.97],['2019-02-07',29.51],['2019-02-08',29.48],['2019-02-08',29.26],['2019-02-08',29.49],['2019-02-08',29.10],['2019-02-08',29.15],['2019-02-08',29.31],['2019-02-11',29.27],['2019-02-11',29.07],['2019-02-11',29.06],['2019-02-11',28.86],['2019-02-11',29.05],['2019-02-11',29.05],['2019-02-12',28.90],['2019-02-12',28.90],['2019-02-12',29.91],['2019-02-12',29.86],['2019-02-12',29.77],['2019-02-12',29.94],['2019-02-13',29.94],['2019-02-13',30.27],['2019-02-13',30.21],['2019-02-13',30.21],['2019-02-13',9999.99],['2019-02-13',30.65],['2019-02-13',30.70],['2019-02-14',30.65],['2019-02-14',30.77],['2019-02-14',30.87],['2019-02-14',30.63],['2019-02-14',30.64],['2019-02-14',31.00],['2019-02-15',31.29],['2019-02-15',31.29],['2019-02-15',31.09],['2019-02-15',31.03],['2019-02-15',31.06],['2019-02-18',31.05],['2019-02-19',31.34],['2019-02-19',31.21],['2019-02-19',31.37],['2019-02-19',31.40],['2019-02-19',31.33],['2019-02-20',31.56],['2019-02-20',31.56],['2019-02-20',31.67],['2019-02-20',31.58],['2019-02-20',31.45],['2019-02-20',31.49],['2019-02-21',31.26],['2019-02-21',31.26],['2019-02-21',31.26],['2019-02-21',31.22],['2019-02-21',31.15],['2019-02-21',31.23],['2019-02-21',31.44],['2019-02-22',31.43],['2019-02-22',31.43],['2019-02-22',31.26],['2019-02-22',31.16],['2019-02-22',31.12],['2019-02-22',31.10],['2019-02-25',30.96],['2019-02-25',30.57],['2019-02-25',30.53],['2019-02-26',30.69],['2019-02-26',30.84],['2019-02-26',30.53],['2019-02-27',30.86],['2019-02-27',30.66],['2019-02-27',30.91],['2019-02-27',30.92],['2019-02-27',30.83],['2019-02-28',30.55],['2019-02-28',29.64],['2019-02-28',29.53],['2019-03-01',29.86],['2019-03-01',29.60],['2019-03-01',29.39],['2019-03-01',29.20],['2019-03-04',29.20],['2019-03-04',29.20],['2019-03-04',29.20],['2019-03-06',29.24],['2019-03-08',28.80],['2019-03-08',28.81],['2019-03-11',30.67],['2019-03-12',30.27],['2019-03-13',30.30],['2019-03-13',31.11],['2019-03-14',31.18],['2019-03-14',31.37],['2019-03-19',32.56],['2019-03-20',32.98],['2019-03-21',32.50],['2019-03-25',30.68],['2019-03-25',30.61],['2019-03-25',30.48],['2019-03-26',31.14],['2019-03-26',31.55],['2019-03-26',31.65],['2019-03-26',31.93],['2019-03-27',31.10],['2019-03-27',31.14],['2019-03-27',31.09],['2019-03-27',30.55],['2019-03-28',30.44],['2019-03-28',31.09],['2019-04-03',30.87],['2019-04-06',32.05],['2019-04-08',32.96],['2019-04-12',31.85],['2019-04-12',29.43],['2019-04-16',29.11],['2019-04-18',30.90],['2019-04-22',30.76],['2019-04-26',30.66],['2019-04-26',30.35],['2019-04-30',30.25],['2019-05-02',29.48],['2019-05-06',29.50],['2019-05-09',29.43],['2019-05-10',29.36],['2019-05-10',29.12],['2019-05-10',29.25],['2019-05-11',29.35],['2019-05-12',29.35],['2019-05-13',29.35],['2019-05-13',28.70],['2019-05-13',28.78],['2019-05-13',28.55],['2019-05-13',28.51],['2019-05-14',28.51],['2019-05-14',28.66],['2019-05-14',28.68],['2019-05-14',28.68],['2019-05-14',28.62],['2019-05-14',28.52],['2019-05-15',28.52],['2019-05-15',28.32],['2019-05-15',28.88],['2019-05-19',27.56],['2019-05-21',28.56],['2019-05-21',28.56],['2019-05-23',28.11],['2019-05-23',28.09],['2019-05-24',28.51],['2019-05-28',28.74],['2019-05-29',28.75],['2019-05-30',28.75],['2019-05-31',28.31],['2019-06-03',29.07],['2019-06-04',28.84],['2019-06-05',28.42],['2019-06-06',29.13],['2019-06-07',29.70],['2019-06-11',29.95],['2019-06-12',29.38],['2019-06-12',29.41],['2019-06-14',29.98],['2019-06-18',30.15],['2019-06-21',31.87],['2019-06-25',31.66],['2019-06-25',30.76],['2019-06-27',29.93],['2019-06-27',30.18],['2019-06-27',29.89],['2019-06-28',29.89],['2019-06-28',30.33],['2019-06-28',30.15],['2019-06-28',29.87],['2019-06-28',29.79],['2019-06-28',30.02],['2019-06-29',30.02],['2019-06-30',30.02],['2019-07-01',30.02],['2019-07-01',30.54],['2019-07-01',30.08],['2019-07-01',30.00],['2019-07-01',29.90],['2019-07-01',29.92],['2019-07-02',29.92],['2019-07-02',29.46],['2019-07-02',29.29],['2019-07-02',29.36],['2019-07-02',29.47],['2019-07-03',29.57],['2019-07-03',29.69],['2019-07-03',29.73],['2019-07-03',29.77],['2019-07-04',29.77],['2019-07-04',30.10],['2019-07-04',30.28],['2019-07-04',30.20],['2019-07-04',30.03],['2019-07-05',30.15],['2019-07-05',30.18],['2019-07-05',30.07],['2019-07-05',30.03],['2019-07-06',30.03],['2019-07-07',30.03],['2019-07-08',30.03],['2019-07-08',30.03],['2019-07-08',30.03],['2019-07-08',30.19],['2019-07-08',30.19],['2019-07-08',30.33],['2019-07-08',30.48],['2019-07-08',30.61],['2019-07-08',30.61],['2019-07-09',30.61],['2019-07-09',30.61],['2019-07-10',30.61],['2019-07-10',30.91],['2019-07-10',30.70],['2019-07-10',30.72],['2019-07-10',30.72],['2019-07-11',30.72],['2019-07-11',31.07],['2019-07-12',31.46],['2019-07-15',31.02],['2019-07-16',30.68],['2019-07-16',30.60],['2019-07-17',30.60],['2019-07-17',30.38],['2019-07-17',30.50],['2019-07-17',30.40],['2019-07-17',30.38],['2019-07-17',30.40],['2019-07-18',30.40],['2019-07-18',30.35],['2019-07-18',30.09],['2019-07-18',29.99],['2019-07-18',30.03],['2019-07-18',30.07],['2019-07-19',30.07],['2019-07-19',29.98],['2019-07-19',29.94],['2019-07-19',30.04],['2019-07-19',30.07],['2019-07-20',30.06],['2019-07-21',30.06],['2019-07-26',28.84],['2019-07-26',28.78],['2019-07-26',28.63],['2019-07-26',28.54],['2019-07-27',28.54],['2019-07-29',28.67],['2019-07-29',28.89],['2019-08-01',28.67],['2019-08-01',28.12],['2019-08-02',28.35],['2019-08-02',29.32],['2019-08-02',29.30],['2019-08-02',29.09],['2019-08-02',29.21],['2019-08-03',29.21],['2019-08-04',29.21],['2019-08-05',29.21],['2019-08-05',28.24],['2019-08-05',28.11],['2019-08-05',28.06],['2019-08-06',28.00],['2019-08-06',28.55],['2019-08-06',28.46],['2019-08-06',28.47],['2019-08-06',28.47],['2019-08-07',28.47],['2019-08-07',27.72],['2019-08-07',27.95],['2019-08-07',27.86],['2019-08-07',28.20],['2019-08-08',28.20],['2019-08-08',28.61],['2019-08-08',28.59],['2019-08-08',28.63],['2019-08-08',28.61],['2019-08-08',28.66],['2019-08-08',28.73],['2019-08-08',28.78],['2019-08-08',28.87],['2019-08-09',28.87],['2019-08-09',28.87],['2019-08-09',28.87],['2019-08-09',28.80],['2019-08-09',28.72],['2019-08-09',28.72],['2019-08-09',28.72],['2019-08-09',28.74],['2019-08-09',28.62],['2019-08-10',28.62],['2019-08-11',28.62],['2019-08-12',28.62],['2019-08-12',28.22],['2019-08-12',28.06],['2019-08-12',28.02],['2019-08-12',27.91],['2019-08-12',27.83],['2019-08-12',27.83],['2019-08-12',27.85],['2019-08-13',27.85],['2019-08-13',28.06],['2019-08-13',28.12],['2019-08-13',28.08],['2019-08-13',28.15],['2019-08-13',28.07],['2019-08-13',28.10],['2019-08-13',28.15],['2019-08-13',28.00],['2019-08-13',27.85],['2019-08-14',27.96],['2019-08-14',27.96],['2019-08-14',27.20],['2019-08-14',27.12],['2019-08-14',27.10],['2019-08-14',27.13],['2019-08-14',27.07],['2019-08-14',27.10],['2019-08-14',27.10],['2019-08-15',27.10],['2019-08-15',27.10],['2019-08-15',27.10],['2019-08-15',26.91],['2019-08-15',26.62],['2019-08-15',26.82],['2019-08-15',26.74],['2019-08-15',26.86],['2019-08-15',26.64],['2019-08-15',26.50],['2019-08-16',26.50],['2019-08-16',26.50],['2019-08-16',26.78],['2019-08-16',26.78],['2019-08-16',26.69],['2019-08-16',26.70],['2019-08-16',26.63],['2019-08-16',26.38],['2019-08-17',26.38],['2019-08-18',26.38],['2019-08-19',26.38],['2019-08-19',26.38],['2019-08-19',26.38],['2019-08-19',26.38],['2019-08-19',26.88],['2019-08-19',26.82],['2019-08-19',26.87],['2019-08-19',26.80],['2019-08-19',26.74],['2019-08-19',26.66],['2019-08-19',26.67],['2019-08-20',26.74],['2019-08-20',26.45],['2019-08-20',26.51],['2019-08-20',26.54],['2019-08-20',26.62],['2019-08-20',26.49],['2019-08-21',26.49],['2019-08-21',26.86],['2019-08-21',26.99],['2019-08-21',27.08],['2019-08-21',27.85],['2019-08-21',27.98],['2019-08-21',27.90],['2019-08-22',27.90],['2019-08-22',28.10],['2019-08-22',27.97],['2019-08-22',27.64],['2019-08-22',27.78],['2019-08-22',27.60],['2019-08-22',27.75],['2019-08-22',27.78],['2019-08-22',27.63],['2019-08-23',27.63],['2019-08-23',27.63],['2019-08-23',27.63],['2019-08-23',27.48],['2019-08-23',26.97],['2019-08-23',26.90],['2019-08-23',26.75],['2019-08-23',26.82],['2019-08-23',26.76],['2019-08-24',26.76],['2019-08-25',26.76],['2019-08-26',26.76],['2019-08-26',26.76],['2019-08-26',26.70],['2019-08-26',26.53],['2019-08-26',26.60],['2019-08-26',26.41],['2019-08-27',26.41],['2019-08-27',26.41],['2019-08-27',26.68],['2019-08-27',27.03],['2019-08-27',27.05],['2019-08-27',27.06],['2019-08-27',27.20],['2019-08-27',27.01],['2019-08-27',26.61],['2019-08-27',26.60],['2019-08-27',26.88],['2019-08-27',26.91],['2019-08-27',26.91],['2019-08-28',26.91],['2019-08-28',26.91],['2019-08-28',26.91],['2019-08-28',27.18],['2019-08-28',27.17],['2019-08-28',27.06],['2019-08-28',27.19],['2019-08-28',27.24],['2019-08-28',27.14],['2019-08-28',27.10],['2019-08-29',27.10],['2019-08-29',27.10],['2019-08-29',27.60],['2019-08-29',27.61],['2019-08-29',27.43],['2019-08-29',27.68],['2019-08-29',27.79],['2019-08-29',27.77],['2019-08-29',27.98],['2019-08-29',28.12],['2019-08-30',28.12],['2019-08-30',28.21],['2019-08-30',27.99],['2019-08-30',27.93],['2019-08-30',27.83],['2019-08-30',27.91],['2019-08-30',27.89],['2019-08-30',28.27],['2019-08-31',28.27],['2019-09-01',28.27],['2019-09-02',28.27],['2019-09-02',28.27],['2019-09-02',28.11],['2019-09-02',28.10],['2019-09-02',28.13],['2019-09-02',28.27],['2019-09-02',28.13],['2019-09-02',28.17],['2019-09-02',28.20],['2019-09-02',28.05],['2019-09-02',27.97],['2019-09-03',27.97],['2019-09-03',27.97],['2019-09-03',27.86],['2019-09-03',27.98],['2019-09-03',27.85],['2019-09-03',27.75],['2019-09-03',27.87],['2019-09-03',28.07],['2019-09-03',28.11],['2019-09-04',28.11],['2019-09-04',28.64],['2019-09-04',28.76],['2019-09-04',28.80],['2019-09-04',28.80],['2019-09-04',28.93],['2019-09-04',28.73],['2019-09-04',28.74],['2019-09-04',28.84],['2019-09-04',28.80],['2019-09-04',28.82],['2019-09-05',28.82],['2019-09-05',28.94],['2019-09-07',29.19],['2019-09-09',29.19],['2019-09-09',29.76],['2019-09-11',30.00],['2019-09-11',29.61],['2019-09-13',29.83],['2019-09-15',29.66],['2019-09-16',30.80],['2019-09-16',31.10],['2019-09-16',31.10],['2019-09-17',30.61],['2019-09-18',30.44],['2019-09-18',30.24],['2019-09-18',30.14],['2019-09-20',30.24],['2019-09-22',30.32],['2019-09-23',30.47],['2019-09-25',30.06],['2019-09-25',29.99],['2019-09-25',30.09],['2019-09-26',30.10],['2019-09-26',30.14],['2019-09-26',30.24],['2019-09-26',30.37],['2019-09-27',30.67],['2019-09-27',30.55],['2019-09-27',30.54],['2019-09-27',30.48],['2019-09-27',30.42],['2019-09-28',30.42],['2019-09-29',30.42],['2019-09-30',30.42],['2019-09-30',30.33],['2019-09-30',30.24],['2019-09-30',30.15],['2019-10-01',30.15],['2019-10-01',30.15],['2019-10-01',30.39],['2019-10-01',30.14],['2019-10-01',29.89],['2019-10-01',30.00],['2019-10-02',29.98],['2019-10-02',29.65],['2019-10-02',29.18],['2019-10-02',28.89],['2019-10-02',29.07],['2019-10-03',28.90],['2019-10-03',28.90],['2019-10-03',28.79],['2019-10-03',29.12],['2019-10-04',29.12],['2019-10-04',29.11],['2019-10-04',28.49],['2019-10-04',28.55],['2019-10-05',28.85],['2019-10-06',28.85],['2019-10-07',28.85],['2019-10-07',28.85],['2019-10-07',28.74],['2019-10-07',28.72],['2019-10-07',28.44],['2019-10-07',28.40],['2019-10-08',28.40],['2019-10-08',28.22],['2019-10-09',28.22],['2019-10-09',28.59],['2019-10-09',28.54],['2019-10-09',28.98],['2019-10-09',28.95],['2019-10-10',28.93],['2019-10-10',29.25],['2019-10-10',29.14],['2019-10-10',28.97],['2019-10-10',29.07],['2019-10-11',29.07],['2019-10-11',29.49],['2019-10-11',29.50],['2019-10-11',29.50],['2019-10-12',29.50],['2019-10-13',29.50],['2019-10-14',29.50],['2019-10-14',29.50],['2019-10-14',29.37],['2019-10-14',29.25],['2019-10-14',29.51],['2019-10-14',29.59],['2019-10-14',29.67],['2019-10-15',29.67],['2019-10-15',29.85],['2019-10-15',30.21],['2019-10-15',30.29],['2019-10-15',30.05],['2019-10-16',30.07],['2019-10-16',30.07],['2019-10-16',30.01],['2019-10-16',30.18],['2019-10-16',30.49],['2019-10-17',30.49],['2019-10-17',30.49],['2019-10-17',30.42],['2019-10-17',30.05],['2019-10-17',30.18],['2019-10-17',30.12],['2019-10-17',30.20],['2019-10-18',30.20],['2019-10-18',30.20],['2019-10-18',30.55],['2019-10-18',30.21],['2019-10-18',30.21],['2019-10-18',30.00],['2019-10-18',29.95],['2019-10-19',29.95],['2019-10-20',29.95],['2019-10-21',29.95],['2019-10-21',29.95],['2019-10-21',30.05],['2019-10-21',30.17],['2019-10-21',30.27],['2019-10-21',30.35],['2019-10-22',30.35],['2019-10-22',30.35],['2019-10-22',30.80],['2019-10-22',31.41],['2019-10-22',31.19],['2019-10-23',31.28],['2019-10-23',31.41],['2019-10-24',31.43],['2019-10-24',31.01],['2019-10-24',30.81],['2019-10-24',30.81],['2019-10-25',30.81],['2019-10-25',32.00],['2019-10-25',31.94],['2019-10-25',31.90],['2019-10-25',31.94],['2019-10-25',31.71],['2019-10-26',31.71],['2019-10-27',31.71],['2019-10-28',31.71],['2019-10-28',31.71],['2019-10-28',31.71],['2019-10-28',31.71],['2019-10-28',32.07],['2019-10-29',31.95],['2019-10-29',31.78],['2019-10-29',32.28],['2019-10-29',32.35],['2019-10-29',32.24],['2019-10-30',32.24],['2019-10-30',32.24],['2019-10-30',32.24],['2019-10-30',32.63],['2019-10-31',32.63],['2019-10-31',32.49],['2019-10-31',32.47],['2019-10-31',32.70],['2019-11-01',32.70],['2019-11-01',32.70],['2019-11-01',32.87],['2019-11-01',33.27],['2019-11-01',33.38],['2019-11-01',32.74],['2019-11-02',32.74],['2019-11-03',32.74],['2019-11-04',32.74],['2019-11-04',32.74],['2019-11-04',32.74],['2019-11-04',33.39],['2019-11-06',32.55],['2019-11-06',33.34],['2019-11-06',32.05],['2019-11-07',33.54],['2019-11-09',32.91],['2019-11-11',32.91],['2019-11-13',32.52],['2019-11-14',31.79],['2019-11-16',31.71],['2019-11-18',31.71],['2019-11-19',31.28],['2019-11-20',31.25],['2019-11-22',32.22],['2019-11-27',31.45],['2019-11-28',31.12],['2019-11-28',31.13],['2019-11-29',31.15],['2019-11-29',31.24],['2019-11-30',31.20],['2019-12-01',31.20],['2019-12-02',31.20],['2019-12-02',31.57],['2019-12-02',31.24],['2019-12-02',31.09],['2019-12-03',31.16],['2019-12-03',31.07],['2019-12-04',31.18],['2019-12-05',32.18],['2019-12-09',32.23],['2019-12-10',32.23],['2019-12-10',32.23],['2019-12-10',32.11],['2019-12-10',32.30],['2019-12-10',32.32],['2019-12-11',32.43],['2019-12-11',32.45],['2019-12-11',32.47],['2019-12-11',32.29],['2019-12-11',32.37],['2019-12-12',32.44],['2019-12-12',32.44],['2019-12-12',32.68],['2019-12-12',32.77],['2019-12-12',32.88],['2019-12-12',32.87],['2019-12-13',32.87],['2019-12-13',32.87],['2019-12-13',32.02],['2019-12-13',31.86],['2019-12-13',31.66],['2019-12-13',31.39],['2019-12-13',31.39],['2019-12-13',31.33],['2019-12-14',31.33],['2019-12-15',31.33],['2019-12-16',31.33],['2019-12-16',31.16],['2019-12-16',31.40],['2019-12-16',31.60],['2019-12-16',31.40],['2019-12-16',31.27],['2019-12-17',31.09],['2019-12-17',31.37],['2019-12-17',31.37],['2019-12-17',31.61],['2019-12-17',31.47],['2019-12-17',31.40],['2019-12-18',31.52],['2019-12-18',32.31],['2019-12-19',32.35],['2019-12-19',32.30],['2019-12-19',32.16],['2019-12-19',32.19],['2019-12-19',32.17],['2019-12-19',32.16],['2019-12-19',32.15],['2019-12-20',31.95],['2019-12-20',31.93],['2019-12-20',31.97],['2019-12-20',31.97],['2019-12-21',31.93],['2019-12-22',31.93],['2019-12-23',31.93],['2019-12-23',31.92],['2019-12-23',32.11],['2019-12-23',32.22],['2019-12-23',32.40],['2019-12-24',32.40],['2019-12-26',32.51],['2019-12-26',32.45],['2019-12-26',32.52],['2019-12-26',32.67],['2019-12-27',32.67],['2019-12-27',32.42],['2019-12-27',32.17],['2019-12-28',32.17],['2019-12-29',32.17],['2019-12-30',32.17],['2019-12-30',32.55],['2019-12-30',32.54],['2019-12-30',32.00],['2019-12-31',32.00],['2020-01-01',32.00],['2020-01-01',32.00],['2020-01-02',32.00],['2020-01-02',32.41],['2020-01-02',32.47],['2020-01-02',32.44],['2020-01-02',32.60],['2020-01-03',32.80],['2020-01-03',32.68],['2020-01-03',32.54],['2020-01-03',31.99],['2020-01-04',31.99],['2020-01-05',31.99],['2020-01-06',31.99],['2020-01-06',31.99],['2020-01-06',31.99],['2020-01-06',32.64],['2020-01-06',33.02],['2020-01-06',32.99],['2020-01-06',32.98],['2020-01-06',33.01],['2020-01-07',32.65],['2020-01-09',31.94],['2020-01-11',32.10],['2020-01-13',32.10],['2020-01-13',32.02],['2020-01-14',31.61],['2020-01-16',31.25],['2020-01-18',31.85],['2020-01-20',32.00],['2020-01-21',31.19],['2020-01-22',31.08],['2020-01-24',31.04],['2020-01-26',31.11],['2020-01-27',29.89],['2020-01-27',30.15],['2020-01-27',30.05],['2020-01-27',30.01],['2020-01-27',29.80],['2020-01-28',29.80],['2020-01-28',30.51],['2020-01-28',30.50],['2020-01-28',30.57],['2020-01-28',30.55],['2020-01-28',30.60],['2020-01-28',30.75],['2020-01-28',30.50],['2020-01-29',30.50],['2020-01-29',30.66],['2020-01-29',30.48],['2020-01-29',30.53],['2020-01-29',30.36],['2020-01-30',30.36],['2020-01-30',29.92],['2020-01-30',30.11],['2020-01-30',30.17],['2020-01-30',30.99],['2020-01-31',30.99],['2020-01-31',30.99],['2020-01-31',30.99],['2020-01-31',30.21],['2020-01-31',30.20],['2020-01-31',30.21],['2020-01-31',30.25],['2020-01-31',30.35],['2020-02-01',30.35],['2020-02-01',30.35],['2020-02-02',30.35],['2020-02-03',30.35],['2020-02-03',30.35],['2020-02-03',30.35],['2020-02-03',30.43],['2020-02-03',30.47],['2020-02-03',30.34],['2020-02-03',30.35],['2020-02-03',30.20],['2020-02-03',30.24],['2020-02-03',30.01],['2020-02-03',30.01],['2020-02-04',30.01],['2020-02-04',30.74],['2020-02-04',30.59],['2020-02-04',30.83],['2020-02-04',30.80],['2020-02-04',31.09],['2020-02-04',30.97],['2020-02-04',30.79],['2020-02-05',30.75],['2020-02-05',30.75],['2020-02-05',31.21],['2020-02-05',31.00],['2020-02-05',30.98],['2020-02-05',30.70],['2020-02-05',30.48],['2020-02-06',30.48],['2020-02-06',31.03],['2020-02-06',31.85],['2020-02-06',31.58],['2020-02-06',31.08],['2020-02-06',31.07],['2020-02-06',31.30],['2020-02-06',31.30],['2020-02-06',31.30],['2020-02-07',31.30],['2020-02-07',30.99],['2020-02-07',31.49],['2020-02-07',31.62],['2020-02-07',31.72],['2020-02-07',31.62],['2020-02-07',31.46],['2020-02-07',31.46],['2020-02-07',31.46],['2020-02-08',31.46],['2020-02-09',31.46],['2020-02-10',31.46],['2020-02-10',31.46],['2020-02-10',31.39],['2020-02-10',30.94],['2020-02-10',31.05],['2020-02-10',31.33],['2020-02-10',31.34],['2020-02-10',31.58],['2020-02-10',31.58],['2020-02-11',31.58],['2020-02-11',31.68],['2020-02-11',31.97],['2020-02-11',32.01],['2020-02-11',32.19],['2020-02-12',32.01],['2020-02-12',32.43],['2020-02-12',32.44],['2020-02-12',32.60],['2020-02-12',32.58],['2020-02-12',32.60],['2020-02-12',32.55],['2020-02-12',32.55],['2020-02-12',32.55],['2020-02-13',32.55],['2020-02-13',32.37],['2020-02-13',32.06],['2020-02-13',31.79],['2020-02-13',31.78],['2020-02-13',31.93],['2020-02-14',31.93],['2020-02-14',31.93],['2020-02-14',31.98],['2020-02-14',31.73],['2020-02-14',31.59],['2020-02-14',31.52],['2020-02-14',31.62],['2020-02-14',31.62],['2020-02-14',31.62],['2020-02-15',31.62],['2020-02-16',31.62],['2020-02-17',31.62],['2020-02-17',31.62],['2020-02-17',31.88],['2020-02-17',31.86],['2020-02-17',31.77],['2020-02-17',31.71],['2020-02-17',31.70],['2020-02-17',31.70],['2020-02-17',31.70],['2020-02-18',31.70],['2020-02-18',31.30],['2020-02-18',31.56],['2020-02-18',31.54],['2020-02-18',31.60],['2020-02-18',31.89],['2020-02-18',31.94],['2020-02-18',31.94],['2020-02-19',31.94],['2020-02-19',31.94],['2020-02-19',31.94],['2020-02-19',31.94],['2020-02-19',32.32],['2020-02-19',32.44],['2020-02-19',32.50],['2020-02-19',32.57],['2020-02-19',32.57],['2020-02-19',32.57],['2020-02-20',32.57],['2020-02-20',32.27],['2020-02-20',32.65],['2020-02-20',32.64],['2020-02-20',31.90],['2020-02-20',32.00],['2020-02-20',31.75],['2020-02-20',31.75],['2020-02-21',31.75],['2020-02-21',31.75],['2020-02-21',31.22],['2020-02-21',30.59],['2020-02-23',30.85],['2020-02-25',30.85],['2020-02-26',27.80],['2020-02-28',26.83],['2020-03-01',27.15],['2020-03-03',28.03],['2020-03-03',28.05],['2020-03-05',27.72],['2020-03-06',25.47],['2020-03-06',24.87],['2020-03-06',24.80],['2020-03-06',24.86],['2020-03-06',25.04],['2020-03-06',25.05],['2020-03-06',24.35],['2020-03-06',24.21],['2020-03-06',24.53],['2020-03-06',24.30],['2020-03-06',23.79],['2020-03-06',24.06],['2020-03-06',24.06],['2020-03-06',24.06],['2020-03-06',24.06],['2020-03-06',24.06],['2020-03-06',24.06],['2020-03-07',24.06],['2020-03-08',24.06],['2020-03-09',24.06],['2020-03-09',24.06],['2020-03-09',24.06],['2020-03-09',18.14],['2020-03-09',19.19],['2020-03-09',19.03],['2020-03-09',18.74],['2020-03-09',18.42],['2020-03-09',17.67],['2020-03-09',17.17],['2020-03-09',16.78],['2020-03-09',16.49],['2020-03-09',16.92],['2020-03-09',16.92],['2020-03-09',16.92],['2020-03-09',16.92],['2020-03-10',16.92],['2020-03-10',16.92],['2020-03-10',16.92],['2020-03-10',18.31],['2020-03-10',17.81],['2020-03-10',17.54],['2020-03-10',17.79],['2020-03-10',18.12],['2020-03-10',18.51],['2020-03-10',18.61],['2020-03-10',18.36],['2020-03-10',18.36],['2020-03-10',18.36],['2020-03-11',18.36],['2020-03-11',18.36],['2020-03-11',18.36],['2020-03-11',17.72],['2020-03-11',17.54],['2020-03-11',17.51],['2020-03-11',16.91],['2020-03-11',16.69],['2020-03-11',16.01],['2020-03-11',16.02],['2020-03-11',16.37],['2020-03-11',16.37],['2020-03-11',16.37],['2020-03-11',16.37],['2020-03-11',16.37],['2020-03-11',16.37],['2020-03-12',16.37],['2020-03-12',16.37],['2020-03-12',16.37],['2020-03-12',13.63],['2020-03-12',13.33],['2020-03-12',12.91],['2020-03-12',12.88],['2020-03-12',12.03],['2020-03-12',13.42],['2020-03-12',12.88],['2020-03-12',12.99],['2020-03-12',13.00],['2020-03-12',12.92],['2020-03-12',12.92],['2020-03-12',12.92],['2020-03-13',12.92],['2020-03-13',12.92],['2020-03-13',14.39],['2020-03-13',13.82],['2020-03-13',13.29],['2020-03-13',14.31],['2020-03-13',14.56],['2020-03-13',14.56],['2020-03-13',15.04],['2020-03-13',15.86],['2020-03-13',15.86],['2020-03-13',15.86],['2020-03-13',15.86],['2020-03-13',15.86],['2020-03-13',15.86],['2020-03-14',15.86],['2020-03-15',15.86],['2020-03-16',15.86],['2020-03-16',15.86],['2020-03-16',15.86],['2020-03-16',15.86],['2020-03-16',15.86],['2020-03-16',15.86],['2020-03-16',14.45],['2020-03-16',14.00],['2020-03-16',13.66],['2020-03-16',13.52],['2020-03-16',13.52],['2020-03-16',13.65],['2020-03-16',13.43],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-16',13.13],['2020-03-17',13.13],['2020-03-17',13.13],['2020-03-17',13.13],['2020-03-17',13.33],['2020-03-17',13.58],['2020-03-17',13.80],['2020-03-17',13.55],['2020-03-17',13.22],['2020-03-17',13.08],['2020-03-17',13.11],['2020-03-17',13.10],['2020-03-17',13.08],['2020-03-17',13.08],['2020-03-17',13.08],['2020-03-17',13.08],['2020-03-17',13.08],['2020-03-18',13.08],['2020-03-18',13.08],['2020-03-18',13.08],['2020-03-18',11.99],['2020-03-18',11.65],['2020-03-18',11.30],['2020-03-18',11.17],['2020-03-18',10.65],['2020-03-18',10.59],['2020-03-18',10.95],['2020-03-18',11.05],['2020-03-18',11.05],['2020-03-18',11.05],['2020-03-18',11.05],['2020-03-18',11.05],['2020-03-18',11.05],['2020-03-19',11.05],['2020-03-19',11.05],['2020-03-19',11.05],['2020-03-19',11.20],['2020-03-19',10.74],['2020-03-19',10.96],['2020-03-19',11.78],['2020-03-19',11.53],['2020-03-19',12.09],['2020-03-19',12.39],['2020-03-19',12.90],['2020-03-19',12.59],['2020-03-19',12.74],['2020-03-19',12.45],['2020-03-19',12.45],['2020-03-19',12.45],['2020-03-19',12.45],['2020-03-19',12.45],['2020-03-20',12.45],['2020-03-20',13.33],['2020-03-20',12.22],['2020-03-20',12.22],['2020-03-22',12.22],['2020-03-23',12.01],['2020-03-24',13.44],['2020-03-25',13.91],['2020-03-26',14.55],['2020-03-26',14.44],['2020-03-26',14.24],['2020-03-27',13.45],['2020-03-27',13.29],['2020-03-31',13.71],['2020-03-31',14.01],['2020-04-01',14.19],['2020-04-02',15.16],['2020-04-02',15.73],['2020-04-03',15.07],['2020-04-04',15.32],['2020-04-05',15.32],['2020-04-06',15.32],['2020-04-07',16.15],['2020-04-08',16.56],['2020-04-09',17.50]]


São muitos dados; talvez por isso o gráfico tenha louqueado. Se bem que o gráfico deveria de qualquer forma funcionar.

Fiz teste com outro código com poucos códigos, veja no anexo que ficou como esperado.

Se for esse o problema, a solução será limitar os dados. Preciso pensar em como fazer isso.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 09 Abr 2020 15:58
por ANDRIL
O gráfico é para ser um resumo de um relatório, tem que ser compacto, com certeza se colocar muitos dados o resultado não será o esperado. Até porque há um limite para visual das informações que o gráfico pode exibir.

Tente totalizar ou fazer a média por data ou alguma forma a reduzir bastante seus dados. Caso seja inevitável exibir tudo, terá que criar uma paginação para a cada página carregar os dados correspondentes.

Até+

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 12 Abr 2020 01:26
por cjp
Estou tentando fazer a mesma coisa com uma outra tabela.
Mesmo com poucos dados, a tabela não está aparecendo. Pode me ajudar?

Segue o código:

    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
    <title>Cadastro realizado com sucesso</title>
    </head>
    <body>
    <?php
    // RECEBENDO OS DADOS PREENCHIDOS DO FORMULÁRIO !
    $peso= $_POST ["peso"];
   
   
   include("conexao.php");

   conectk("","");
     
    $query = "INSERT INTO peso(data,hora,peso) VALUES ('".date('Y-m-d')."','".date('H').":".date('i').":".date('s')."',".$peso.")";
    if (mysql_query($query))
       {echo "Cadastro realizado com sucesso";}
   else
      {echo "Erro";
       echo "<br>";
        echo mysql_error();
       echo "<br>";
      echo $query;
      }
      

$dthoje = date('Y')."-".date('m')."-".date('d');
$dt = date('Y-m-d', strtotime("-7 days",strtotime($dthoje)));

       echo "<br>";
       echo "<br>";
echo $dt;
       echo "<br>";

$sql = "SELECT data,peso FROM peso where data>'".$dt."'";
       echo "<br>";
echo $sql;
       echo "<br>";
$rs=mysql_query($sql);

$obj = "['2020-01-01', 0],";
if (mysql_num_rows($rs)==0){
   $obj.="['Nenhuma data', 0],";
}else{
   while ($l = mysql_fetch_array($rs)){
      $obj.="['".$l['data']."',".$l['peso']."],";
   }
}
$obj = "[".substr($obj,0,strlen($obj)-1)."]";

echo $obj;

      
?>
      

  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);
    
      function drawChart() {
        var data = google.visualization.arrayToDataTable(<? echo( $obj ) ?>);
        var options = {
          title: 'Histórico de peso',
          curveType: 'function',
        };

        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>

      
    <?php
      
echo '<form action="prior2.php"';
// echo "width='59%' style='height:200px;'>";
echo "<br>";
echo "<br>";
echo "<input size='45' style='font-size:180px' type='submit' id='Voltar' value='Voltar ao inicio'>";
echo "</form>";

echo "<br>";
echo "<br>";
echo "<br>";

      
    ?>
    </body>
    </html>
   
   <?

?>


Está resultando assim:

2020-04-12

2020-04-05

SELECT data,peso FROM peso where data>'2020-04-05'
[['2020-01-01', 0],['2020-04-06',86.8],['2020-04-08',87.3],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-10',83.1],['2020-04-11',87.5],['2020-04-12',83.1],['2020-04-12',83.1]]


Mas o gráfico não aparece.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 13 Abr 2020 09:01
por ANDRIL
O problema que no seu código está definindo a coluna (cabeçalho) como numérica. Veja na sua linha 49
errado
$obj = "['2020-01-01', 0],";


correto
$obj = "['Data','Cotação'],";


Até+

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 13 Abr 2020 10:51
por cjp
Verdade. Achei que devia ser assim por o campo ser numérico na tabela.
Agora deu certo. Muito obrigado.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 14 Abr 2020 00:35
por cjp
Por favor, mais uma ajuda:

   while ($l = mysql_fetch_array($rs))
   {
      if($1['data']>$dtult)
       {
        $obj.="['".$l['data']."',".$l['peso']."],";
      $dtult=$1['data'];
      }
   }


Neste código, está dando o seguinte erro na linha do if:

Parse error: syntax error, unexpected '1' (T_LNUMBER), expecting variable (T_VARIABLE) or '$' in /home/inaciocarvalho/www/php/peso90d.php on line 135


Não estou entendendo o erro. Pelo que entendi do código que vc havia me passado, $1['data'] deveria retornar o campo data da tabela.

Então, não estaria certo $1['data']>$dtult?

Lembrando que $dtult está definido anteriormente assim:

$dthoje = date('Y')."-".date('m')."-".date('d');
$dt = date('Y-m-d', strtotime("-90 days",strtotime($dthoje)));
$dtult = $dt;

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 14 Abr 2020 07:32
por ANDRIL
while ($l = mysql_fetch_array($rs))
{
if($1['data']>$dtult)
{
$obj.="['".$l['data']."',".$l['peso']."],";
$dtult=$1['data'];
}
}

Erro de digitação! Trocou a letra 'L' pelo '1' . Corrija
$dtult=$l['data'];

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 14 Abr 2020 10:57
por cjp
Verdade, que vacilo! Muito obrigado.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 15 Abr 2020 00:48
por cjp
Desculpe, mas vou precisar incomodar novamente.
Neste outro código:

$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='".$cd."' and compvenda=0";
$rs=mysql_query($sql);


$dthoje = date('Y')."-".date('m')."-".date('d');
$dt = date('Y-m-d', strtotime("-120 days",strtotime($dthoje)));
$dtult = $dt;

       echo "<br>";
       echo "<br>";
$rs=mysql_query($sql);

$obj = "['2020-01-01', '0'],";
if (mysql_num_rows($rs)==0)
{
   $obj.="['Nenhuma data', 0],";
}
else
{
   while ($l = mysql_fetch_array($rs))
   {

      if($l['dtcotacao']>$dtult OR $l['dtcotacao']==$dt)
       {
        $obj.="['".$l['dtcotacao']."',".$l['cotacao']."],";
        $dtult = date('Y-m-d', strtotime("+15 days",strtotime($l['data'])));
      }
   }
}
$obj = "[".substr($obj,0,strlen($obj)-1)."]";

echo $obj;



Vejo dois problemas:

1) não está aparecendo o gráfico, talvez porque o número de dados esteja muito grande (o que leva ao segundo problema);

2) o $obj está assim:

[['2020-01-01', '0'],['2019-12-17',29.41],['2019-12-17',29.77],['2019-12-19',30.54],['2019-12-20',30.10],['2019-12-22',30.26],['2019-12-23',30.19],['2019-12-26',30.62],['2019-12-26',30.80],['2019-12-28',30.52],['2019-12-30',30.52],['2020-01-01',30.18],['2020-01-03',30.70],['2020-01-03',30.93],['2020-01-05',30.45],['2020-01-06',30.90],['2020-01-08',30.69],['2020-01-10',30.40],['2020-01-10',30.38],['2020-01-12',30.27],['2020-01-13',30.26],['2020-01-14',29.90],['2020-01-16',29.65],['2020-01-18',29.85],['2020-01-20',29.95],['2020-01-22',29.62],['2020-01-22',29.51],['2020-01-22',29.56],['2020-01-22',29.43],['2020-01-22',29.43],['2020-01-22',29.49],['2020-01-23',29.29],['2020-01-23',29.29],['2020-01-23',28.95],['2020-01-23',29.42],['2020-01-23',29.42],['2020-01-23',29.48],['2020-01-23',29.60],['2020-01-24',29.60],['2020-01-24',29.60],['2020-01-24',29.58],['2020-01-24',29.26],['2020-01-24',29.38],['2020-01-24',29.30],['2020-01-25',29.30],['2020-01-26',29.30],['2020-01-27',28.26],['2020-01-27',28.32],['2020-01-27',28.19],['2020-01-27',28.15],['2020-01-27',28.03],['2020-01-28',28.03],['2020-01-28',28.72],['2020-01-28',28.71],['2020-01-28',28.76],['2020-01-28',28.79],['2020-01-28',28.84],['2020-01-28',29.01],['2020-01-28',28.80],['2020-01-29',28.80],['2020-01-29',28.89],['2020-01-29',28.83],['2020-01-29',28.91],['2020-01-29',28.85],['2020-01-30',28.85],['2020-01-30',28.35],['2020-01-30',28.39],['2020-01-30',28.47],['2020-01-30',28.94],['2020-01-31',28.94],['2020-01-31',28.94],['2020-01-31',28.94],['2020-01-31',28.48],['2020-01-31',28.46],['2020-01-31',28.39],['2020-01-31',28.46],['2020-02-01',28.45],['2020-02-01',28.45],['2020-02-02',28.45],['2020-02-03',28.45],['2020-02-03',28.45],['2020-02-03',28.45],['2020-02-03',28.56],['2020-02-03',28.60],['2020-02-03',28.43],['2020-02-03',28.45],['2020-02-03',28.27],['2020-02-03',28.27],['2020-02-03',28.18],['2020-02-03',28.18],['2020-02-04',28.18],['2020-02-04',28.65],['2020-02-04',28.71],['2020-02-04',28.68],['2020-02-04',29.01],['2020-02-04',28.90],['2020-02-04',28.78],['2020-02-05',28.63],['2020-02-05',28.63],['2020-02-05',29.10],['2020-02-05',28.87],['2020-02-05',28.88],['2020-02-05',28.70],['2020-02-05',28.67],['2020-02-05',28.39],['2020-02-06',28.39],['2020-02-06',28.68],['2020-02-06',29.32],['2020-02-06',29.28],['2020-02-06',28.76],['2020-02-06',28.96],['2020-02-06',29.18],['2020-02-06',29.18],['2020-02-06',29.18],['2020-02-07',29.18],['2020-02-07',28.94],['2020-02-07',29.13],['2020-02-07',29.24],['2020-02-07',29.09],['2020-02-07',28.93],['2020-02-07',28.93],['2020-02-07',28.93],['2020-02-08',28.93],['2020-02-09',28.93],['2020-02-10',28.93],['2020-02-10',28.93],['2020-02-10',28.90],['2020-02-10',28.70],['2020-02-10',28.83],['2020-02-10',29.02],['2020-02-10',29.00],['2020-02-10',29.13],['2020-02-10',29.13],['2020-02-11',29.13],['2020-02-11',29.32],['2020-02-11',29.48],['2020-02-11',29.50],['2020-02-11',29.56],['2020-02-12',29.48],['2020-02-12',29.84],['2020-02-12',29.85],['2020-02-12',30.07],['2020-02-12',30.07],['2020-02-12',30.18],['2020-02-12',30.15],['2020-02-12',30.13],['2020-02-12',30.13],['2020-02-13',30.13],['2020-02-13',30.02],['2020-02-13',29.91],['2020-02-13',29.72],['2020-02-13',29.72],['2020-02-14',29.72],['2020-02-14',29.72],['2020-02-14',29.91],['2020-02-14',29.91],['2020-02-16',29.42],['2020-02-18',29.36],['2020-02-20',30.55],['2020-02-22',29.14],['2020-02-24',29.14],['2020-02-24',29.14],['2020-02-26',29.14],['2020-02-26',26.26],['2020-02-26',26.27],['2020-02-28',25.30],['2020-03-01',25.34],['2020-03-02',26.64],['2020-03-02',26.64],['2020-03-02',26.62],['2020-03-02',26.31],['2020-03-02',26.40],['2020-03-02',26.43],['2020-03-02',26.53],['2020-03-02',26.53],['2020-03-02',26.53],['2020-03-02',26.53],['2020-03-03',26.53],['2020-03-03',26.53],['2020-03-03',26.53],['2020-03-03',26.62],['2020-03-03',26.60],['2020-03-03',27.10],['2020-03-03',26.36],['2020-03-03',26.23],['2020-03-03',25.94],['2020-03-03',26.12],['2020-03-03',26.05],['2020-03-03',26.05],['2020-03-03',26.05],['2020-03-04',26.05],['2020-03-04',26.05],['2020-03-04',26.68],['2020-03-04',26.66],['2020-03-04',26.55],['2020-03-04',26.33],['2020-03-04',26.59],['2020-03-04',26.66],['2020-03-04',26.66],['2020-03-04',26.73],['2020-03-04',26.79],['2020-03-04',26.86],['2020-03-04',26.89],['2020-03-04',26.89],['2020-03-04',26.89],['2020-03-04',26.89],['2020-03-04',26.89],['2020-03-05',26.89],['2020-03-05',26.89],['2020-03-05',26.89],['2020-03-05',26.55],['2020-03-05',26.51],['2020-03-05',26.40],['2020-03-05',26.16],['2020-03-05',26.08],['2020-03-05',25.94],['2020-03-05',25.27],['2020-03-05',25.29],['2020-03-07',22.83],['2020-03-09',22.83],['2020-03-09',18.01],['2020-03-09',15.92],['2020-03-10',17.63],['2020-03-11',16.76],['2020-03-13',13.60],['2020-03-15',15.40],['2020-03-17',13.09],['2020-03-19',11.29],['2020-03-19',11.42],['2020-03-19',12.89],['2020-03-20',13.27],['2020-03-23',11.57],['2020-03-25',13.58],['2020-03-26',14.06],['2020-03-31',13.80],['2020-03-31',13.90],['2020-04-01',14.25],['2020-04-02',15.17],['2020-04-02',15.68],['2020-04-04',15.34],['2020-04-06',15.72],['2020-04-08',16.40],['2020-04-09',16.76],['2020-04-11',16.82],['2020-04-13',16.73],['2020-04-14',16.72]]


Veja que ele não está pulando corretamente os 15 dias. Gostaria de entender o que estou fazendo errado.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 17 Abr 2020 09:36
por ANDRIL
Não entendi o que voce esta tentando montar, veja:

if($l['dtcotacao']>$dtult OR $l['dtcotacao']==$dt)
{
$obj.="['".$l['dtcotacao']."',".$l['cotacao']."],";
$dtult = date('Y-m-d', strtotime("+15 days",strtotime($l['data']))); #--de onde veio este campo???
}


mude para
$dtult = date('Y-m-d', strtotime("+15 days",strtotime($dtult)));

e veja se dá o resultado esperado.

A grande quantidade de dados passada ao gráfico pode ser sim um dos motivos pelo qual não é exibido. Consulte sobre os limites do gráfico no manual.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 17 Abr 2020 11:45
por cjp
A ideia é pegar dados de 15 em 15 dias, para fazer um gráfico enxuto.
Vi que realmente estava errada a linha
$dtult = date('Y-m-d', strtotime("+15 days",strtotime($l['data'])));

porque é pra ser dtcotacao no lugar de data.
Fiz assim:
$sql = "SELECT dtcotacao,cotacao FROM acoes where codigo='".$cd."' and compvenda=0";
$rs=mysql_query($sql);


$dthoje = date('Y')."-".date('m')."-".date('d');
$dt = date('Y-m-d', strtotime("-120 days",strtotime($dthoje)));
$dtult = $dt;

       echo "<br>";
       echo "<br>";
$rs=mysql_query($sql);

$obj = "['2020-01-01', '0'],";
if (mysql_num_rows($rs)==0)
{
   $obj.="['Nenhuma data', 0],";
}
else
{
   while ($l = mysql_fetch_array($rs))
   {

      if($l['dtcotacao']>$dtult OR $l['dtcotacao']==$dt)
       {
        $obj.="['".$l['dtcotacao']."',".$l['cotacao']."],";
        $dtult = date('Y-m-d', strtotime("+15 days",strtotime($l['dtcotacao'])));
      }
   }
}
$obj = "[".substr($obj,0,strlen($obj)-1)."]";

echo $obj;



Os dados agora aparecem corretos em $obj:

[['2020-01-01', '0'],['2019-12-19',30.54],['2020-01-05',30.45],['2020-01-22',29.62],['2020-02-07',29.18],['2020-02-24',29.14],['2020-03-11',16.76],['2020-03-31',13.80],['2020-04-16',15.68]]


Mas estranhamente, ainda assim o gráfico não aparece.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 17 Abr 2020 16:12
por ANDRIL
Se não aparece deve ser algo na parte do código do javascritp. Testei este $obj aqui e montou o gráfico.

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 17 Abr 2020 17:20
por cjp
Mas eu não mexi em nada no código java (nem saberia mexer). Veja:

  <html>
  <head>
    <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <script type="text/javascript">
      google.charts.load('current', {'packages':['corechart']});
      google.charts.setOnLoadCallback(drawChart);
    
      function drawChart() {
        var data = google.visualization.arrayToDataTable(<? echo( $obj ) ?>);
        var options = {
          title: 'Cotações de '<? echo( $cd ) ?>,
          curveType: 'function',
        };

        var chart = new google.visualization.LineChart(document.getElementById('curve_chart'));

        chart.draw(data, options);
      }
    </script>
  </head>
  <body>
    <div id="curve_chart" style="width: 900px; height: 500px"></div>
  </body>
</html>



Esse mesmo código funciona nas outras páginas que eu fiz.

Aí funcionou exatamente assim como está no meu?

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 17 Abr 2020 18:05
por ANDRIL
Isso pode ser o problema, esta colocando uma string fora das aspas simples.
cjp escreveu: title: 'Cotações de '<? echo( $cd ) ?>,


tente
title: 'Cotações de <? echo( $cd ) ?> ',

PHP: exibir gráfico com dados obtidos de uma tabela MySQL

MensagemEnviado: 18 Abr 2020 01:07
por cjp
De fato, assim funcionou.
Muito obrigado.