morris.js不会从json更新数据

6fe3ivhb  于 2021-09-13  发布在  Java
关注(0)|答案(0)|浏览(248)

我正在尝试使用json使用setdata方法更新morris.js图。在通过控制台显示json时,这看起来不错,但当我执行morris setdata时,它只接受未定义的值​​实际上,图表仍然是空白的

  1. <script>
  2. var MagD = new Morris.Line({
  3. element : 'chart',
  4. data:[<?php echo $chart_data; ?>],
  5. xkey:'hora',
  6. ykeys:['mag'],
  7. labels:['magnitud'],
  8. hideHover:'auto',
  9. stacked:true,
  10. resize: true,
  11. parseTime: false
  12. });
  13. </script>
  14. <script>
  15. $(document).ready(function(){
  16. $('#ActBtn').click(function(){
  17. $("#anoG option:selected").each(function () {
  18. ano = $(this).val();
  19. });
  20. $("#mesG option:selected").each(function () {
  21. mes = $(this).val();
  22. });
  23. $("#diaG option:selected").each(function () {
  24. dia = $(this).val();
  25. $.ajax({
  26. type : 'POST',
  27. dataType:'json',
  28. url : 'getGrafica.php',
  29. data : { mes: mes, ano: ano, dia:dia },
  30. success: function(json){
  31. var nuevaData = JSON.parse(JSON.stringify(json));
  32. console.log(json);
  33. MagD.setData(JSON.parse(JSON.stringify(nuevaData)));
  34. },
  35. error: function(json){
  36. alert("Something went wrong, please refresh");
  37. }
  38. });
  39. });
  40. {
  41. });
  42. });
  43. </script>

我用于post方法的php如下

  1. <?php
  2. $conexion=mysqli_connect('localhost','root','','luz');
  3. $ano = $_POST['ano'];
  4. $mes = $_POST['mes'];
  5. $dia = $_POST['dia'];
  6. $query = "SELECT * FROM sensor WHERE dia = $dia AND mes = $mes AND ano = $ano";
  7. $result = mysqli_query($conexion, $query);
  8. $chart_data = '';
  9. while($row = mysqli_fetch_array($result))
  10. {
  11. $chart_data .= "{ hora:'".$row["hora"]."', mag:".$row["magnitud"]."}, ";
  12. }
  13. $chart_data = substr($chart_data, 0, -2);
  14. $chart_data = json_encode("[".$chart_data."]");
  15. echo($chart_data)
  16. ?>

当我在控制台中检查json对象时,它会给我以下数据

  1. [{ hora:'02:15:30', mag:15.05}, { hora:'02:26:31', mag:15.05}, { hora:'02:27:52',
  2. mag:15.11}, { hora:'02:29:01', mag:15.28}]

然后是价值观​​我的图的属性仍然未定义,但它不会给我带来任何错误

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题