作用:这是一个安卓应用程序，将模仿一个网站我的团队正在创建，apdata.info。这是第二页，它将显示符合他们请求的搜索的机场。
PHP…
$sql = "SELECT apname,apcity,apstate,apcountry,IATA FROM airports WHERE MATCH(apname,apcity,apstate,apcountry,IATA) AGAINST (? IN BOOLEAN MODE)";
$link = connectToDB();
if($stmt = $link->prepare($sql))
{
$stmt->bind_param('s', $search);
if($stmt->execute())
{
$stmt->store_result();
if($stmt->num_rows >= 1)
{
$resultSet = array();
$stmt->bind_result($apname, $apcity, $apstate, $apcountry, $IATA);
$search_rows = $stmt->num_rows;
if($search_rows > 0){
while($stmt->fetch())
{
$resultSet[] = array('apname' => $apname, 'apcity' => $apcity, 'apstate' => $apstate, 'apcountry' => $apcountry, 'IATA' => $IATA);
//echo "Your search returned $search_rows results";
//echo "<a href='/Airports/airport.php?IATA=".$IATA."'>".$apname."</a><br>";
print(json_encode($resultSet));
...
private void fetchResults(String searchfor){
String result = "";
//the year data to send
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
nameValuePairs.add(new BasicNameValuePair("search", searchfor));
//http post
try{
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://apdata.info/results/androidresult.php");
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
HttpResponse response = httpclient.execute(httppost);
entity = response.getEntity();
is = entity.getContent();
//System.out.println("------------looks good here");
}catch(Exception e){
Log.e("log_tag", "Error in http connection "+e.toString());
}
//convert response to string
try{
BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line + "'n");
}
is.close();
result=sb.toString();
//System.out.println(result);
}catch(Exception e){
Log.e("log_tag", "Error converting result "+e.toString());
}
System.out.println(result);
//parse json data
try{
JSONArray jArray = new JSONArray(result);
System.out.println();
results = new ApResult[jArray.length()];
for(int i=0;i<jArray.length();i++){
System.out.println("-----------jArray.length");
JSONObject json_data = jArray.getJSONObject(i);
results[i] = new ApResult(
json_data.getString("IATA"),
json_data.getString("apname"),
json_data.getString("apcity"),
json_data.getString("apstate"),
json_data.getString("apcountry")
);
}
}catch(JSONException e){
Log.e("log_tag", "Error parsing data "+e.toString());
}
}
结果打印出结果字符串的结果:
03-13 07:40:06.985: I/System.out(220): [{"apname":"Bismarck Municipal Airport","apcity":"Bismarck","apstate":"North Dakota","apcountry":"United States","IATA":"BIS"}][{"apname":"Bismarck Municipal
Airport","apcity":"Bismarck","apstate":"North Dakota","apcountry":"United States","IATA":"BIS"},{"apname":"Hector International Airport","apcity":"Fargo","apstate":"North Dakota","apcountry":"United
States","IATA":"FAR"}][{"apname":"Bismarck Municipal Airport","apcity":"Bismarck","apstate":"North Dakota","apcountry":"United States","IATA":"BIS"},{"apname":"Hector International
Airport","apcity":"Fargo","apstate":"North Dakota","apcountry":"United States","IATA":"FAR"},{"apname":"Cologne Bonn Airport","apcity":"Cologne '/ Bonn","apstate":"North Rhine-Westphalia","apcountry":"Germany","IATA":"CGN"}][{"apname":"Bismarck Municipal Airport","apcity":"Bismarck","apstate":"North
Dakota","apcountry":"United States","IATA":"BIS"},{"apname":"Hector International Airport","apcity":"Fargo","apstate":"North Dakota","apcountry":"United States","IATA":"FAR"},{"apname":"Cologne Bonn Airport","apcity":"Cologne '/ Bonn","apstate":"North Rhine-Westphalia","apcountry":"Germany","IATA":"CGN"},
{"apname":"Dusseldorf International Airport","apcity":"Dusseldorf","apstate":"North Rhine-Westphalia","apcountry":"Germany","IATA":"DUS"}]
问题是，jArray。length = 1，尽管我收到的远不止这个数。你可以从我的输出中看到，字符串似乎被分成两个部分，第一部分是[{"apname":"俾斯麦市机场"，"apcity":"俾斯麦"，"apstate":"North Dakota"，"apcountry":"United States"，"IATA":"BIS"}]而其他的则用逗号分隔。
为了解决这个问题，我添加了一个函数来修复这个错误:
private String fixBug(String result) {
result = result.replace("][", ",");
return result;
}
但是我想知道为什么它会首先发生。
你不应该为每个结果单独创建一个json。您应该将所有结果包含在一个json中。将数据保存在变量中，在while循环之外，可以将其编码为有效的json。尝试使用http://jsonlint.com/进行验证。
现在你有
while() {
$resultSet[] = array('apname' => $apname, 'apcity' => $apcity, 'apstate' => $apstate, 'apcountry' => $apcountry, 'IATA' => $IATA);
print(json_encode($resultSet));
}
应该是
while() {
$resultSet[] = array('apname' => $apname, 'apcity' => $apcity, 'apstate' => $apstate, 'apcountry' => $apcountry, 'IATA' => $IATA);
}
print(json_encode($resultSet));