//define variables
//define variables
ProgressDialog loading2;
ListView listView2;
SimpleAdapter adapter2;

String userinputpass2=code_absence2.getVariable();

@Override
protected void onCreate(@Nullable Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);

    setContentView(R.layout.li_student_result);
    listView2 = (ListView) findViewById(R.id.list_view_result);
    getabsence();
}

//This is the part where data is transafeered from Your Android phone to Sheet by using HTTP Rest API calls
private void getabsence() {
    loading2 =  ProgressDialog.show(this,"الرجاء الانتظار","جاري تحميل حالة الطالب",false,true);
    StringRequest stringRequest2 = new StringRequest(Request.Method.GET, "link of google spread sheet",
            new Response.Listener<String>() {
                @Override
                public void onResponse(String response) {
                    parsestudent(response); }
            }, new Response.ErrorListener() {
        @Override
        public void onErrorResponse(VolleyError error) { }
    });

    //check internet cnnection
    int socketTimeOut2 = 50000;
    RetryPolicy policy2 = new DefaultRetryPolicy(socketTimeOut2, 0, DefaultRetryPolicy.DEFAULT_BACKOFF_MULT);
    stringRequest2.setRetryPolicy(policy2);
    RequestQueue queue = Volley.newRequestQueue(this);
    queue.add(stringRequest2); }

// here we get values from data base

private void parsestudent(String jsonResposnce2) {

    ArrayList<HashMap<String, String>> list2 = new ArrayList<>();

    try {
        Toast.makeText(student_absence2.this,"hello!", Toast.LENGTH_LONG).show();
        JSONObject jobj2 = new JSONObject(jsonResposnce2);
        JSONArray jarray2 = jobj2.getJSONArray("items2");

        for (int i = 0; i < jarray2.length(); i++) {
            JSONObject jo2 = jarray2.getJSONObject(i);

            //here i got the value from my data base to display it
            String name2 = jo2.getString("name2");
            String absence2 = jo2.getString("absence2");
            String pass2 = jo2.getString("pass2");

            //here we pass params by using hashma
            HashMap<String, String> item2 = new HashMap<>();
            item2.put("name2", name2);
            item2.put("absence2", absence2);
            item2.put("pass2",pass2);

            if(pass2.equals(userinputpass2)) {
                list2.add(item2);
                break;
            }

        }
    } catch (JSONException e) {
        e.printStackTrace();
    }

    //to display data in thier own text view depends in adapter
    adapter2 = new SimpleAdapter(this,list2,R.layout.lir_student_absence
            ,new String[]{"name2","absence2"}
            ,new int[]{R.id.tv_name1,R.id.tv_absence1});
    listView2.setAdapter(adapter2);
    loading2.dismiss();
}