this is my index.php code
<?php
include("conexion.php");
$region[0]="CENTRO";
$region[1]="LIMA";
$region[2]="SUR";
$tipo_alarma[0]="Energía";
$tipo_alarma[1]="Telecom";
$estado[0]="En Curso";
$estado[1]="Pendiente";
$estado[2]="Resuelto";
$colorestado[0]="#7FFF00";
$colorestado[1]="#B22222";
$colorestado[2]="#4B0082";
for ($i=0; $i <=2 ; $i++) {
for ($k=1; $k <=4 ; $k++) {
$acum=$con->query("SELECT count(incidencia) as x FROM registro_tecno where (region='".$region[$i]."' and semana=".$k." ) ");
while($rg= mysqli_fetch_array($acum, MYSQLI_ASSOC))
{
$ince= $rg["x"];
}
$s[$i][$k]=$ince;
$id[$i][$k]=$region[$i].$k;
/* echo "<br>".$region[$i];
echo ", ID: ".$id[$i][$k].", ";
echo ", semana: ".$k.", ";
echo "total incidencia :".$s[$i][$k]."<br>"; */
}
}
for ($i=0; $i <=2 ; $i++) {
for ($j=1; $j <=4 ; $j++) {
for ($k=0; $k <=2 ; $k++) {
$acum=$con->query("SELECT count(estado) as xx FROM registro_tecno where (region='".$region[$i]."' and semana=".$j." and estado='".$estado[$k]."' )");
while($rg= mysqli_fetch_array($acum, MYSQLI_ASSOC))
{
$esta[$i][$j][$k]= $rg["xx"];
/*echo "<br>".$estado[$k]."= ".$esta[$i][$j][$k];*/
}
}
}
}
?>
<!DOCTYPE HTML>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Highcharts Example</title>
<script src="https://code.highcharts.com/highcharts-3d.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.8.2/jquery.min.js"></script>
<script src="http://code.highcharts.com/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/drilldown.js"></script>
<script>
$(function () {
(function (H) {
//For X-axis labels
H.wrap(H.Point.prototype, 'init', function (proceed, series, options, x) {
var point = proceed.call(this, series, options, x),
chart = series.chart,
tick = series.xAxis && series.xAxis.ticks[x],
tickLabel = tick && tick.label;
//console.log("series");
//console.log(series);
if (point.drilldown) {
if (tickLabel) {
if (!tickLabel._basicStyle) {
tickLabel._basicStyle = tickLabel.element.getAttribute('style');
}
tickLabel.addClass('highcharts-drilldown-axis-label') .css({
'text-decoration': 'none',
'font-weight': 'normal',
'cursor': 'auto'
}).on('click', function () {
if (point.doDrilldown) {
return false;
}
});//remove this "on" block to make axis labels clickable
}
}
else if (tickLabel && tickLabel._basicStyle)
{
}
return point;
});
})(Highcharts);
// Create the chart
$('#container').highcharts({
chart: {
type: 'column'
},
title: {
text: 'Basic drilldown'
},
xAxis: {
type: 'category'
},
plotOptions: {
column: {
stacking: 'bold',
dataLabels: {
enabled: true,
color: (Highcharts.theme && Highcharts.theme.dataLabelsColor) || 'white'
}
}
},
series: [
<?php for ($j=0; $j <=2 ; $j++) { ?>
{
name: <?php echo "'".$region[$j]."',"; ?>
data: [
<?php for ($i=1; $i <=4 ; $i++) { ?>
{
name: <?php echo "'Semana ".$i."',"; ?>
y: <?php echo $s[$j][$i].","; ?>
drilldown: <?php echo "'".$id[$j][$i]."',"; ?>
},
<?php } ?>
]
},
<?php } ?>
],
drilldown: {
series: [
<?php for ($i=0; $i <=2 ; $i++) {
for ($j=1; $j <=4 ; $j++) { ?>
{
type: 'column',
id: <?php echo "'".$id[$i][$j]."',"; ?>
data: [
<?php for ($k=0; $k <=2 ; $k++) {?>
{
name: <?php echo "'".$estado[$k]."',"; ?>
y: <?php echo $esta[$i][$j][$k].","; ?>
color: <?php echo "'".$colorestado[$k]."'"; ?>
},
<?php } ?>
]
},
<?php } } ?>
]
}
})
});
</script>
</head>
<body>
<div id="container" style="min-width: 600px; height: 400px; margin: 0 auto"></div>
</body>
</html>
I'm using HIGHCHARTS graphics, in this case the drilldown type, so the results look like this
then when selecting a frame I will scroll through the drilldown function, and it looks like this:
then my question would be if at the moment of clicking on a picture of this image you can send me to another page with the values taken at that point?