Now come to MainActivity.java and write the following code.

For creating the above layout you can use the following xml code.

Retrieve data from mysql database in android

Now go to activity_main.xml and create the following layout.

You check the IP using ipconfig command by opening command prompt in windows. And you need to put the actual URL if you are using a live server. You need to put your own IP address if you are using a local server. This is the ip address where my local server is running.

As you can see my URL is starting from an IP address.Public static final String JSON_ARRAY = 'result' Public static final String KEY_VC = 'vc' Public static final String KEY_ADDRESS = 'address' Public static final String KEY_NAME = 'name' Public static final String DATA_URL = '' Here we will declare some important constants. Now create a new Java class in your package.If you don’t know how to add volley library to android studio visit this link. Open Android Studio and create a new project.Now if you are getting the same you can move ahead. By going to the above url I am getting the following result (I am using wamp server so it is working on localhost).So we can pass a get request using ?id=id_value Just check that getData.php is working correctly or not. $con = mysqli_connect(HOST,USER,PASS,DB) or die('Unable to Connect') You can see the code for dbConnect.php below. So this is a php script already created in my server. Obviously this is for database connection. You are seeing that in the above script we imported dbConnect.php. Create a php file named getData.php and write the following code.Įcho json_encode(array('result'=>$result)).And we will display the college details in json according to the given id. In the script we will get the college id as an http request. So for getting the college detail we will use JSON.So we will create a simple app where we will provide the collegeid and our app will give us the college details.

Mysql database android studio tutorial