graficas con nodejs
Publicado por Rodrigo (3 intervenciones) el 07/10/2019 01:00:13
quiero hacer un gráfico estadístico con chartjs usando una base de datos mysql
¿alguien sabe como?
¿alguien sabe como?
Valora esta pregunta


0
<div class="container text-center my-auto">
<h1 class="mb-1"> balance</h1>
</div>
<div class= "col-md-7">
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.bundle.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.bundle.min.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.js"></script>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.min.css" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0-rc.1/Chart.min.js"></script>
</head>
<body>
<canvas id="myChart"></canvas>
<script>
var ctx = document.getElementById('myChart');
var myChart = new Chart(ctx, {
type: 'line',
data: {
labels: [
var pruebas = await pool.query("SELECT * FROM pruebas");
var result = msqli_query(var conection, var pruebas);
while(var registros = mysqli_fetch_array(var result))
{
req, res => {
res.render();
});
}
],
datasets: [{
label: '# de productos1',
data: [655, 100, 156],
backgroundColor: [
'rgba(255, 99, 132, 0.2)',
'rgba(54, 162, 235, 0.2)',
'rgba(255, 159, 64, 0.2)'
],
borderColor: [
'rgba(255, 99, 132, 1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 159, 64, 1)'
],
},
{
label: '# de productos2',
data: [654, 140, 456],
backgroundColor: [
'rgba(2, 70, 252, 0.2)',
'rgba(0, 0, 0, 0.2)',
'rgba(138, 0, 253, 0.2)'
],
borderColor: [
'rgba(255, 99, 132, 1)',
'rgba(54, 162, 235, 1)',
'rgba(255, 159, 64, 1)'
]
}]
},
options: {
scales: {
yAxes: [{
ticks: {
beginAtZero: true
}
}]
}
}
});
</script>
</div>
</body>
</html>