<?php   header('Access-Control-Allow-Origin: *');

include('../../servidor/conexion.php');
include('../../servidor/funciones.php');

$alumuser1 = "SELECT * FROM spotblalumnos where idAlumno = '".$_GET['alum']."'";
$alumuser2 = mysqli_query($conexion, $alumuser1);
$alumuser3= mysqli_fetch_array($alumuser2);

$centrodeuser1 = "SELECT * FROM spotblcentros where idCentro = '".$alumuser3['intCentro']."'";
$centrodeuser2 = mysqli_query($conexion, $centrodeuser1);
$centrodeuser3= mysqli_fetch_array($centrodeuser2);?>

     <div class="cajatitulopag">
    <table align="center"><tr><td align="center" valign="middle"><img src="http://azamar.es/sportmadness/sportivity/app/sistemaapp/imagenes/iconoclases.png" style="max-height:25px"> </td><td align="center" valign="middle"><strong>Clases de <?php echo $alumuser3['strNombre'] ?> <?php echo $alumuser3['strApellidos'] ?></strong></td></tr></table>

</div>


<?php
 $listaclases1 = "SELECT * FROM spotblinscripcionesalumno where intAlumno = '".$alumuser3['idAlumno']."'";
 $listaclases2 = mysqli_query($conexion, $listaclases1);
while($listaclases3= mysqli_fetch_array($listaclases2)){

$clase1 = "SELECT * FROM spotblclases where idClase = '".$listaclases3['intClase']."'";
$clase2 = mysqli_query($conexion, $clase1);
$clase3= mysqli_fetch_array($clase2);
$grupoed1 = "SELECT * FROM spoopciontblgrupoedades where idGrupo = '".$clase3['intGrupoEdad']."'";
$grupoed2 = mysqli_query($conexion, $grupoed1);
$grupoed3= mysqli_fetch_array($grupoed2);

$entrenauser1 = "SELECT * FROM spotblentrenadores where idEntrenador = '".$clase3['intEntrenador']."'";
$entrenauser2 = mysqli_query($conexion, $entrenauser1);
$entrenauser3= mysqli_fetch_array($entrenauser2);

    ?>

    <a onclick="gotover<?php echo $clase3['idClase'] ?>()">
 <div class="cajamenu">
 <table>
 <tr>
 <td rowspan="2" style="padding-left:0.5em">
<img src="http://azamar.es/sportmadness/sportivity/app/sistemaapp/imagenes/iconoclases.png" style="max-height:45px">
 </td>
<td style="padding-left:1em">
<?php echo $clase3['strNombre'] ?> - <?php echo $grupoed3['strNombre'] ?>
</td>
</tr>
<tr>
<td style="padding-left:1em">
<?php echo $entrenauser3['strNombre'] ?> <?php echo $entrenauser3['strApellidos'] ?>
</td>

</tr>

 </table>
 </div>
 </a>




       <script>
function gotover<?php echo $clase3['idClase'] ?>() {
                        sessionStorage.setItem("varsesionsport", '<?php echo $clase3['idClase'] ?>');
                        location.href = "ver_clase.html";
}

</script>




<?php }?>