In have these data in my database, and some of the users have same DEPT value. My goal is when user login into page (i.e A1) is loggedin . It only display all the user that have the same dept value only which is A1,B1,E1.
---------------------------
| id   | user_id | dept   |
---------------------------
| 1    | A1      | ITD    | 
| 2    | B1      | ITD    |
| 3    | C1      | FAD    |
| 4    | D1      | PNC    |
| 5    | E1      | ITD    |
| 6    | F1      | PSSB   |
But the problem is my user_id and dept output data is in JAVA Android Studio.
Plus, in this case request.GET is applied instead of POST.
JAVA File
public class Test extends AppCompatActivity{
    public static final String dept = "DEPT";
    public static final String user_id   = "ID";
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        Intent intent = getIntent();
        Bundle extras = intent.getExtras();
        final String dept   = (String) extras.get("DEPT");
        final String user_id     = (String) extras.get("USERID");
        getData();
    }
    private void getData(){
        String url = "https://www.aaa.com/test.php";
        StringRequest stringRequest = new StringRequest(Request.Method.GET, url, new Response.Listener<String>() {
            @Override
            public void onResponse(String response) {
                JSONObject j = null;
                try{
                    j       = new JSONObject(response);
                    result  = j.getJSONArray(Config.JSON_ARRAY);
                    getStaffs(result);
                }catch (JSONException e){
                    e.printStackTrace();
                }
            }
        }, new Response.ErrorListener() {
            @Override
            public void onErrorResponse(VolleyError error) {
                Toast.makeText(getApplicationContext(), "Error", Toast.LENGTH_SHORT).show();
            }
        });
        RequestQueue requestQueue = Volley.newRequestQueue(Test.this);
        requestQueue.add(stringRequest);
    }
}
Is it possible or am i doing it the wrong way ?
And also my PHP file as below.
PHP file
<?php
    $connect      = mysqli_connect("localhost", "root", "root", "database");
    global $connect;   
    if(isset($_GET['dept']))
    {
        $dept = $_GET['dept'];
        $sql        = "SELECT * FROM table WHERE dept='$dept'";
        $get        = mysqli_query($connect, $sql);
        $result     = array();
            while($row  = mysqli_fetch_array($get)){
                array_push($result, array(
                        'user_id' => $row['user_id'],
                        'dept'     => $row['dept']
                    ));
            }
        echo json_encode(array('result' => $result));
        mysqli_close($connect);
    }
?>
Config.class
public class Config {
    public static final String JSON_ARRAY        = "result";
}
Thanks.