用两个单词填充依赖的微调器


Populating depended spinner with two words

我遇到了从PHP填充微调器的问题。我有MySQL表与城市和类。我需要从特定的地点上课。城市的PHP如下所示:

{"lista":[{"City":"Beograd"},{"City":"Novi Sad"},{"City":"Kragujevac"}]}

当我试图用"Novi Sad"中的类填充微调器时,我在android 中遇到了错误

08-09 09:53:37.762: E/Fail 1(28592): java.lang.IllegalArgumentException: Illegal character in query at index 50: http://192.168.1.2/test/test.php?city=Novi%20Sad

如果我在本地主机中调用http://192.168.1.2/test/test.php?grad=Novi%20Sad,我得到的是{"lista":[{"Class":"matematika"},{"Class":"informatika"}]}。如果我试着用城市来填充旋转器:贝尔格莱德或克拉古耶瓦茨,一切都很好。我猜问题出在诺维和萨德之间的空白处。

用于从spinner1(城市)填充spinner2的Url:

str_grad1=spinner1.getSelectedItem().toString();
String url="http://192.168.1.2/test/test.php?grad="+str_grad1;  

编辑:这也是PHP脚本

$con = mysqli_connect($host, $user, $pwd, $db);
if(mysqli_connect_errno($con)) {
    die("Failed to connect to MySQL: " . mysqli_connect_error());
} 
$sql = "SELECT Predmet FROM lista where City='".$_GET['grad']."'";
$result = mysqli_query($con, $sql);
$rows = array();
while($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) {
        $rows[] = $row; 
    }
mysqli_close($con);
$arr = array_flip(array_map('serialize', $rows));
$lista = array_map('unserialize', array_flip($arr));
echo json_encode((object) array('lista' => array_values($lista)));

你不应该像一样编码str_grad1

String url="http://192.168.1.2/test/test.php?grad=" + URLEncoder.encode( str_grad1 );

而不是:

String url="http://192.168.1.2/test/test.php?grad="+str_grad1;