java - Android app and Database Communication: JSON Parsing and List View

Solution:

I would suggest a different json structure for encoding. Yours will get messy pretty quick if there are a lot of records. For example you would havename0,name1, ...nameN. It would be better to make an array like so:

[
    {
        "name" : "ABC",
        "age" : 25,
        "department" : "Medical",
        "country" : "XYZ"
    },
    {
        ...
    }
]
Copy code

Notice that there are no indices concatenated to your keys. You can get the index based on the json object node's position in the array if you need it.

As for parsing it in Android, you can refer to the documentation. There is a Json parser that comes with the SDK so all you need to do is read in your string as a json array and iterate over its object nodes as needed.

For example

String jsonResponse = " ... "; // whatever the php backend gives you when you make a call to the endpoint
JSONArray arr = new JSONArray(jsonResponse);
for (int i=0; i<arr.length(); i++) {
    JSONObject obj = arr.get(i);
    String name = obj.getString("name");
    ...
}
Copy code