将POST发送到web服务并验证一些数据，然后以JSON形式发回 - Send POST to a web service and verify some data and send back as JSON

！我正在开发一个智力竞赛应用程序，该应用程序使用PHP web服务为Android智力竞赛编写/托管/维护数据。

以下是有问题的PHP函数。

我正在我的PHP代码中寻找一个帖子。

if (isset($_POST['verifyCourse'])){
verifyCourse($_POST['courseCode']);}

任何这指向函数。。。

function verifyCourse($courseCode){
    $result = mysql_query("SELECT * FROM Course WHERE CourseCode = '"$courseCode'";");
    $rows = array();
    while ($r = mysql_fetch_assoc($result)) {
        $rows = $r;
    }
    if($rows == null){
        return 0;
    } else {
        return json_encode(array('Course' => $rows));
    }
}

然后在我的Android代码上，我这样做是为了向名为"verifyCourse"的服务器发送POST，但我没有得到任何回报。

Android：发送HTTP POSTS 的功能

 public ArrayList<HashMap<String, String>> httpPost(List<NameValuePair> valuepair, String     code)
{
         // Create a new HttpClient and Post Header
            HttpClient httpclient = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("http://mydomain.edu/quiz-app/webservice.php");
            StringBuilder builder = new StringBuilder();
            try {
                httppost.setEntity(new UrlEncodedFormEntity(valuepair));
                // Execute HTTP Post Request
                HttpResponse response = httpclient.execute(httppost);
                StatusLine statusLine = response.getStatusLine();
                int statusCode = statusLine.getStatusCode();
                /* Checking response */
                    if (statusCode == 200) {  
                        HttpEntity entity = response.getEntity();
                        InputStream in = entity.getContent(); 
                        Log.d("myapp", "response " + response.getEntity());
                        BufferedReader reader = new BufferedReader(new InputStreamReader(in));
                    String line;
                        while ((line = reader.readLine()) != null) {
                            builder.append(line);
                        } 
                }else{
                    Log.e("POST-return", "Failed to download file");
                }                       
            } catch (Exception e) {
            }
            ArrayList<HashMap<String, String>> results = new ArrayList<HashMap<String, String>>();          
            HashMap<String, String> storage =  new HashMap<String, String>(); 
            String value;
            try{
                JSONArray jArray = new JSONArray(builder.toString());
                for(int i=0; i<jArray.length(); i++){
                    JSONObject jsonObject = jArray.getJSONObject(i);
                    value=jsonObject.getString(code);
                    storage = new HashMap<String, String>();
                    storage.put(code, value);
                    results.add(storage);
                }
            } catch (Exception e) {
            }
            return results;

        }

然后我像这样使用它来执行功能。///从应用程序的其他部分传递代码public void getCourseCodesandVerify(字符串代码(｛

    List<NameValuePair> course_info = new ArrayList<NameValuePair>(2);
    course_info.add(new BasicNameValuePair("verifyCourse",null));
    course_info.add(new BasicNameValuePair("courseCode",code));
    httpPost(course_info,null);

}

知道为什么我的代码什么都不返回吗。。。？

以下是我从JSON中得到的信息，我该如何处理？

mysql_fetch_assoc返回一个数组。所以在你的代码中，你会得到这样的东西：

   echo json_encode(array('Course' => array()));

结果是字符串：CCD_ 2。在JSON中，这是一个对象。所以你需要用来取

JSONObject jsonObject = new JSONObject(jsonString);
JSONArray jArray = jsonObject.getJSONArray("Course");

另请参阅：在android 中读取Json数组

更新

在您的php:中

function verifyCourse($courseCode){
   $result = mysql_query("SELECT * FROM Course WHERE CourseCode = '"$courseCode'" LIMIT 1");
   $rows = array();
   while ($r = mysql_fetch_assoc($result))
   {
       $rows[]= $r;
   }   
   header('Content-type: application/json');
   return json_encode(array('Course' => $rows));
   exit;
}

它输出一个字符串，如：

 {"Course":[{"key1":"value1","key2":"value2"},{"2key1":"2value1","2key2":null}]}

在您的java代码中：

        JSONObject jsonObject = new JSONObject(builder.toString());

        JSONArray jArray = jsonObject.getJSONArray("Course");

        for(int i = 0; i < jArray.length(); i++){
            JSONObject jObject = jArray.getJSONObject(i);
            Iterator<String> keys = jObject.keys();
            storage =  new HashMap<String, String>();         
            while( keys.hasNext() ){
                   String key = (String)keys.next();
                   storage.put(key, jObject.get(key).toString());
            }
            results.add(storage);
        }