Retrieve Data From MySQL Database in Android using Volley

January 6, 2021October 13, 2015 by Belal Khan

Hey guys, in this post we are going to learn how to Retrieve Data from MySQL Database in Android. And for this we will be using Volley Library. I have already posted a number of tutorials about Volley, PHP and MySQL. This post is specifically about retrieving data from MySQL Database in Android. So lets begin.

Table of Contents

1 MySQL Database
2 Retrieving Data as JSON from Table
3 Retrieve Data From MySQL Database in Android

MySQL Database

So guys this is my database table and I will fetch the data from here.

We already have some rows inserted in the above table. And our task here is to fetch those records in our Android Application. If you want you can get my database from below.

MySQL Table

Retrieving Data as JSON from Table

Here I am using (XAMPP) so for the PHP side create a folder inside htdocs (C:/xampp/htdocs). I created MyApi.
Inside this folder create a file named Api.php and write the following code.

<?php

* Created by Belal Khan

* website: www.simplifiedcoding.net

* Retrieve Data From MySQL Database in Android

//database constants

define('DB_HOST', 'localhost');

define('DB_USER', 'root');

define('DB_PASS', 'password');

define('DB_NAME', 'simplifiedcoding');

//connecting to database and getting the connection object

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

//Checking if any error occured while connecting

if (mysqli_connect_errno()) {

echo "Failed to connect to MySQL: " . mysqli_connect_error();

die();

}

//creating a query

$stmt = $conn->prepare("SELECT id, title, shortdesc, rating, price, image FROM products;");

//executing the query

$stmt->execute();

//binding results to the query

$stmt->bind_result($id, $title, $shortdesc, $rating, $price, $image);

$products = array();

//traversing through all the result

while($stmt->fetch()){

$temp = array();

$temp['id'] = $id;

$temp['title'] = $title;

$temp['shortdesc'] = $shortdesc;

$temp['rating'] = $rating;

$temp['price'] = $price;

$temp['image'] = $image;

array_push($products, $temp);

}

//displaying the result in json format

echo json_encode($products);

Now trying opening this PHP file in your browser. You will see the following output.

Now we will use this URL in our android side to get the above JSON data.
But remember you cannot use localhost in your URL. You need to find your IP and you can find it using ipconfig command in windows and ifconfig command in linux or mac.
In my case the URL is: http://192.168.101.1/MyApi/Api.php

Retrieve Data From MySQL Database in Android

Creating a new Android Project

So lets create a new Android Studio project where we will display the data fetched from MySQL.
Once your project is created you need to add the dependencies.

Dependencies Required

We will use
- RecyclerView for creating the Product List that we are getting as JSON.
- Glide to load image from URL.
- Volley to get the JSON data from URL.

Adding Required Dependencies

Add the following lines inside your app level build.gradle file.

dependencies {

compile fileTree(include: ['*.jar'], dir: 'libs')

androidTestCompile('com.android.support.test.espresso:espresso-core:2.2.2', {

exclude group: 'com.android.support', module: 'support-annotations'

})

compile 'com.android.support:appcompat-v7:26.+'

compile 'com.android.support.constraint:constraint-layout:1.0.2'

testCompile 'junit:junit:4.12'

//add these for lines

compile 'com.android.volley:volley:1.1.0-rc1'

compile 'com.android.support:recyclerview-v7:26.0.0-alpha1'

compile 'com.github.bumptech.glide:glide:4.2.0'

annotationProcessor 'com.github.bumptech.glide:compiler:4.2.0'

}

Now modify the project level gradle file as shown below.

allprojects {

repositories {

jcenter()

//add these two lines here

mavenCentral()

maven { url 'https://maven.google.com' }

}

Now sync your project and you are done.

Creating Interfaces

First we will create a RecyclerView inside 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.volleymysqlexample.MainActivity">

<android.support.v7.widget.RecyclerView

android:id="@+id/recylcerView"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:layout_editor_absoluteX="745dp"

tools:layout_editor_absoluteY="-51dp" />

</RelativeLayout>

Now we will create a new layout resource file named product_list.xml inside the layout folder. This is for our list item.

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

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

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical">

<RelativeLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:padding="8dp">

<ImageView

android:id="@+id/imageView"

android:layout_width="120dp"

android:layout_height="90dp"

android:padding="4dp" />

<TextView

android:id="@+id/textViewTitle"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_marginLeft="5dp"

android:layout_toRightOf="@id/imageView"

android:text="Apple MacBook Air Core i5 5th Gen - (8 GB/128 GB SSD/Mac OS Sierra)"

android:textAppearance="@style/Base.TextAppearance.AppCompat.Small"

android:textColor="#000000" />

<TextView

android:id="@+id/textViewShortDesc"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_below="@id/textViewTitle"

android:layout_marginLeft="5dp"

android:layout_marginTop="5dp"

android:layout_toRightOf="@id/imageView"

android:text="13.3 Inch, 256 GB"

android:textAppearance="@style/Base.TextAppearance.AppCompat.Small" />

<TextView

android:id="@+id/textViewRating"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_below="@id/textViewShortDesc"

android:layout_marginLeft="5dp"

android:layout_marginTop="5dp"

android:layout_toRightOf="@id/imageView"

android:background="@color/colorPrimary"

android:paddingLeft="15dp"

android:paddingRight="15dp"

android:text="4.7"

android:textAppearance="@style/Base.TextAppearance.AppCompat.Small.Inverse"

android:textStyle="bold" />

<TextView

android:id="@+id/textViewPrice"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_below="@id/textViewRating"

android:layout_marginLeft="5dp"

android:layout_marginTop="5dp"

android:layout_toRightOf="@id/imageView"

android:text="INR 56990"

android:textAppearance="@style/Base.TextAppearance.AppCompat.Large"

android:textStyle="bold" />

</RelativeLayout>

</LinearLayout>

It will create the following output.

Creating Model

To keep the product we will create a class that will contain all the product attributes. So create a class named Product and write the following code.

package net.simplifiedlearning.volleymysqlexample;

/**

* Created by Belal on 10/18/2017.

public class Product {

private int id;

private String title;

private String shortdesc;

private double rating;

private double price;

private String image;

public Product(int id, String title, String shortdesc, double rating, double price, String image) {

this.id = id;

this.title = title;

this.shortdesc = shortdesc;

this.rating = rating;

this.price = price;

this.image = image;

}

public int getId() {

return id;

}

public String getTitle() {

return title;

}

public String getShortdesc() {

return shortdesc;

}

public double getRating() {

return rating;

}

public double getPrice() {

return price;

}

public String getImage() {

return image;

}

Creating Product Adapter

Now for RecyclerView we will create a ProductAdapter.java. I already posted about RecyclerView so you can learn about it in detail from this RecyclerView Tutorial.

package net.simplifiedlearning.volleymysqlexample;

import android.content.Context;

import android.support.v7.widget.RecyclerView;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.ImageView;

import android.widget.TextView;

import com.bumptech.glide.Glide;

import java.util.List;

/**

* Created by Belal on 10/18/2017.

public class ProductsAdapter extends RecyclerView.Adapter<ProductsAdapter.ProductViewHolder> {

private Context mCtx;

private List<Product> productList;

public ProductsAdapter(Context mCtx, List<Product> productList) {

this.mCtx = mCtx;

this.productList = productList;

}

@Override

public ProductViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {

LayoutInflater inflater = LayoutInflater.from(mCtx);

View view = inflater.inflate(R.layout.product_list, null);

return new ProductViewHolder(view);

}

@Override

public void onBindViewHolder(ProductViewHolder holder, int position) {

Product product = productList.get(position);

//loading the image

Glide.with(mCtx)

.load(product.getImage())

.into(holder.imageView);

holder.textViewTitle.setText(product.getTitle());

holder.textViewShortDesc.setText(product.getShortdesc());

holder.textViewRating.setText(String.valueOf(product.getRating()));

holder.textViewPrice.setText(String.valueOf(product.getPrice()));

}

@Override

public int getItemCount() {

return productList.size();

}

class ProductViewHolder extends RecyclerView.ViewHolder {

TextView textViewTitle, textViewShortDesc, textViewRating, textViewPrice;

ImageView imageView;

public ProductViewHolder(View itemView) {

super(itemView);

textViewTitle = itemView.findViewById(R.id.textViewTitle);

textViewShortDesc = itemView.findViewById(R.id.textViewShortDesc);

textViewRating = itemView.findViewById(R.id.textViewRating);

textViewPrice = itemView.findViewById(R.id.textViewPrice);

imageView = itemView.findViewById(R.id.imageView);

}

Fetching JSON and Displaying it in RecyclerView

Now the last step is fetching the JSON response from URL and display it to RecyclerView.
So come inside MainActivity.java and write the following code.

100

101

102

103

104

105

106

package net.simplifiedlearning.volleymysqlexample;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.support.v7.widget.LinearLayoutManager;

import android.support.v7.widget.RecyclerView;

import com.android.volley.Request;

import com.android.volley.Response;

import com.android.volley.VolleyError;

import com.android.volley.toolbox.StringRequest;

import com.android.volley.toolbox.Volley;

import org.json.JSONArray;

import org.json.JSONException;

import org.json.JSONObject;

import java.util.ArrayList;

import java.util.List;

public class MainActivity extends AppCompatActivity {

//this is the JSON Data URL

//make sure you are using the correct ip else it will not work

private static final String URL_PRODUCTS = "http://192.168.101.1/MyApi/Api.php";

//a list to store all the products

List<Product> productList;

//the recyclerview

RecyclerView recyclerView;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

//getting the recyclerview from xml

recyclerView = findViewById(R.id.recylcerView);

recyclerView.setHasFixedSize(true);

recyclerView.setLayoutManager(new LinearLayoutManager(this));

//initializing the productlist

productList = new ArrayList<>();

//this method will fetch and parse json

//to display it in recyclerview

loadProducts();

}

private void loadProducts() {

* Creating a String Request

* The request type is GET defined by first parameter

* The URL is defined in the second parameter

* Then we have a Response Listener and a Error Listener

* In response listener we will get the JSON response as a String

* */

StringRequest stringRequest = new StringRequest(Request.Method.GET, URL_PRODUCTS,

new Response.Listener<String>() {

@Override

public void onResponse(String response) {

try {

//converting the string to json array object

JSONArray array = new JSONArray(response);

//traversing through all the object

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

//getting product object from json array

JSONObject product = array.getJSONObject(i);

//adding the product to product list

productList.add(new Product(

product.getInt("id"),

product.getString("title"),

product.getString("shortdesc"),

product.getDouble("rating"),

product.getDouble("price"),

product.getString("image")

));

}

//creating adapter object and setting it to recyclerview

ProductsAdapter adapter = new ProductsAdapter(MainActivity.this, productList);

recyclerView.setAdapter(adapter);

} catch (JSONException e) {

e.printStackTrace();

}

new Response.ErrorListener() {

@Override

public void onErrorResponse(VolleyError error) {

}

});

//adding our stringrequest to queue

Volley.newRequestQueue(this).add(stringRequest);

}

Adding Internet Permission

Lastly add internet permission in your AndroidManifest.xml file.

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

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

package="net.simplifiedlearning.volleymysqlexample">

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

<application

android:allowBackup="true"

android:icon="@mipmap/ic_launcher"

android:label="@string/app_name"

android:roundIcon="@mipmap/ic_launcher_round"

android:supportsRtl="true"

android:theme="@style/AppTheme">

<intent-filter>

</intent-filter>

</activity>

</application>

</manifest>

Now you can run your application.

Bingo! It is working absolutely fine.
Now if you want you can download my source code from the below given link.

Retrieve Data from MySQL Database in Android Source Code

So thats all for this tutorial friends. Hope you got the point how to retrieve data from mysql database in android. If you are having any confusions or queries you can leave your comments below. Thank You 🙂

Belal Khan

Hi, my name is Belal Khan and I am a Google Developers Expert (GDE) for Android. The passion of teaching made me create this blog. If you are an Android Developer, or you are learning about Android Development, then I can help you a lot with Simplified Coding.

Checkout these tutorials as well:

71 thoughts on “Retrieve Data From MySQL Database in Android using Volley”

Arpita Siddiquee
May 18, 2016 at 10:47 am
Thank You for your code instruction.It really helps me.
Reply
damodar
June 23, 2017 at 12:49 pm
Thanks a lot I’m getting the Result
Reply
jeniel deguzman
October 27, 2017 at 1:39 am
Error:(1, 0) Cause: com/android/build/gradle/AppPlugin : Unsupported major.minor version 52.0
Open File
this my error please help i open the project to android studio
Reply
Amlan Bhuyan
November 4, 2017 at 5:18 pm
When I rotate the screen, the data gets reloaded. How to solve that ? Is there any way to implement Loaders as is done in AsyncTask to avoid reloading of data.
Reply
- Jessica Farias
  May 21, 2018 at 7:41 am
  you need to save data before goes to “On Create” when you use a save data in OnSavedInstanceState.
  ///onSaveInstanceState
  @Override
  protected void onSaveInstanceState(Bundle outState) {
  super.onSaveInstanceState(outState);
  outState.putInt(“TagDataToSave”,DataToSave);
  }
  ////OnCreate Code
  @Override
  protected void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.activity_main);
  if(savedInstanceState!=null)
  {
  TagDataToSave=savedInstanceState.getInt(“DataToSave”);
  }
  else
  {
  TagDataToSave=10;//To OnCreate on a first time
  }
  }
  Reply
shareen
November 17, 2017 at 9:43 am
can i get a php code for its retreival ???
Reply
sujaffar ali khan
November 22, 2017 at 5:26 am
in this list if i want to perform filter with user data like user will click on a option then that data will goes to server and give a response on this list.plz help me
Reply
- Belal Khan
  November 22, 2017 at 1:35 pm
  I will try to make a new video for your query, ASAP.
  Reply
  - anthonymejias
    September 28, 2018 at 5:10 am
    hi. can you help me to make my ip not static or the users will input the ip of their server ? thank you
    Reply
Rahul
November 24, 2017 at 4:38 pm
Also I want to save all listview data to mysql in one click as like e-commerce cart data plz help
Reply
Dan
November 30, 2017 at 9:01 am
am not getting any error but not displaying the values from the database to the recyclerview but the php file is displaying the data on the browser
Reply
Jose
December 13, 2017 at 12:15 pm
Hi man thanks a lot for the tutorial u are awesome.
Would u help me with this one.
I want to write an application that fetches data from database using either Volley or Okhttp.
So what i want to achieve is a multi list view.
1.first list view is for fetching albums with images and text
2.second list view Fetches songs under a particular album–they also contain images and text
3.third screen gives full information of a song –they also contain images and text
Can u do a tutorial on this one. Thanks your help.
Reply
Banwari Lal
December 21, 2017 at 4:17 am
Sir Will It is possible to retrieve, update or delete data using Java/Kotlin in Android Studio directly from MSSQl server ?.
Reply
- Belal Khan
  December 22, 2017 at 2:13 pm
  No you cannot do it directly.. to do it direcly mysql server should be available in your android device
  Reply
shaista ambreen
December 25, 2017 at 9:48 am
can i have button along with the each list of listview???
Reply
- Belal Khan
  December 27, 2017 at 6:57 am
  Yes obviously you can put whatever you want
  Reply
ronit pradhan
January 3, 2018 at 2:23 am
I want to retrieve only the image that too by email as a login profile so, should i use array in php to fetch the image?
Reply
aryan
January 9, 2018 at 12:25 pm
Every Thing is ok but data not displaying on Activity please reply
Reply
- vicky
  January 14, 2018 at 7:57 am
  check the ip address in the main activity page
  to know whats your ip
  type ipconfig in command prompt
  Reply
Rahul
January 11, 2018 at 4:37 am
Hi,
Thanks for your tutorial. I am getting below error :
org.json.JSONException: Value >>>”+jsonObject.toString(), Toast.LENGTH_LONG).show();
// Log.i(TAG,”Status >>”+jsonObject.getBoolean(“status”));
if (jsonObject.getBoolean(“status”)) {
Toast.makeText(MainActivity.this, “Success occurred..\n” + jsonObject.toString(), Toast.LENGTH_LONG).show();
}else{
Toast.makeText(MainActivity.this, “Else occurred..\n” + jsonObject.toString(), Toast.LENGTH_LONG).show();
}
} catch (JSONException e) {
e.printStackTrace();
}
}
Please help.
Reply
gunjan
February 20, 2018 at 7:49 am
Thanks for the code Sir …
But what if i want to use spinner and select one category and fetch data for specific column according to the selected category?? please answer me sir
Thanks in Advance
Reply
suranto
March 1, 2018 at 5:52 am
Hi sir, i wan ask, how to limit data from mysql in display in AS. for example i wont display data only 5.
thanks
Reply
ganesh
March 3, 2018 at 2:42 pm
E/dalvikvm: Could not find class ‘android.graphics.drawable.RippleDrawable’, referenced from method android.support.v7.widget.AppCompatImageHelper.hasOverlappingRendering
error aa raha he
Reply
greg
March 9, 2018 at 9:11 pm
can ‘t fetch any data but i have all data to retrieve but no error! please help
Reply
Reuel
March 27, 2018 at 5:06 pm
My image doesn’t seem to load.. I need some help…
Reply
Haseeb
April 7, 2018 at 9:51 am
Hey, can i get data from online MySQL server(means from my online website database)?
if yes, what link i will give in the code??
you have given ip address of computer, what will be the link i will add in code to access data from database??
Waiting for your reply.
Reply
cincao
April 11, 2018 at 1:31 am
Hey bro, can i know how to fetch specific data from the table? For example, fetch only the current user data.
Reply
farshid
May 13, 2018 at 8:45 am
Hi,
I have this error:
error: class ProductsAdapter is public, should be declared in a file named ProductsAdapter.java
Reply
- davie
  July 18, 2018 at 9:48 am
  Make sure you rename your Java class from ProductAdapter to ProductsAdapter.
  Reply
Alain
May 28, 2018 at 1:34 pm
Hi,
Thank’s for your tutorial but I have a problem by fetching the datas.
The products array seems to be created and the temp one also. The php scripts walks through the “while”, but the either the array_push or the last echo don’t show me any result.
Another problem is that I’m in France and the accents like “é” don’t appear in the fields.
May you help me ?
Reply
mamatha
June 25, 2018 at 6:46 am
am not getting any error but not displaying the values from the database to the recyclerview but the php file is displaying the data on the browser why is it so
Reply
ayie
July 23, 2018 at 5:08 am
sir i got no error but not display data from the server? can help me
Reply
- raja
  August 17, 2018 at 6:48 am
  did you solve? i get same error
  Reply
  - sandie
    July 4, 2020 at 4:57 pm
    did you solved this?
    Reply
    - Bhakti
      February 2, 2021 at 7:41 pm
      Omg same. Could anyone solve it?
      Reply
    - anna
      February 6, 2021 at 1:42 pm
      Was anyone able to solve this issue?
      Reply
      - indra
        October 3, 2022 at 12:55 pm
        still not display 🙁
John
August 7, 2018 at 8:42 pm
Hi, thank you for the tutorial. Really appreciate it. Can you help me please? I’ve gone through the tutorial and it works fine, but I’d like filter the recyclerview based on store_id, for example: a list of products but only view products by selected store…
Reply
Pokhraj
August 14, 2018 at 11:43 am
Hello Sir,I m new to MySQL actually I want to ask that should my PC be on all the time if I fetch data or upload that to my database.
Reply
edward
August 15, 2018 at 6:06 pm
please I have really learnt a lot from your post and must say its great. now i need some help am developing an app
1. user enter – let say : location and region in different edit text views and submits query
2. result should display all hospitals in that location and region in a list view but a radio button form and check box.
3. from here the user has to select one and press a button to send it.
4. before the activity is sent, it is sending to the select hospitals email address
5. so the app so be able to select to email of the selected hospital and by pressing the submit button an email is sent to the hospital.
can you please guide me to achieve this task thanks
Reply
Mohmmad
August 16, 2018 at 10:29 pm
Hi, when I change the phone language to Arabic nothing display just the image, return to the English language show all data.
I can’t find where the error is. Mysql database is utf8_unicode_ci , how can I Retrieve Data and display it in Arabic.
Reply
raja
August 17, 2018 at 7:08 am
Hai sir,i got no error but not display data from the server?help me
Reply
Taaha
September 8, 2018 at 8:16 am
can i get code for update and delete ?
Reply
Matthew Verendia
September 22, 2018 at 5:05 pm
No error but I’m getting no display only black white screen when i run, I’ve also tried it on emulator, pls help.
Reply
CAYO
October 27, 2018 at 5:41 pm
hi my app doesn’t show anything but I don’t have any mistake, Could you help me?
Reply
- Delnet
  November 26, 2018 at 11:14 am
  Had same challenge, Make sure you are on internet and IP address of your API is correct.
  Reply
Raja
November 13, 2018 at 1:01 pm
Hai, How can i store image as url?
Reply
Delnet
November 26, 2018 at 11:17 am
Thanks for the Videos, i have learnt a lot in a short time.
Reply
Abhishek Kumar
December 13, 2018 at 9:38 am
Thank You your all instructions helped me a lot in learning new things.
Reply
Darshit Anjaria
December 20, 2018 at 12:18 pm
Hey there it’s a great tutorial thanks for that, but here I stucked an error occurs that is, “E/RecyclerView: No adapter attached; skipping layout” whenever I run my code in an physical device, but when I run my code in emulator it’ s work fine so what is the reason behind that and what is the solution?, Please help!
Reply
MANKo
January 21, 2019 at 7:36 am
The Data is being displayed but it says in the logcat that “No Adapter Attached; Skiiping Layout” . I am stuck for days on this one please help me! Thank you…
Reply
Golden Chimusinde
January 26, 2019 at 10:35 pm
To start with, I want to say thank you for these amazing Tuts, but my question is:
Suppose I want to view the data from MYSQL (The One I have displayed on my Android Device) offline, how can I modify the code above.
I would also appreciate if you can point me to the actual tut that has this information.
My Main goal is to create an app that synchronises both ways (maintaining a perfectly synched and updated database in MYSQL & SQLite and either of the changed on these database should be seemlessly appended to them both)
Reply
- Belal Khan
  February 22, 2019 at 12:11 pm
  I will try to post a tutorial that will teach you how you can manage data persistence.
  Reply
komeil
February 7, 2019 at 3:55 am
hi thanks,
If a deceiving person decompile the apk, it will access this get json data URL , which means accessing all json data inside the database. what’s the solution?
Reply
Ermyas
February 16, 2019 at 11:34 am
Error:Execution failed for task ‘:app:packageAllDebugClassesForMultiDex’.
> java.util.zip.ZipException: duplicate entry: android/support/v4/hardware/display/DisplayManagerCompat.class
when i build the project it is fine but when i run it, it shows this error, please any solution for this
Reply
Shaikh Taha
February 22, 2019 at 4:11 pm
Thanks Belal for help.
It Worked for me after removing some Exception.. ?.
But I Am Facing One Issue With My API.php It’s Running Well On LocalHost But When I Upload It To My Online Server Its Just Run For First Time And Returning The Same Result Again And Again .. PLEASE HELP ME .
Thank You.
Reply
Sebastian
March 1, 2019 at 10:21 pm
Hello, I am having a problem with the function execute on the Api.
Its giving me this message>
Fatal error: Uncaught Error: Call to a member function execute() on bool in C:\xampp\htdocs\MyApi\api.php:23 Stack trace: #0 {main} thrown in C:\xampp\htdocs\MyApi\api.php on line 23
How I can fix this?
Reply
- prasad mummidi
  June 28, 2020 at 10:21 am
  hi plz check ur table name. may be it is wrong
  Reply
Anandita Sharma
May 17, 2019 at 11:42 am
E/RecyclerView: No adapter attached; skipping layout
Sir,I m getting this error although I have set the adapter.
Reply
- Belal Khan
  May 21, 2019 at 2:22 pm
  Make sure your list contains some values, try checking the size of the list after fetching the data from api.
  Reply
  - junaid
    July 4, 2019 at 6:16 pm
    its still not working , E/RecyclerView: No adapter attached; skipping layout
    Reply
    - Belal Khan
      July 16, 2019 at 2:28 am
      You should check the video tutorial for detailed explanation. So try this: https://www.youtube.com/playlist?list=PLk7v1Z2rk4hhYrhtRtAX2zVm-FHV38-TQ
      Reply
sam
July 27, 2019 at 8:30 am
how can you select specific item from database and load them in the recyclerview
like select from * tablename where phone number = the user specify in the android app
Reply
- Brunho
  March 16, 2020 at 4:50 pm
  Me too I want to know how it’s done.
  If anyone here can advise us or give us where we can find help
  Reply
joel Mbaasa
September 8, 2020 at 11:40 am
This is awesome Sir , thanks a lot .IT WORKED
Reply
- Dale
  December 30, 2020 at 5:48 pm
  sir can i download your project because it does not work for me no data is shown in my app
  Reply
tharun
October 21, 2020 at 8:49 am
Good Tutorial.
What if we use CodeIgniter in place of core PHP?
Reply
- Belal Khan
  November 16, 2020 at 5:15 am
  You can use it, its your choice. The android side do not cares about what you are using in the server.
  Reply
abbas
September 22, 2021 at 5:07 am
u are a Hero.
thanks a lot
Reply
Kyle
April 15, 2022 at 4:53 pm
how to display it in a fragment?
Reply
Rama
October 6, 2022 at 4:47 am
incompatible types: int cannot be converted to String
StringRequest stringRequest = new StringRequest(Request.Method.GET, BASE_URL,
the method GET is Int. can solve my error?
Reply

Retrieve Data From MySQL Database in Android using Volley

MySQL Database

Retrieving Data as JSON from Table

Retrieve Data From MySQL Database in Android

Creating a new Android Project

Dependencies Required

Adding Required Dependencies

Creating Interfaces

Creating Model

Creating Product Adapter

Fetching JSON and Displaying it in RecyclerView

Adding Internet Permission

Related

Checkout these tutorials as well:

71 thoughts on “Retrieve Data From MySQL Database in Android using Volley”

Leave a Comment Cancel reply