Android MySQL - Best GridView Examples.

Android MySQL GridView Examples and Tutorials.

MySQL is our database while PHP is the server side language we use. The client code is for android is written in this case in either Java or Kotlin.

GridView is our component.

But first:

What is a GridView?

A gridview is an adapterview that shows items in a two-dimensional grid.

Android GridView

These grids are scrollable. GridView is an adapterview because it works with adapters. Adapters can then bind data to the gridview.

This is important because then it means that the gridview is decoupled from it's data source. So you can customize the gridview as you like without interfering with the data source. You can also work on the data source without affecting the visual appearance of the gridview.

GridView derives from AbsListview.

public class GridView extends android.widget.AbsListView{}

Both reside in the android.widget packages.

AbsListview is an abstract class and you won't use in directly. You'll use it in case you want to implement your own custom view with unique properties.

Even the sister of GridView which is ListView also directly derives from AbsListview. So AbsListview is a base class. It's used to implement virtualized list of items. Given it's virtualized you can implement it to show lists in various forms:

  • Lists -vertical and horizontal
  • Grids
  • Carousel
  • Stack

And so on.

Top Android MySQL GridView Examples

Let's look at some examples.

This is a an android mysql tutorial. Our widget is the gridview. We see how to select data and show in a gridview.

  1.  Create your MySQL database,table and columns in Wamp Server with PHPMyAdmin.
  2.  Write small PHP scripts to fetch data from our MySQL database and encode it to JSON format..
  3. Connect using HttpUrlConnection.
  4. Fetch our JSON data and parse it.
  5.  Show the items in GridView.

Android MySQL images and Text tutorial with GridView. This is our continuation of Android MySQL series.

In this class we are going to store image URLs in MySQL database. Then when we load our data the URLs get retrieved as well, then get loaded by Picasso hence loading our images.

Storing image urls is more efficient than storing image blobs hence that's why we store them instead of actual images.

Moreover, we can easily add update or delete those image urls efficiently. Furthermore, Picasso ImageLoader will cache our images on the device hence we won't have to everytime be downloading the images hence saving the user the bandwith.

Let's go.


How do You Feel after reading this?

According to scientists, we humans have 8 primary innate emotions: joy, acceptance, fear, surprise, sadness, disgust, anger, and anticipation. Feel free to tell us how you feel about this article using these emotes or via the comment section. This feedback helps us gauge our progress.

Help me Grow.

I set myself some growth ambitions I desire to achieve by this year's end regarding this website and my youtube channel. Am halfway. Help me reach them by:


What do You Think

Previous Post Next Post