Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <!DOCTYPE html>
- <html>
- <head>
- </head>
- <script src="https://cdn.plot.ly/plotly-latest.min.js"></script>
- <body>
- <div clas="container">
- <div class="row">
- <div class="col-sm-12">
- <div class="panel panel-primary">
- <div class="panel panel-heading">
- grafica de barras
- </div>
- </div>
- </div>
- </div>
- </div>
- <script> requiere_once "conexion.js";
- conexion = conexion();
- sql = "SELECT fechaVenta, montoVenta from ventas";
- result = mysqli_query(conexion, sql);
- valoresY = array();
- valoresX = array();
- while(ver = mysqli_fetch_row(result)){
- valoresY[] = ver[1];
- valoresX[] = ver[0];
- }
- datosX = JSON_encode(valoresX);
- datosY = JSON_encode(valoresY);
- </script>
- <div id="graficabarr"></div>
- <script type="text/javascript">
- function crearCadenabarr(json){
- var parsed = JSON.parsed(json);
- var arr = [];
- for(var x in parsed){
- arr.push(parsed[x]);
- }
- return arr;
- }
- </script>
- <script type="text/javascript">
- datosX= crearCadenabarr(datosX)
- datosY= crearCadenabarr(datosY)
- var data = [
- {
- x: datosX,
- y: datosY,
- type: 'bar'
- }
- ];
- Plotly.newPlot('graficabarr', data);
- </script>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement