1#@!#!123s

D7net

: / home / ensad / public_html /

Filename : get-distritos.php

back

<?php
	$id_provincia=$_GET["id_provincia"];

	$servername = "localhost";
	$username = "ensadedu_63d";
	$password = "4FEDB5C31y0cogj9q2u6a7f8";
	$dbname = "ensadedu_63d";

	// Create connection
	$conn = new mysqli($servername, $username, $password, $dbname);
	// Check connection
	if ($conn->connect_error) {
	    die("Connection failed: " . $conn->connect_error);
	}

	$sql = "SELECT idDist, distrito FROM ubdistrito where idProv='".$id_provincia."'";
	$result = $conn->query($sql);
	$distritos = array();
	if ($result->num_rows > 0) {
	   foreach($result as $r){
            $distritos[] = array($r['idDist'], $r['distrito']);   
        }
	}
	echo json_encode($distritos);
	$conn->close();
?>