How to extract info from String in android studio?

Question

I am trying to display information retrieved from server using php in an android app,I have retrieved the information in a String with json formatting here is the retrieve code and php code. PHP code

<?php 
 if($_SERVER['REQUEST_METHOD']=='POST')
{

    //Getting values
     $username = $_POST['username'];
     require_once('dbConnect.php');

     $sql = "SELECT * FROM `employee` WHERE username='$username'";
     $result=mysqli_query($con,$sql);
     $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
     echo json_encode($row);
}

Android Retrieve code

 @Override
    protected String doInBackground(Void... params) {
        // TODO: attempt authentication against a network service.

        HashMap<String,String> params1= new HashMap<>();
        params1.put(Config.KEY_EMP_UN,mUsername);

        RequestHandler rh = new RequestHandler();
        String res = rh.sendPostRequest(Config.URl_RET, params1);
        return res;
        // TODO: register the new account here.
    }

    @Override
    protected void onPostExecute(final String success) {
        Toast.makeText(Main2Activity.this,success,Toast.LENGTH_LONG).show();
        final TextView Textview1 = (TextView)findViewById(R.id.textView);
        Textview1.setText(success);
    }

This retrieves info in format shown in below image

What is want to do is extract Name,Designation,Salary,Password and display them in separate TextView.How can I do that?

Google "android json". Also, you have a possible SQL injection problem in your PHP code. — Bart Friederichs, Sep 29 '17 at 07:04

Omar Hayat · Accepted Answer · 2017-09-29T07:25:16.813

Take your server response and parse it like this

try {
JSONObject jsonObject = new JSONObject(response);

if (jsonObject.has("name")) {
String name=jsonObject.getString("name");
}
if (jsonObject.has("designation")) {
String designation=jsonObject.getString("designation");
}
if (jsonObject.has("salary")) {
int salary=jsonObject.getInt("salary");
}
if(jsonObject.has("password")){
String password=jsonObject.getString("password");
}
}catch (Exception e) {

}

score 0 · Answer 2 · answered Sep 29 '17 at 07:14

0

you have to parse the json :

JSONObject jsonObject=new JSONObject(success);
//key value for eg : name,salary etc
// now do whatever you want to do
jsonObject.getString("your key value");

answered Sep 29 '17 at 07:14

Dhruv Tyagi

814
1
9
28

score 0 · Answer 3 · answered Sep 29 '17 at 07:15

There are lots of possible duplicates to this question, so I recommend closing this question after reading this answer.

What you have in here is a JSON response and in order to parse information in JSON, you have to use a JSON parser. Libraries like Gson, Jackson, Moshi will be able to do this.

If you're using Gson, you have to generate model classes of the response which can be written manually or auto-generated using jsonschema2pojo. Once Gson parses your JSON, you can use your model classes getters to access data.

Links to tutorials

https://kylewbanks.com/blog/Tutorial-Android-Parsing-JSON-with-GSON

Youtube video

https://www.youtube.com/watch?v=y96VcLgOJqA

How to extract info from String in android studio?

3 Answers3