1#@!#!123s

D7net

: / home / ensad / public_html /

Filename : get-provincias.php

back

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

	$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 idProv, provincia FROM ubprovincia where idDepa='".$id_departamento."'";
	$result = $conn->query($sql);
	$provincias = array();
	if ($result->num_rows > 0) {
	   foreach($result as $r){
            $provincias[] = array($r['idProv'], $r['provincia']);   
        }
	}
	echo json_encode($provincias);
	$conn->close();
?>