- Forum posts: 1
Jun 13, 2017, 2:06:30 PM via Website
Jun 13, 2017 2:06:30 PM via Website
I want to import data from MySql to android. I am using android studio.
Jun 13, 2017, 2:06:30 PM via Website
Jun 13, 2017 2:06:30 PM via Website
I want to import data from MySql to android. I am using android studio.
Jun 16, 2017, 4:27:15 PM via Website
Jun 16, 2017 4:27:15 PM via Website
so just write php scripts for your web server and send queries from Android app
Jun 18, 2017, 9:37:51 PM via Website
Jun 18, 2017 9:37:51 PM via Website
*All you have to do is get a host server.
*write a php script to select from the database in the server that throws a json response.
*add this below:
while (mysqli_stmt_fetch($statement)){
$response ["success"] = true;
$response ["Name"] = $name;
$response ["Number"] = $number;
}
echo json_encode($response);
*upload the php file into the online server in the public folder located in the file manager in that server.
*Then in the activity add this to the Response.Listener onResponse event
String name = jsonResponse.getString("Name");
Int number= jsonResponse.getString("Number");
make sure your Request.java class is available.
FetchRequest.java below
public class FetchRequest extends StringRequest {
private static final String FETCH_REQUEST_URL = "Domain/FetchData.php";
private Map<String, String> params;
public FetchRequest (String name, String number, Response.Listener<String> listener){
super(Method.POST, FETCH_REQUEST_URL, listener, null);
params = new HashMap<>();
params.put("Name", name);
params.put("Number", number);
}
@Override
public Map<String, String> getParams() {
return params;
}
}
MainActivity.java below
Response.Listener responseListener = new Response.Listener() {
@Override
public void onResponse(String response) {
try {
JSONObject jsonResponse = new JSONObject(response);
boolean success = jsonResponse.getBoolean("success");
if (success) {
// this is the gotten data retrieved from the daabase in the server
String name = jsonResponse.getString("Name");
int number= jsonResponse.getString("Number");
} else {
}
} catch (JSONException e) {
e.printStackTrace();
}
}
};
FetchRequest fetchRequest = new FetchRequest(name, number, responseListener);
RequestQueue queue = Volley.newRequestQueue(MainActivity.this);
queue.add(fetchRequest)
dont forget to add in your build.gradle:app
dependencies:
'com.android.volley:volley:1.0.0'
— modified on Jun 18, 2017, 9:46:15 PM
Recommended editorial content
With your consent, external content is loaded here.
By clicking on the button above, you agree that external content may be displayed to you. Personal data may be transmitted to third-party providers in the process. You can find more information about this in our Privacy Policy.