-
Notifications
You must be signed in to change notification settings - Fork 0
/
cursosysedes.php
43 lines (28 loc) · 1.33 KB
/
cursosysedes.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
<?php
$conexion = new mysqli("localhost","root","root","unedeprom",3306);
//____________________Cursos____________________
$strConsulta = "select id, nombre from cursos WHERE estatus ='ABIERTO'";
$result = $conexion->query($strConsulta);
$cboCursos = '<option value="0">SELECCIONE CURSO</option>';
while( $fila = $result->fetch_array() )
{
$cboCursos.='<option value="'.$fila["id"].'">'.$fila["nombre"].'</option>';
}
//echo $cboCursos;
//_______________Sedes Cursos_________________________
if(isset($_POST["idcurso"]))
{
$opciones = '<option value="0">SELECCIONE UNA SEDE</option>';
//$strConsulta = "select id, idcedeprom from sedes where idcurso = ".$_POST["idcurso"];
//$strConsulta = "select s.idcedeprom, c.cedeprom from cedeprom c, sedes s where s.idcedeprom =c.id and idcurso = ".$_POST["idcurso"];
$strConsulta = "select s.idcedeprom, c.cedeprom from cedeprom AS c INNER JOIN sedes AS s ON s.idcedeprom =c.id and s.estatus_sede='ABIERTA' and idcurso = ".$_POST["idcurso"];
$result = $conexion->query($strConsulta);
while( $fila = $result->fetch_array() )
{
$opciones.='<option value="'.$fila["idcedeprom"].'">'.$fila["cedeprom"].'</option>';
}
echo $opciones;
}
//________________________________________
//________________________________________
?>