<?php

include 'conexion.php';


$sql = 'SELECT * FROM Inicial WHERE CV_CCT ="' . $_POST['clave'] . '"';
$result = $conn->query($sql);

if ($result->num_rows > 0) {
	foreach ($result as $escuela) {
		echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["C_NOM_LOC"];
	}
} else {
	$sql = 'SELECT * FROM Preescolar WHERE CV_CCT ="' . $_POST['clave'] . '"';
	$result = $conn->query($sql);
	if ($result->num_rows > 0) {
		foreach ($result as $escuela) {
			echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["C_NOM_LOC"];
		}
	} else {
		$sql = 'SELECT * FROM Primaria WHERE CV_CCT ="' . $_POST['clave'] . '"';
		$result = $conn->query($sql);
		if ($result->num_rows > 0) {
			foreach ($result as $escuela) {
				echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["C_NOM_LOC"];
			}
		} else {
			$sql = 'SELECT * FROM Secundaria WHERE CV_CCT ="' . $_POST['clave'] . '"';
			$result = $conn->query($sql);
			if ($result->num_rows > 0) {
				foreach ($result as $escuela) {
					echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["C_NOM_LOC"];
				}
			} else {
				$sql = 'SELECT * FROM Media WHERE CV_CCT ="' . $_POST['clave'] . '"';
				$result = $conn->query($sql);
				if ($result->num_rows > 0) {
					foreach ($result as $escuela) {
						echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["LOCALIDAD"];
					}
				} else {
					$sql = 'SELECT * FROM Superior WHERE CV_CCT ="' . $_POST['clave'] . '"';
					$result = $conn->query($sql);
					if ($result->num_rows > 0) {
						foreach ($result as $escuela) {
							echo $escuela["CV_CCT"].','.$escuela['NOMBRECT'].','.$escuela["LOCALIDAD"];
						}
					} else {
						echo "0";
					}
				}
			}
		}
	}
}


$conn->close();