function consultaCarrera() { $respuesta = false; $nControl = GetSQLValueString($_POST["nControl"], "text"); $CARNOM = ""; $CALNPE = ""; $conexion = conectaBDSIE(); $consulta = sprintf("select DCARRE.CARNOM, DCALUM.CALNPE from DCARRE INNER JOIN DCALUM ON DCALUM.CARCVE=DCARRE.CARCVE WHERE DCALUM.ALUCTR=%s limit 1", $nControl); $res = mysql_query($consulta); if ($row = mysql_fetch_array($res)) { $respuesta = true; $CARNOM = $row['CARNOM']; $CALNPE = $row['CALNPE']; } $arrayJSON = array('respuesta' => $respuesta, 'CARNOM' => $CARNOM, 'CALNPE' => $CALNPE); print json_encode($arrayJSON); }
<div id="solNuevaMaestro"> <?php require_once '../data/conexion.php'; ?> <div class="row" id="nuevaMaestro"> <h5>Nueva solicitud</h5> <div class="col s12"> <div class="row"> <div class="input-field col s8"> <select id="cmbMateria"> <option value="" disabled selected>Seleccione la materia</option> <?php $conexion = conectaBDSIE(); $consulta = sprintf("select m.MATCVE, m.MATNCO from DMATER m inner join DGRUPO g on m.MATCVE = g.MATCVE where g.PERCVE = 920 and g.PDOCVE ='2161' and g.GRUBAS = ' ' and g.INSNUM > 0"); $res = mysql_query($consulta); while ($row = mysql_fetch_array($res)) { echo '<option value="' . $row["MATCVE"] . '">' . $row["MATNCO"] . '</option>'; } ?> </select> <label>Materia</label> </div> <div class="input-field col s2"> <select id="cmbHoraMat"> <option value="" disabled selected>Seleccione la hora</option> <option value="1">10:00</option> <option value="2">01:00</option> <option value="3">15:00</option> </select> <label>Hora de la materia</label> </div>
function grupo($mat, $per, $pdo, $hor) { $matcve = $mat; $clave = $per; $maestro = claveMaestro($clave); $periodo = $pdo; $n = $hor; $n2 = (string) ($n + 1); $n = (string) $n; $hora = $n . "00" . $n2 . "00"; $conexion = conectaBDSIE(); $consulta = sprintf("select GPOCVE from DGRUPO where MATCVE =%s AND PERCVE=%d AND PDOCVE =%s AND (LUNHRA =%s OR MARHRA =%s OR MIEHRA =%s OR JUEHRA =%s OR VIEHRA =%s)", $matcve, $maestro, $periodo, $hora, $hora, $hora, $hora, $hora); $res = mysql_query($consulta); if ($row = mysql_fetch_array($res)) { return $row["GPOCVE"]; } else { return ""; } }