Android JSON Parsing – Retrieve From MySQL Database

April 20, 2015 by Belal Khan 44 Comments

Hey guys, today we will learn fetching values from MySQL database as JSON then in the Android side we will parse that JSON data. It is useful when you want to retrieve your stored data on MySQL database. So let’s start our Android JSON Parsing Tutorial.

Contents

1 What is JSON?
- 1.1 JSON Object
- 1.2 JSON Array
2 Fetching Data from MySQL using PHP
- 2.1 The Database Table
- 2.2 Fetching from the Table in JSON Format
3 Android JSON Parsing
4 Android JSON Parsing Source Code Download
- 4.1 Sharing is Caring:
- 4.2 Related

What is JSON?

Before moving further, I would like to explain that what is JSON. If you already know about JSON, then you can skip this part.

JSON stands for JavaScript Object Notation. It is a widely used data interchange format. It is lightweight easy to understand and use.

Now we use JSON because for machines we need a well-structured format to read the data, as the computer cannot think as human and machine need a fixed structure so that it can be programmed. So for this, we use JSON.

A JSON can be of two structures.

A collection of Name Value pairs. We call it an object.
A list of values, we can call it an Array.

JSON Object

Below is a JSON Object.

{
  "name":"Belal Khan",
  "address":"Ranchi",
  "college":"St. Xavier's College",
  "age":24,
  "dob":"30-04-1993"
}

{

"name":"Belal Khan",

"address":"Ranchi",

"college":"St. Xavier's College",

"age":24,

"dob":"30-04-1993"

}

So remember if we are considering a JSON object it will be inside a pair of curly braces { json data }. And inside the curly braces we have the data in name and value pairs.

JSON Array

Below is a JSON array.

[
  "Spiderman",
  "Iron Man",
  "Captain America",
  "Thor"
]

[

"Spiderman",

"Iron Man",

"Captain America",

"Thor"

]

Now if we talk about a JSON Array then it would be inside square braces [ JSON array ]. And inside the braces, we can have all the items that we want on the JSON array. In the above-given array, we have only a list of strings. But we can also have the list of JSON objects inside a JSON Array. See an example below.

[
  {
    "name":"Belal Khan",
    "address":"Ranchi",
    "college":"St. Xavier's College",
    "age":24,
    "dob":"30-04-1993"
  },
  {
    "name":"Sunny Kumar",
    "address":"Ranchi",
    "college":"JRU",
    "age":24,
    "dob":"20-04-1994"
  },
  {
    "name":"Ramiz Khan",
    "address":"Ranchi",
    "college":"St. Xavier's College",
    "age":22,
    "dob":"30-04-1993"
  }
]

[

{

"name":"Belal Khan",

"address":"Ranchi",

"college":"St. Xavier's College",

"age":24,

"dob":"30-04-1993"

{

"name":"Sunny Kumar",

"address":"Ranchi",

"college":"JRU",

"age":24,

"dob":"20-04-1994"

{

"name":"Ramiz Khan",

"address":"Ranchi",

"college":"St. Xavier's College",

"age":22,

"dob":"30-04-1993"

}

]

For more details about JSON you can see the JSON Tutorial on W3Schools.

Fetching Data from MySQL using PHP

Now first we need to fetch the data from our MySQL database. Here I am using XAMPP Server. You can use wamp, lamp or anything you are comfortable with.

The Database Table

Assuming I have the following table in my PhpMyAdmin.

MySQL Table

Now here I have a straightforward table, But in real scenarios, you may have complicated tables with many relations or many fields. But the underlying process is the same always. You can check the following video tutorial to understand it in detail that how to work with different table structures.

Fetching from the Table in JSON Format

Now we will fetch the values from the table. For this go to htdocs. (c:/xampp/htdocs) and create a new folder there. You can name your folder anything you want. I have named it Android.
Inside that folder create a php script named getdata.php and write the following code.

<?
//these are the server details
//the username is root by default in case of xampp
//password is nothing by default
//and lastly we have the database named android. if your database name is different you have to change it 
$servername = "localhost";
$username = "root";
$password = "";
$database = "android";


//creating a new connection object using mysqli 
$conn = new mysqli($servername, $username, $password, $database);

//if there is some error connecting to the database
//with die we will stop the further execution by displaying a message causing the error 
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//if everything is fine

//creating an array for storing the data 
$heroes = array(); 

//this is our sql query 
$sql = "SELECT id, name FROM heroes;";

//creating an statment with the query
$stmt = $conn->prepare($sql);

//executing that statment
$stmt->execute();

//binding results for that statment 
$stmt->bind_result($id, $name);

//looping through all the records
while($stmt->fetch()){
	
	//pushing fetched data in an array 
	$temp = [
		'id'=>$id,
		'name'=>$name
	];
	
	//pushing the array inside the hero array 
	array_push($heroes, $temp);
}

//displaying the data in json format 
echo json_encode($heroes);

//these are the server details

//the username is root by default in case of xampp

//password is nothing by default

//and lastly we have the database named android. if your database name is different you have to change it

$servername = "localhost";

$username = "root";

$password = "";

$database = "android";

//creating a new connection object using mysqli

$conn = new mysqli($servername, $username, $password, $database);

//if there is some error connecting to the database

//with die we will stop the further execution by displaying a message causing the error

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

//if everything is fine

//creating an array for storing the data

$heroes = array();

//this is our sql query

$sql = "SELECT id, name FROM heroes;";

//creating an statment with the query

$stmt = $conn->prepare($sql);

//executing that statment

$stmt->execute();

//binding results for that statment

$stmt->bind_result($id, $name);

//looping through all the records

while($stmt->fetch()){

//pushing fetched data in an array

$temp = [

'id'=>$id,

'name'=>$name

];

//pushing the array inside the hero array

array_push($heroes, $temp);

}

//displaying the data in json format

echo json_encode($heroes);

Now when you will open this script in your browser you will see the following.

Fetched JSON

You see we have the data in JSON format. Now our PHP and MySQL part is over, lets move to Android JSON Parsing.

Android JSON Parsing

Creating a new Android Studio Project

First we will create a new Android Studio Project. So create a project with any name using an EmptyActivity.

Creating User Interface

Now we will fetch the data and will display the fetched heroes in a ListView. So for this we will create a ListView in our activity_main.xml.

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context="net.simplifiedlearning.androidjsonparsing.MainActivity">


    <!-- this is our listview where we will display the fetched data --> 
    <ListView
        android:id="@+id/listView"
        android:layout_width="match_parent"
        android:layout_height="match_parent"
        android:layout_alignParentLeft="true"
        android:layout_alignParentStart="true"
        android:layout_alignParentTop="true" />

</RelativeLayout>

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context="net.simplifiedlearning.androidjsonparsing.MainActivity">

<ListView

android:id="@+id/listView"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:layout_alignParentLeft="true"

android:layout_alignParentStart="true"

android:layout_alignParentTop="true" />

</RelativeLayout>

Fetching JSON String from the Server

This is the most important part.
The first thing we need is the URL to our PHP Script that we created. Remember using localhost will not work.
So first open command prompt and write ipconfig command. It will show you some IPs (Make sure your xampp is running).

Accessing Localhost from Emulator

Now you will see some IPs you need to try replacing localhost with these IPs and test whether your emulator can access your host or not.

Accessing Localhost in Emulator

Accessing Localhost from Real Device

If you are having a real device then what you can do is, first connect your real device and computer using your device’s hotspot.
Now again in the list of IPs you have to use the IP of WiFi.

Wireless LAN IP

The Web Service URL

The PHP file that we created is called a Web Service. And we access that service using a URL. So before we used the following URL.

http://localhost/Android/getdata.php

1	http://localhost/Android/getdata.php

But remember using localhost will not work. You have to replace the localhost with the IP that is working in your case. So for my case the URL would be.

http://192.168.101.1/Android/getdata.php

1	http://192.168.101.1/Android/getdata.php

Fetching JSON String

Now we will fetch the JSON String from the server using the URL.
For this we will use an AsyncTask. The following code snippet will explain this.

    //this method is actually fetching the json string
    private void getJSON(final String urlWebService) {
        /*
        * As fetching the json string is a network operation
        * And we cannot perform a network operation in main thread
        * so we need an AsyncTask
        * The constrains defined here are 
        * Void -> We are not passing anything 
        * Void -> Nothing at progress update as well
        * String -> After completion it should return a string and it will be the json string
        * */
        class GetJSON extends AsyncTask<Void, Void, String> {

            //this method will be called before execution
            //you can display a progress bar or something
            //so that user can understand that he should wait 
            //as network operation may take some time 
            @Override
            protected void onPreExecute() {
                super.onPreExecute();
            }

            //this method will be called after execution 
            //so here we are displaying a toast with the json string
            @Override
            protected void onPostExecute(String s) {
                super.onPostExecute(s);
                Toast.makeText(getApplicationContext(), s, Toast.LENGTH_SHORT).show();
            }

            //in this method we are fetching the json string
            @Override
            protected String doInBackground(Void... voids) {
                
                
                
                try {
                    //creating a URL
                    URL url = new URL(urlWebService);
                    
                    //Opening the URL using HttpURLConnection
                    HttpURLConnection con = (HttpURLConnection) url.openConnection();
                    
                    //StringBuilder object to read the string from the service 
                    StringBuilder sb = new StringBuilder();

                    //We will use a buffered reader to read the string from service
                    BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream()));

                    //A simple string to read values from each line
                    String json;
                    
                    //reading until we don't find null
                    while ((json = bufferedReader.readLine()) != null) {
                        
                        //appending it to string builder
                        sb.append(json + "\n");
                    }
                    
                    //finally returning the read string 
                    return sb.toString().trim();
                } catch (Exception e) {
                    return null;
                }

            }
        }

        //creating asynctask object and executing it
        GetJSON getJSON = new GetJSON();
        getJSON.execute();
    }

//this method is actually fetching the json string

private void getJSON(final String urlWebService) {

* As fetching the json string is a network operation

* And we cannot perform a network operation in main thread

* so we need an AsyncTask

* The constrains defined here are

* Void -> We are not passing anything

* Void -> Nothing at progress update as well

* String -> After completion it should return a string and it will be the json string

* */

class GetJSON extends AsyncTask<Void, Void, String> {

//this method will be called before execution

//you can display a progress bar or something

//so that user can understand that he should wait

//as network operation may take some time

@Override

protected void onPreExecute() {

super.onPreExecute();

}

//this method will be called after execution

//so here we are displaying a toast with the json string

@Override

protected void onPostExecute(String s) {

super.onPostExecute(s);

Toast.makeText(getApplicationContext(), s, Toast.LENGTH_SHORT).show();

}

//in this method we are fetching the json string

@Override

protected String doInBackground(Void... voids) {

try {

//creating a URL

URL url = new URL(urlWebService);

//Opening the URL using HttpURLConnection

HttpURLConnection con = (HttpURLConnection) url.openConnection();

//StringBuilder object to read the string from the service

StringBuilder sb = new StringBuilder();

//We will use a buffered reader to read the string from service

BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream()));

//A simple string to read values from each line

String json;

//reading until we don't find null

while ((json = bufferedReader.readLine()) != null) {

//appending it to string builder

sb.append(json + "\n");

}

//finally returning the read string

return sb.toString().trim();

} catch (Exception e) {

return null;

}

//creating asynctask object and executing it

GetJSON getJSON = new GetJSON();

getJSON.execute();

}

Now you can call the above method in onCreate().

getJSON("http://192.168.101.1/Android/getdata.php");

1	getJSON("http://192.168.101.1/Android/getdata.php");

But a network operation requires internet permission as well. So before testing it define internet permission in your AndroidManifest.xml.

    <uses-permission android:name="android.permission.INTERNET" />

1	<uses-permission android:name="android.permission.INTERNET" />

Now run the application and you should see the JSON String.

Fetching JSON

So we have the JSON from server to our Android Device. The only thing remaining now is parsing and reading this JSON. It is also very easy. So lets do this.

Parsing the JSON

This is the last part of this Android JSON Parsing Tutorial. We will parse the JSON and will display it to the ListView.
So for this I have created a new method named loadIntoListView(String json).

    private void loadIntoListView(String json) throws JSONException {
        //creating a json array from the json string
        JSONArray jsonArray = new JSONArray(json);

        //creating a string array for listview
        String[] heroes = new String[jsonArray.length()];

        //looping through all the elements in json array 
        for (int i = 0; i < jsonArray.length(); i++) {
            
            //getting json object from the json array
            JSONObject obj = jsonArray.getJSONObject(i);
            
            //getting the name from the json object and putting it inside string array 
            heroes[i] = obj.getString("name");
        }

        //the array adapter to load data into list 
        ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, heroes);

        //attaching adapter to listview
        listView.setAdapter(arrayAdapter);
    }

private void loadIntoListView(String json) throws JSONException {

//creating a json array from the json string

JSONArray jsonArray = new JSONArray(json);

//creating a string array for listview

String[] heroes = new String[jsonArray.length()];

//looping through all the elements in json array

for (int i = 0; i < jsonArray.length(); i++) {

//getting json object from the json array

JSONObject obj = jsonArray.getJSONObject(i);

//getting the name from the json object and putting it inside string array

heroes[i] = obj.getString("name");

}

//the array adapter to load data into list

ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, heroes);

//attaching adapter to listview

listView.setAdapter(arrayAdapter);

}

Now we will call this method inside onPostExecute() method of AsyncTask.

try {
    loadIntoListView(s);
} catch (JSONException e) {
    e.printStackTrace();
}

try {

loadIntoListView(s);

} catch (JSONException e) {

e.printStackTrace();

}

The complete Code

Now here is the complete code of MainActivity.java.

package net.simplifiedlearning.androidjsonparsing;

import android.os.AsyncTask;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.widget.ArrayAdapter;
import android.widget.ListView;
import android.widget.Toast;

import org.json.JSONArray;
import org.json.JSONException;
import org.json.JSONObject;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.HttpURLConnection;
import java.net.URL;

public class MainActivity extends AppCompatActivity {

    ListView listView;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        listView = (ListView) findViewById(R.id.listView);
        getJSON("http://192.168.101.1/Android/getdata.php");
    }


    private void getJSON(final String urlWebService) {

        class GetJSON extends AsyncTask<Void, Void, String> {

            @Override
            protected void onPreExecute() {
                super.onPreExecute();
            }


            @Override
            protected void onPostExecute(String s) {
                super.onPostExecute(s);
                Toast.makeText(getApplicationContext(), s, Toast.LENGTH_SHORT).show();
                try {
                    loadIntoListView(s);
                } catch (JSONException e) {
                    e.printStackTrace();
                }
            }

            @Override
            protected String doInBackground(Void... voids) {
                try {
                    URL url = new URL(urlWebService);
                    HttpURLConnection con = (HttpURLConnection) url.openConnection();
                    StringBuilder sb = new StringBuilder();
                    BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream()));
                    String json;
                    while ((json = bufferedReader.readLine()) != null) {
                        sb.append(json + "\n");
                    }
                    return sb.toString().trim();
                } catch (Exception e) {
                    return null;
                }
            }
        }
        GetJSON getJSON = new GetJSON();
        getJSON.execute();
    }

    private void loadIntoListView(String json) throws JSONException {
        JSONArray jsonArray = new JSONArray(json);
        String[] heroes = new String[jsonArray.length()];
        for (int i = 0; i < jsonArray.length(); i++) {
            JSONObject obj = jsonArray.getJSONObject(i);
            heroes[i] = obj.getString("name");
        }
        ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, heroes);
        listView.setAdapter(arrayAdapter);
    }
}

package net.simplifiedlearning.androidjsonparsing;

import android.os.AsyncTask;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.widget.ArrayAdapter;

import android.widget.ListView;

import android.widget.Toast;

import org.json.JSONArray;

import org.json.JSONException;

import org.json.JSONObject;

import java.io.BufferedReader;

import java.io.InputStreamReader;

import java.net.HttpURLConnection;

import java.net.URL;

public class MainActivity extends AppCompatActivity {

ListView listView;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

listView = (ListView) findViewById(R.id.listView);

getJSON("http://192.168.101.1/Android/getdata.php");

}

private void getJSON(final String urlWebService) {

class GetJSON extends AsyncTask<Void, Void, String> {

@Override

protected void onPreExecute() {

super.onPreExecute();

}

@Override

protected void onPostExecute(String s) {

super.onPostExecute(s);

Toast.makeText(getApplicationContext(), s, Toast.LENGTH_SHORT).show();

try {

loadIntoListView(s);

} catch (JSONException e) {

e.printStackTrace();

}

@Override

protected String doInBackground(Void... voids) {

try {

URL url = new URL(urlWebService);

HttpURLConnection con = (HttpURLConnection) url.openConnection();

StringBuilder sb = new StringBuilder();

BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(con.getInputStream()));

String json;

while ((json = bufferedReader.readLine()) != null) {

sb.append(json + "\n");

}

return sb.toString().trim();

} catch (Exception e) {

return null;

}

GetJSON getJSON = new GetJSON();

getJSON.execute();

}

private void loadIntoListView(String json) throws JSONException {

JSONArray jsonArray = new JSONArray(json);

String[] heroes = new String[jsonArray.length()];

for (int i = 0; i < jsonArray.length(); i++) {

JSONObject obj = jsonArray.getJSONObject(i);

heroes[i] = obj.getString("name");

}

ArrayAdapter<String> arrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_list_item_1, heroes);

listView.setAdapter(arrayAdapter);

}

Now you can run the application.

Android JSON Parsing

Bingo! It is working absolutely fine.

Android JSON Parsing Source Code Download

If you are having any confusions or troubles following the post, then you can download my source code from below as well.

So thats all for this Android JSON Parsing Tutorial friends. Feel free to leave your comments if having any queries or confusions. Thank You 🙂

About Belal Khan

I am Belal Khan, I am currently pursuing my MCA. In this blog I write tutorials and articles related to coding, app development, android etc.

Comments

siddharth bhardwaj says

July 12, 2015 at 4:31 am

can you please explain how to implement a listview with images whose url is stored in mysql no json files are involved , i am trying to do this but its not working using xampp server.

please respond soon.

Reply
mojtaba says

July 22, 2015 at 6:21 pm

hi
tnx bro for this best tutorial
i’m new developer
i have a mysql database with users table that it has username , password , id
my question is how i can send username and get that username id ????
plz help me 🙁

Reply
Malik says

July 30, 2015 at 6:17 pm

Thank you very much!!!

Reply
imad says

August 8, 2015 at 8:05 am

ALHAMDULILLAH it is WORKING. apparently spaces destroy the php file in my case :/ but THANK YOU 🙂

Reply
- Belal Khan says
  
  August 8, 2015 at 2:44 pm
  
  Your Welcome 🙂
  
  Reply
Aly says

August 17, 2015 at 6:05 am

Exception is :
java lang NullPointerException: Attempt to invoke virtual method ‘int java.lang.String.length()’ on a null object reference

Reply
Ragavi says

August 28, 2015 at 11:00 am

Hai,
I am new to android. Need to retrieve a data from mysql using php based on the user given input in textbox. Can you help me.

Thanks in advance

Reply
nawaziya fathima says

September 16, 2015 at 8:18 am

hi …

i am too can u explain me how to get lat and longitutde stored in database need to retrive in map and to mark that place?????

Reply
Belal Khan says

September 21, 2015 at 8:51 am

Please make you question clear .. I didn’t get you

Reply
Christoph says

September 21, 2015 at 1:06 pm

I just created the same project using the code above, but i get an exception when i press Parse JSON button
ERROR Fatal Exception when calling showData() method. it seems like it return null from the data base

Reply
Cuthbert John says

September 23, 2015 at 3:49 pm

How can i use you code to connect with Recycleview instead of listview

Reply
- Cuthbert John says
  
  September 23, 2015 at 4:06 pm
  
  can you show me some example if any and which code should i change
  
  Reply
Toby says

September 23, 2015 at 5:20 pm

Many Thanks!! It works now! Now I am going to try to make update and delete data.

Reply
Mukesh says

October 5, 2015 at 9:38 am

when i start my apllication .
Unfortunately Listview has stopped
(ListView is my apllication name )
this what an error im facing plz help me out

Reply
- Belal Khan says
  
  October 5, 2015 at 11:29 am
  
  Check the logcat for exact error
  
  Reply
Mohit gaur says

October 8, 2015 at 6:38 pm

Hi sir,thanks for the lovely tutorial.But i have a question.The question is–How to get a particular json(particular data not all),’like only data of a single person whose id is 5′.

Reply
- Belal Khan says
  
  October 12, 2015 at 1:22 am
  
  stay tuned and you will get a tutorial for doing this as well 🙂
  
  Reply
Alex Boey says

October 11, 2015 at 6:59 pm

Can u kindly make the one that has an editText for entering a value or Id then a button that when is clicked , it fetches the specific records and displays. Thank you.

Reply
- Belal Khan says
  
  October 12, 2015 at 1:22 am
  
  Ok I will try to post a tutorial for this soon 🙂
  
  Reply
Varun says

October 14, 2015 at 3:55 pm

Great tutorial. Thanks!
But if possible please post the updated tutorial as well for SDK version 23 and above.

Reply
Mark says

October 21, 2015 at 3:10 am

Thanks Bro It works.

Im working with Login And Display the user information. did you have any tutorial with the same project im working with?. Can you Send here the Link if you have. Thanks . Im looking forward with your updated tutorials.

Reply
M Hussain says

October 22, 2015 at 10:18 am

How to pass detail data into another activity when i click on any Listview record.

Thanks in Advance

Reply
Rasu says

October 22, 2015 at 8:41 pm

Great tutorial 🙂 Keep up the good work dude 🙂

I have some doubts , Can you please post an tutorial on tableview (i.e) Fetch data from database and display it in table format in android . Instead listview can you post it in tableview ? It would be helpful to me 🙂

Thank you dude 🙂

Reply
Marco says

October 23, 2015 at 9:26 pm

Hi Belal, what if I wanted to show the results in a TextView, instead of a ListView?

Reply
uazahar says

November 20, 2015 at 2:20 am

Hello, thank you for your coding. It really helpful for me. Can you help me with onclick item on the listview for simple adapter. Thank you

Reply
tarfa says

February 16, 2016 at 9:48 pm

this is very helpful thank you…

So how to do the same retrieve concept with markers on android using google maps ? To retrieve the lat and lang?

Reply
Kalai says

April 7, 2016 at 5:25 am

This tutorial is very helpful.. What do I do, if I want to assign dynamic checkbox to the listview which is already retrieved from mysql? Pls ans its urgent

Reply
Muhammad Catubig says

April 18, 2016 at 8:17 pm

I’m so glad that I’ve found this tutorial. It solved my problem in life. 🙂 I mean with my android project.

Reply
ratona says

May 10, 2016 at 10:32 am

Nice tutorial, and how to implement progressbar ?

Reply
Roopesh says

October 13, 2017 at 9:23 am

Hello, I am getting following error can anyone help me in solving this

“org.json.JSONException: Value <? of type java.lang.String cannot be converted to JSONArray"

Reply
- Belal Khan says
  
  October 14, 2017 at 6:51 am
  
  Your JSON is invalid.. Check the JSON you are getting from the URL is correct or not.
  
  Reply
SANGWA says

November 26, 2017 at 9:59 pm

Guys, thank you for the simple and straight forwatd code. it runs and am happy ( I had spend days searching but not finding).

Thank yoou very much

Reply
Fidya says

February 24, 2018 at 2:03 pm

hi, i m following ur tutorial, but every statement using “->” in php, always showed in browser n it does not execute. plz help. Thank u

Reply
- LizyLizy says
  
  January 18, 2019 at 9:11 pm
  
  change first php tag <?php
  
  Reply
rianto says

March 4, 2018 at 3:52 am

hey belal, error a java.lang.NullPointerException: Attempt to invoke virtual method ‘int java.lang.String.length()’ on a null object reference
at org.json.JSONTokener.nextCleanInternal(JSONTokener.java:116)

Reply
rianto says

March 4, 2018 at 4:28 am

hey belal erorr java.lang.NullPointerException: Attempt to invoke virtual method ‘int java.lang.String.length()’ on a null object reference at org.json.JSONTokener.nextCleanInternal(JSONTokener.java:116)

Reply
Sooraj S says

March 30, 2018 at 4:53 am

nice tutorial,but in my android project i have an “edit text” based on that i want to fetch and display the result how to do it…
and my php code looks like this:

how to pass datas from android studio and get the required result

Reply
Gourab says

July 10, 2018 at 10:40 am

Thanks. You made my day.

Reply
Ali says

August 25, 2018 at 6:19 pm

LOve u buddy u saved my day 🙂 <3

Reply
halil says

September 9, 2018 at 9:15 am

hi buddy I tried yourcodes it works, but when I call third item from mydatabase ,app doesnt show anything I added “email” item extra to my database its like id,name,email it work only with these two items id and name when ı add 3rd item it doesnt show data to layout pls help thanks 🙂

Reply
Maq says

September 12, 2018 at 7:41 pm

Dear Belal

How do you pass parameters to the URL? For example, if I have to pass user_id to the table and retrieve some data. Thanks.

Reply
Swechchha jain says

November 3, 2018 at 4:13 pm

Hlo sir if got.. NullpointerException in int java. Lang. String. Lengh() on null object reference

Reply
berihun hadis says

November 8, 2018 at 12:13 pm

very helpful keep it up.

thank you!

Reply
Faizan says

January 23, 2019 at 11:35 am

Awesome blog. Your way of explanation is too good make this so easy to understand 🙂

Reply

Android JSON Parsing – Retrieve From MySQL Database

What is JSON?

JSON Object

JSON Array

Fetching Data from MySQL using PHP

The Database Table

Fetching from the Table in JSON Format

Android JSON Parsing

Creating a new Android Studio Project

Creating User Interface

Fetching JSON String from the Server

Accessing Localhost from Emulator

Accessing Localhost from Real Device

The Web Service URL

Fetching JSON String

Parsing the JSON

The complete Code

Android JSON Parsing Source Code Download

Related

About Belal Khan

Comments

Leave a Reply to berihun hadis Cancel reply

About Simplified Coding

Quick Links

What is JSON?

JSON Object

JSON Array

Fetching Data from MySQL using PHP

The Database Table

Fetching from the Table in JSON Format

Android JSON Parsing

Creating a new Android Studio Project

Creating User Interface

Fetching JSON String from the Server

Accessing Localhost from Emulator

Accessing Localhost from Real Device

The Web Service URL

Fetching JSON String

Parsing the JSON

The complete Code

Android JSON Parsing Source Code Download

Sharing is Caring:

Related

About Belal Khan

Comments

Leave a Reply to berihun hadis Cancel reply

About Simplified Coding

Quick Links

Categories