<?php

$host = "localhost";
$user = "root";
$pass = "";
$db   = "world";


$respuesta = [];

$selec  = $_GET["selected"];

$ms = mysqli_connect($host, $user, $pass);
    if (!$ms){
        $mensaje = 'ERROR: No pude conectar al servidor MySQL';
    }else{
        if (mysqli_select_db($ms, $db)){


            $q = "SELECT * FROM  `city` WHERE `CountryCode`='".$selec."'";

            $r = mysqli_query($ms, $q);


            while($row = mysqli_fetch_assoc($r)){
                $cadena = '<option value="'.$row["ID"].'">'.$row["Name"].'</option>';
                array_push($respuesta,$cadena);


            }

        }



    }


    echo json_encode($respuesta);
    ?>