Android PHP Mysql Part 1

Hello Guys ,

Welcome to Virtual Education Channel,

This series is about Android Solutions

Today we will see how to connect Android to Mysql Database using Okhttp3 library and PHP webservices .

1] Create a New Project in Android Studio

2] To Add okhttp3 library in android studio go to following

http://square.github.io/okhttp/

You can download the jar file and add it in your libs folder or you directly place

compile 'com.squareup.okhttp3:okhttp:3.5.0' in gradle and sync.

Wait Untill sync is finished


3] Now create a layout file for user registration and simultaneously we will also make a database in mysql for storing of data.

You can set the layout perfectly by specfying all the attributes accordingly in relative layout

I have created a simple layout

4] Now let's create a database in phpmyadmin

5] Let add the code in main activity to load all the elements that we setup in activity and also load the okhttp3 library

//firstly we load the components in mainactivity.java

// let's see the below Code
OkHttpClient client = new OkHttpClient();
//load the okhttp library class and create is object

RequestBody body = new FormBody.Builder()
.add("Token",token)
.build();
//here , we have to add the fields that needs to be pass in php files


Request request = new Request.Builder()
.url("http://10.0.2.2/")
.post(body)
.build();

// we will have to connect to localhost , in android we do it using 10.0.2.2 , check that localhost is working or not in android emulator
we can see the localhost connected , if it is not working than check the internet connection is enabled , you can see
4g sign on above panel in android indicates that internet is working .

client.newCall(request).enqueue(new Callback() {
@Override
public void onFailure(Call call, IOException e) {
Log.i(TAG , e.getMessage());
}

@Override
public void onResponse(Call call, Response response) throws IOException {
Log.i(TAG , response.body().string());
}
});

// Now we will have to create php (Webservices) file to get the post values from android file

// ahh, sorry give the internet permission in manifest file before running the code
// All Done , Now run your code