-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathindex.php
84 lines (79 loc) · 2.02 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
<?php
include("mysqli.inc.php");
$link = mysqli_connect($cfg_servidor,$cfg_usuario,$cfg_password,$cfg_basephp1);
mysqli_set_charset($link,"utf8");
$sql = "SELECT DISTINCT `departamento`, COUNT(`departamento`) FROM `registro_nacional_de_accidentes_de_transito_formatocsv` GROUP BY `departamento` ORDER BY `departamento` ASC;";
//$_ausentismo_mes = mysqli_query($link,$sql);
$_transito = mysqli_query($link,$sql);
$i=0;
while ( $rows = $_transito->fetch_assoc() ) {
//print_r($rows);//echo "{$row['field']}"; //impresion plana del arreglo que arroja la consulta MYSQL
$data[$i] = $rows;
$i++;
}
//echo "<pre>".print_r($data,true)."</pre>"; //impresion formateada del arreglo que arroja la consulta MYSQL
// [departamento] => ANTIOQUIA
// [COUNT(`departamento`)] => 54701
?>
<html>
<head>
<!-- Load c3.css -->
<link href="c3-0.6.7/c3.css" rel="stylesheet">
<!-- Load d3.js and c3.js -->
<script src="d3/d3.min.js" charset="utf-8"></script>
<script src="c3-0.6.7/c3.min.js"></script>
</head>
<body>
<div id="chart"></div>
<script>
var i;
var chart = c3.generate({
data: {
columns: [
['data1',
//30, 200, 100, 400, 150, 250
<?php
echo $data[0]['COUNT(`departamento`)'].",";
$arr_length = count($data)-1;
for($i=1;$i<$arr_length;$i++)
{
echo $data[$i]['COUNT(`departamento`)'].",";
}
echo $data[$i]['COUNT(`departamento`)'];?>
]
],
types: {
data1: 'bar',
}
},
axis: {
rotated: true,
x: {
tick: {
multiline: false
},
height: 100,
type: 'category',
categories:
[
<?php
echo "'".$data[0]['departamento']."',";
$arr_length = count($data)-1;
for($i=1;$i<$arr_length;$i++)
{
echo "'".$data[$i]['departamento']."',";
}
echo "'".$data[$i]['departamento']."'";?>
]
},
y: {
label: { // ADD
text: 'Número de Eventos',
position: 'outer-middle'
}
}
}
});
</script>
</body>
</html>