<!--
/* Coded by Ing. Ulises Morales Ramirez */
-->
<?php
include 'conexion.php';
$sql = "SELECT * FROM Preescolar";
$result1 = $conn->query($sql);
$sql = "SELECT * FROM Primaria";
$result2 = $conn->query($sql);
$sql = "SELECT * FROM Secundaria";
$result3 = $conn->query($sql);
$sql = "SELECT * FROM Media";
$result4 = $conn->query($sql);
$sql = "SELECT * FROM Superior";
$result5 = $conn->query($sql);
/*
if ($result->num_rows > 0) {
// output data of each row
while($row = $result->fetch_assoc()) {
echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
}
} else {
echo "0 results";
}
$conn->close();*/
?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Sin titulo</title>
<link rel="shortcut icon" href="images/cgeo.ico">
<link rel="stylesheet" type="text/css" href="//fonts.googleapis.com/css?family=Lato" />
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css"
integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<link rel="stylesheet" href="https://use.fontawesome.com/releases/v5.6.1/css/all.css"
integrity="sha384-gfdkjb5BdAXd+lj+gudLWI+BXq4IuLW5IT+brZEZsLFm++aCMlF1V92rMkPaX4PP" crossorigin="anonymous">
<link rel="stylesheet" type="text/css" href="ownStyle.css" media="screen"/>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.1/jquery.min.js"></script>
</head>
<body>
<!--div class="text-center" style="z-index: -1"><img src="images/header.png" width="800px"></div-->
<div class="ripple-background">
<div class="circle xxlarge shade1"></div>
<div class="circle xlarge shade2"></div>
<div class="circle large shade3"></div>
<div class="circle mediun shade4"></div>
<div class="circle small shade5"></div>
</div>
<div class="container">
<div class="d-flex justify-content-center h-100">
<div class="user_card">
<div class="d-flex justify-content-center">
<div class="brand_logo_container">
<img src="images/logo_geo.png" class="brand_logo" alt="Logo">
</div>
<div class="brand_logo_container1">
<img src="images/g980.png" class="brand_logo1" alt="Logo">
</div>
<div class="brand_logo_container2">
<img src="images/g1010.png" class="brand_logo1" alt="Logo">
</div>
</div>
<div class=" justify-content-center container form_container">
<form method="post" action="lenguaje.php">
<div class="input-group">
<div class="input-group-append">
<span class="input-group-text"><i class="fas fa-search"></i></span>
</div>
<input type="text" autocomplete="on" list="Escuelas" name="escuela" id="input_escuela"
class="form-control custom-select" value=""
placeholder="Seleccione la clave o nombre de su escuela" required ">
<input type="hidden" name="clave_escuela" id="clave_escuela">
</div>
<datalist id="Escuelas">
<?php
while ($row = $result1->fetch_assoc()) {
echo '<option value="' . utf8_encode($row["CV_CCT"]) . '">' . utf8_encode($row["NOMBRECT"]) . ' <br>de ' . utf8_encode($row["C_NOM_LOC"]) . '</option>';
//echo '<option value="'.utf8_encode($row["NOMBRECT"]).'">de '.utf8_encode($row["C_NOM_LOC"]).' <br>clave: '.utf8_encode($row["CV_CCT"]).'</option>';
}
while ($row = $result2->fetch_assoc()) {
echo '<option value="' . utf8_encode($row["CV_CCT"]) . '">' . utf8_encode($row["NOMBRECT"]) . ' <br>de ' . utf8_encode($row["C_NOM_LOC"]) . '</option>';
}
while ($row = $result3->fetch_assoc()) {
echo '<option value="' . utf8_encode($row["CV_CCT"]) . '">' . utf8_encode($row["NOMBRECT"]) . ' <br>de ' . utf8_encode($row["C_NOM_LOC"]) . '</option>';
}
while ($row = $result4->fetch_assoc()) {
echo '<option value="' . utf8_encode($row["CV_CCT"]) . '">' . utf8_encode($row["NOMBRECT"]) . ' <br>de ' . utf8_encode($row["LOCALIDAD"]) . '</option>';
}
while ($row = $result5->fetch_assoc()) {
//echo '<option value="'.utf8_encode($row["CV_CCT"]).'">'.utf8_encode($row["NOMBRECT"]).'</option>';
echo '<option value="' . utf8_encode($row["CV_CCT"]) . '">' . utf8_encode($row["NOMBRECT"]) . ' <br>de ' . utf8_encode($row["LOCALIDAD"]) . '</option>';
}
?>
</datalist>
<div class="sombras">
<div class="mt-4">
<div class="d-flex text-center justify-content-center links" id="titulo1">
</div>
</div>
<div class="mt-4">
<div class="d-flex text-center justify-content-center links">
<h1 id="nombre_escuela"></h1>
</div>
</div>
<div class="mt-4">
<div class="d-flex text-center justify-content-center links" id="titulo2">
</div>
</div>
<div class="mt-4">
<div class="d-flex text-center justify-content-center links">
<h3 id="clave"></h3>
</div>
</div>
</div>
<div class="d-flex justify-content-center mt-3 login_container">
<button type="submit" id="next" class="btn login_btn" disabled>Siguiente</button>
</div>
</form>
</div>
</div>
</div>
<footer>
<div class="text-center fixed-bottom" style="margin-bottom: 20px">
<img src="images/Logo-Horizontal-V2-blanco.png" width="300px"><br>
<div>
<div class="text-center" style="margin-bottom: 10px">
<img src="images/g122.png" width="400px">
</div>
</footer>
</div>
<script>
$("#input_escuela").bind('input', function () {
var dato = $('#input_escuela').val();
$('#clave_escuela').val($('#input_escuela').val());
document.getElementById('clave_escuela').value = $('#input_escuela').val();
var valor = checkExists($('#input_escuela').val());
//alert(valor);
var lastword = valor.split(" ").pop();
$('#nombre_escuela').empty();
$('#clave').empty();
$('#titulo1').empty();
$('#titulo2').empty();
var porciones = valor.split('de ');
document.getElementById('input_escuela').value = porciones[0];
$('#nombre_escuela').append(''+porciones[0]);
$('#titulo1').append('<h1><b>Escuela: </b></h1>');
$('#titulo2').append('<h3><b>Localidad:</b></h3>');
$('#clave').append(porciones[1]);
$.post("ajax_post.php",
{
dato: dato
},
function (data, status) {
if (data == "1") {
$('#next').attr("disabled", false);
} else {
$('#next').attr("disabled", true);
}
});
});
function checkExists(inputValue) {
var x = document.getElementById("Escuelas");
var i;
var flag;
for (i = 0; i < x.options.length; i++) {
if (inputValue == x.options[i].value) {
flag = x.options[i].text;
}
}
return flag;
}
</script>
</body>
</html>