How to parse jsonarray to listview in fragment

Question

Here my array

{
 sales_schedule_name: "Visit Client",
 sales_schedule_date: "2018-01-18",
 sales_schedule_time: "10:30:00",
 sales_schedule_address: "Sydney",
 sales_schedule_description: "Sales Visit"
}

That array came from schedule.php

 $query = "select sales_schedule_name,sales_schedule_date,sales_schedule_time,sales_schedule_address,sales_schedule_description from sales_schedule";

if ($stmt = $conn->prepare($query)) {
 $stmt->execute();
 $stmt->bind_result($sales_schedule_name, $sales_schedule_date, $sales_schedule_time, $sales_schedule_address, $sales_schedule_description);

 $schedule = array(); 

 while ($stmt->fetch()) {
     //printf("%s, %s, %s, %s, %s\n", $sales_schedule_name, $sales_schedule_date, $sales_schedule_time, $sales_schedule_address, $sales_schedule_description);
     $temp = array();
     $temp['sales_schedule_name'] = $sales_schedule_name; 
     $temp['sales_schedule_date'] = $sales_schedule_date; 
     $temp['sales_schedule_time'] = $sales_schedule_time; 
     $temp['sales_schedule_address'] = $sales_schedule_address; 
     $temp['sales_schedule_description'] = $sales_schedule_description; 
     array_push($schedule, $temp);

 }
 $stmt->close();
 }

 //displaying the result in json format 
 echo json_encode($schedule);

Anyone can help me to call that array on my public list getTestData() using json?

public class ScheduleFragment extends Fragment {

    public ScheduleFragment() {
    }
    RecyclerView scheduleRecyclerView;
    @Override
    public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
        View view = inflater.inflate(R.layout.fragment_schedule, container, false);

        getActivity().setTitle("Schedule Task");
        scheduleRecyclerView= view.findViewById(R.id.schedule_list);
        LinearLayoutManager linearLayoutManager = new LinearLayoutManager(getActivity());
        scheduleRecyclerView.setLayoutManager(linearLayoutManager);
        scheduleRecyclerView.setHasFixedSize(true);
        ScheduleAdapter mAdapter = new ScheduleAdapter(getActivity(), getTestData());
        scheduleRecyclerView.setAdapter(mAdapter);
        return view;
    }

    public List getTestData() {
        final List recentSchedule = new ArrayList();
        recentSchedule.add(new ScheduleObject("Visit Client", "2018-01-18", "10:30","Sydney","Sales Visit"));

        return recentSchedule;
    }


}

i was try change with

public List<ScheduleObject> getTestData() {

    //recentSchedule.add(new ScheduleObject("Visit Client", "11/10/18", "10:30","Sydney","Sales Visit"));


    RequestQueue rq = Volley.newRequestQueue(getActivity().getApplicationContext());

    String url= AppConfig.URL_SCHEDULELIST;

    StringRequest stringRequest = new StringRequest(Request.Method.GET, url,
            new Response.Listener<String>() {
                @Override
                public void onResponse(String response) {
                    // Do something with the response

                    try{

                        JSONObject o = new JSONObject(response);
                        JSONArray values=o.getJSONArray("salesScheduleName");

                        for ( int i=0; i< values.length(); i++) {

                            JSONObject schedules = values.getJSONObject(i);

                            String salesScheduleName = schedules.getString("salesScheduleName");
                            String salesScheduleDate = schedules.getString("salesScheduleDate");
                            String salesScheduleTime = schedules.getString("salesScheduleTime");
                            String salesScheduleAddress = schedules.getString("salesScheduleAddress");
                            String salesScheduleDescription = schedules.getString("salesScheduleDescription");


                            //Use the title and id as per your requirement
                            recentSchedule.add(new ScheduleObject(salesScheduleName, salesScheduleDate, salesScheduleTime, salesScheduleAddress, salesScheduleDescription));
                        }




                    }  catch (JSONException ex){}

                }
            },
            new Response.ErrorListener() {
                @Override
                public void onErrorResponse(VolleyError error) {
                    // Handle error
                }
            });
    return recentSchedule;
}

But nothing happen

don't mix up php array with json array. One that you have posted is a json object not json array. — Vivek Mishra

Spider Lynxz Spider Lynxz · Accepted Answer · 2017-12-06T08:15:34

After try to figure out which cause the problem on my listview, finaly this problem solved. Now i can call all data on my listview fragment.

public List<ScheduleObject> getTestData()   {

   try {

        JSONArray jsonArray=new JSONArray(getURL(AppConfig.URL_SCHEDULELIST));
        //iterate loop
        for(int i=0;i<jsonArray.length();i++){

            //get the JSON Object
            JSONObject schedules=jsonArray.getJSONObject(i);


            //prepare data to schedule list
            String salesschedulename = schedules.getString("salesschedulename");
            String salesscheduledate = schedules.getString("salesscheduledate");
            String salesscheduletime = schedules.getString("salesscheduletime");
            String salesscheduleaddress = schedules.getString("salesscheduleaddress");
            String salesscheduledescription = schedules.getString("salesscheduledescription");

            //adding the schedule to schedule list
            recentSchedule.add(new ScheduleObject(salesschedulename, salesscheduledate, salesscheduletime, salesscheduleaddress, salesscheduledescription));

        }

    } catch (Exception e) {

        System.out.println(e.getMessage());

        Toast toast = Toast.makeText(
                //getActivity(),"Custom Toast From Fragment",Toast.LENGTH_LONG
                getActivity().getApplicationContext(), e.getMessage(), Toast.LENGTH_LONG
        );
        // Set the Toast display position layout center
        toast.setGravity(Gravity.CENTER,0,0);
        // Finally, show the toast
        toast.show();

    }

    return recentSchedule;
}


public static String getURL(String url) throws Exception {
    URL website = new URL(url);
    URLConnection connection = website.openConnection();
    BufferedReader in = new BufferedReader( new InputStreamReader(connection.getInputStream(),"UTF8"));

    StringBuilder response = new StringBuilder();
    String inputLine;

    while ((inputLine = in.readLine()) != null)
        response.append(inputLine);

    in.close();

    return response.toString();
}

How to parse jsonarray to listview in fragment

1 Answers