Advertisement
Rodrigo12

grafico

Oct 19th, 2019
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.34 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html>
  3. <head>
  4. </head>
  5.  
  6. <script src="https://cdn.plot.ly/plotly-latest.min.js"></script>
  7.  
  8.  
  9. <body>
  10. <div clas="container">
  11. <div class="row">
  12. <div class="col-sm-12">
  13. <div class="panel panel-primary">
  14. <div class="panel panel-heading">
  15. grafica de barras
  16. </div>
  17. </div>
  18. </div>
  19. </div>
  20. </div>
  21.  
  22. <script> requiere_once "conexion.js";
  23.  
  24. conexion = conexion();
  25. sql = "SELECT fechaVenta, montoVenta from ventas";
  26. result = mysqli_query(conexion, sql);
  27. valoresY = array();
  28. valoresX = array();
  29.  
  30. while(ver = mysqli_fetch_row(result)){
  31. valoresY[] = ver[1];
  32. valoresX[] = ver[0];
  33. }
  34.  
  35. datosX = JSON_encode(valoresX);
  36. datosY = JSON_encode(valoresY);
  37.  
  38. </script>
  39.  
  40. <div id="graficabarr"></div>
  41.  
  42. <script type="text/javascript">
  43.  
  44. function crearCadenabarr(json){
  45. var parsed = JSON.parsed(json);
  46. var arr = [];
  47. for(var x in parsed){
  48. arr.push(parsed[x]);
  49. }
  50. return arr;
  51. }
  52. </script>
  53.  
  54. <script type="text/javascript">
  55.  
  56. datosX= crearCadenabarr(datosX)
  57. datosY= crearCadenabarr(datosY)
  58. var data = [
  59. {
  60. x: datosX,
  61. y: datosY,
  62. type: 'bar'
  63. }
  64. ];
  65.  
  66. Plotly.newPlot('graficabarr', data);
  67. </script>
  68. </body>
  69. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement