dph6308 2016-03-03 05:24
浏览 64

Android volley:org.json.JSONException:(使用PDO)字符0的输入结束

forgive me for possible duplicate, i have tried all the way that related my case, but still got nothing.

I this case i trying to display data from MySql using PDO.

this is my java response :

  progressDialog.setMessage("Loading data..");
                RequestQueue requestQueue = Volley.newRequestQueue(MainActivity.this);
                JsonObjectRequest request = new JsonObjectRequest(Request.Method.GET, URL_GET_DATA, null,
                        new Response.Listener<JSONObject>() {
                            @Override
                            public void onResponse(JSONObject response) {
                                progressDialog.dismiss();
                                Log.d("TAG", "EXE : " + response.optString("nama"));
                                try {
                                    JSONArray jsonArray = response.getJSONArray("identitas");
                                    for (int i = 0; i < jsonArray.length(); i++) {
                                        JSONObject jsonObject = jsonArray.getJSONObject(i);
                                        Toast.makeText(MainActivity.this, jsonObject.optString("nama"), Toast.LENGTH_SHORT).show();
                                    }
                                } catch (JSONException e) {
                                    e.printStackTrace();
                                }
                            }
                        },
                        new Response.ErrorListener() {
                            @Override
                            public void onErrorResponse(VolleyError error) {
                                Toast.makeText(MainActivity.this, "ERROR : " + error.getMessage(), Toast.LENGTH_SHORT).show();
                                progressDialog.dismiss();
                                Log.d("TAG", "ERROR : " + error.getMessage());
                                System.out.println("ERROR : " + error);
                            }
                        });
                requestQueue.add(request);

my php code to get all data :

include "Connection.php";

class DisplayData {

    function getAllData(){
        $connection = new Connection();
        $conn = $connection->getConnection();

        $response = array();
        $response["identitas"] = array();

        try{
            $sql = "SELECT * FROM identitas";
                    $getData = $conn->prepare($sql);
                    $getData->execute();
                    if( $column = $getData->fetchColumn()>0){//for count row

                        $result = $getData->fetchAll(PDO::FETCH_ASSOC);
                        foreach($result as $data) {
                            echo $data["nama"] . '<br/>';
                            echo $data["umur"] . '<br/>';
                            echo $data["jeniskel"] . '<br/>';

                            //--------------------display json
                            //temp user array
                            $identitas = array();
                            $identitas["nama"] = $data["nama"];
                            $identitas["umur"] = $data["umur"];
                            $identitas["jeniskel"] = $data["jeniskel"];
                            array_push($response["identitas"], $identitas);
                        }
                        $response["success"] = 1;
                        $response["message"] = "Success";
                        echo json_encode($response);
                    }else{
                        $response["success"] = 1;
                        $response["message"] = "No Product Found";
                        echo json_encode($response);
                    }
        }catch (PDOException $e){
            echo "Failed to display " . $e->getMessage();
        }
    }
}

json response should be like this :

{  
   "identitas":[  
      {  
         "nama":"Kacang tanah jagoan",
         "umur":"16 tahun",
         "jeniskel":"Tumbuhan bencong"
      },
      {  
         "nama":"Kacang tanah jagoan",
         "umur":"16 tahun",
         "jeniskel":"Tumbuhan bencong"
      },
      {  
         "nama":"kacang",
         "umur":"19 tahun",
         "jeniskel":"laki laki"
      },
      {  
         "nama":"Beruang Kutub",
         "umur":"200 tahun",
         "jeniskel":"Jantan Kewanitaan"
      },
      {  
         "nama":"Arak",
         "umur":"44",
         "jeniskel":""
      },
      {  
         "nama":"nangka",
         "umur":"22",
         "jeniskel":"buah"
      },
      {  
         "nama":"jonat",
         "umur":"18",
         "jeniskel":"laki laki"
      },
      {  
         "nama":"jonat",
         "umur":"18",
         "jeniskel":"laki laki"
      },
      {  
         "nama":"polongs",
         "umur":"12",
         "jeniskel":"laki laki"
      },
      {  
         "nama":"Jas",
         "umur":"30",
         "jeniskel":"Musik"
      },
      {  
         "nama":"jaran goyang",
         "umur":"12",
         "jeniskel":"eeee"
      },
      {  
         "nama":"dd",
         "umur":"33",
         "jeniskel":"fddf"
      },
      {  
         "nama":"kavang",
         "umur":"89",
         "jeniskel":"ikk"
      },
      {  
         "nama":"jangar",
         "umur":"1",
         "jeniskel":"gfff"
      }
   ],
   "success":1,
   "message":"Success"
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 微信公众号自制会员卡没有收款渠道啊
    • ¥15 stable diffusion
    • ¥100 Jenkins自动化部署—悬赏100元
    • ¥15 关于#python#的问题:求帮写python代码
    • ¥20 MATLAB画图图形出现上下震荡的线条
    • ¥15 关于#windows#的问题:怎么用WIN 11系统的电脑 克隆WIN NT3.51-4.0系统的硬盘
    • ¥15 perl MISA分析p3_in脚本出错
    • ¥15 k8s部署jupyterlab,jupyterlab保存不了文件
    • ¥15 ubuntu虚拟机打包apk错误
    • ¥199 rust编程架构设计的方案 有偿