Java code to retrieve data from database using two input values

Question

The program gets input rollno and name and displays the address and marks based on it. I get the output for marks and address as null instead of the value stored in the databse. The PHP code works fine. >

public class MainActivity extends AppCompatActivity implements View.OnClickListener {
private EditText editText;
private EditText editText2; 
private Button buttonGet;
private TextView textViewResult;
private ProgressDialog loading;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
editText = (EditText) findViewById(R.id.editText);
editText2 = (EditText) findViewById(R.id.editText2);
buttonGet = (Button) findViewById(R.id.buttonGet);
textViewResult = (TextView) findViewById(R.id.textViewResult);
buttonGet.setOnClickListener(this);
}

private void getData() {
String rollno = editText.getText().toString().trim();
if (rollno.equals("")) {
Toast.makeText(this, "Please enter an rollno", Toast.LENGTH_LONG).show();
            return;
}
String name = editText2.getText().toString().trim();
if (name.equals("")) {
Toast.makeText(this, "Please enter an name", Toast.LENGTH_LONG).show();
return;
}
loading = ProgressDialog.show(this,"Please wait...","Fetching...",false,false);
String url = http://192.14.6.113/getData.php?rollno="+rollno+" & name="+name;
StringRequest stringRequest = new StringRequest(url, new Response.Listener<String>() {
@Override
public void onResponse(String response) {
loading.dismiss();
showJSON(response);
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
Toast.makeText(MainActivity.this,error.getMessage().toString(),Toast.LENGTH_LONG).show();
}
});
 RequestQueue requestQueue = Volley.newRequestQueue(this);
 requestQueue.add(stringRequest);
}
 private void showJSON(String response){
tring address="";
String marks = "";
try {
JSONObject jsonObject = new JSONObject(response);
JSONArray result = jsonObject.getJSONArray(Config.JSON_ARRAY);
JSONObject collegeData = result.getJSONObject(0);
address = collegeData.getString(Config.KEY_ADDRESS);
marks = collegeData.getString(Config.KEY_MARKS);
} catch (JSONException e) {
e.printStackTrace();
}
textViewResult.setText("Address:\t" +address+ "\nMarks:\t"+ marks);
}
 @Override
public void onClick(View v) {
getData();
    }
}

Possible duplicate of [How to do a HTTP Post in Android?](http://stackoverflow.com/questions/4470936/how-to-do-a-http-post-in-android) — Mohammed Bakr Sikal, Apr 06 '17 at 09:53
If the PHP code works fine (and since the question doesn't contain any PHP), that tag should be removed. — M. Eriksson, Apr 06 '17 at 09:54
What is `Config` in `Config.KEY_ADDRESS` . problem lies in there — Zubair Nabi, Apr 06 '17 at 09:58
public class Config { public static final String KEY_ADDRESS = "address"; public static final String KEY_marks = "marks"; public static final String JSON_ARRAY = "result"; } — Rasiga Varun, Apr 06 '17 at 10:02
It is the java code to retrieve data from mysql database in android — Rasiga Varun, Apr 06 '17 at 10:02
Please update your question with JSON response. From what are you extracting. Simply adding `system.out.println(jsonObject)` will print the json object — Zubair Nabi, Apr 06 '17 at 10:26

Java code to retrieve data from database using two input values

0 Answers0