<?php
$servername = "localhost";
$username = "hasanain";
$password = "";
$dbname = "customer";

$conn = mysqli_connect($servername, $username, $password, $dbname);

if(!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}
?>

<?php
include_once("connection.php");

$query1 = "SELECT * FROM tbl_product";
$result1 = mysqli_query($conn, $query1);

while($row = mysqli_fetch_assoc($result1)){
    $data[] = $row;
}
echo json_encode($data);
?>

import java.io.Serializable;

public class Items implements Serializable {
public int pid;
public String name;
public String panorama;
public double price;
public String profile_picture;
public int user_id;

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public String getPanorama() {
    return panorama;
}

public void setPanorama(String panorama) {
    this.panorama = panorama;
}

public double getPrice() {
    return price;
}

public void setPrice(double price) {
    this.price = price;
}

public int getUser_id() {
    return user_id;
}

public void setUser_id(int user_id) {
    this.user_id = user_id;
}
}

import android.content.Context;
import android.support.v7.widget.CardView;
import android.support.v7.widget.RecyclerView;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.view.animation.Animation;
import android.view.animation.AnimationUtils;
import android.widget.ImageView;
import android.widget.TextView;

import com.squareup.picasso.Picasso;
import java.util.ArrayList;

public class ItemsAdapter extends RecyclerView.Adapter<ItemsAdapter.ItemsViewHolder> {

int LastPosition = -1;
private Context context;
private
ArrayList<Items> Items;

public ItemsAdapter(Context context, ArrayList<Items> Items) {
    this.context = context;
    this.Items = Items;
}

@Override
public ItemsViewHolder onCreateViewHolder(ViewGroup parent, int viewType) {
    LayoutInflater inflater = LayoutInflater.from(parent.getContext());
    View view = inflater.from(parent.getContext()).inflate(R.layout.card_view_product_one, parent, false);

    ItemsViewHolder itemsViewHolder = new ItemsViewHolder(view);
    return itemsViewHolder;
}

@Override
public void onBindViewHolder(ItemsViewHolder holder, int position) {

    Items product = Items.get(position);
    holder.text_name.setText(product.name);
    //holder.user_id.setText(String.valueOf(Integer.toString(product.pid)));
    holder.user_id.setText(String.valueOf(Integer.toString(product.user_id)));

    String fullUrl = product.profile_picture;
    Picasso.with(context).load(fullUrl).placeholder(R.drawable.ic_icon).error(android.R.drawable.stat_notify_error).into(holder.image_view_item);

    if (position > LastPosition) {

        Animation animation = AnimationUtils.loadAnimation(context,
                R.anim.up_from_bottom);
        holder.itemView.startAnimation(animation);
        LastPosition = position;
    }
}

@Override
public int getItemCount() {
    if (Items != null) {
        return Items.size();
    }
    return 0;
}

public static class ItemsViewHolder extends RecyclerView.ViewHolder {

    public CardView card_view_item;
    public ImageView image_view_item;
    public TextView text_name;
    public TextView user_id;

    public ItemsViewHolder(View itemView) {
        super(itemView);

        card_view_item = (CardView) itemView.findViewById(R.id.card_view_item);
        image_view_item = (ImageView) itemView.findViewById(R.id.image_view_item);
        text_name = (TextView) itemView.findViewById(R.id.text_name);
        user_id = (TextView) itemView.findViewById(R.id.user_id);

    }
}
}

import android.app.Activity;
import android.app.ProgressDialog;
import android.content.Intent;
import android.os.Bundle;
import android.support.v7.widget.GridLayoutManager;
import android.support.v7.widget.RecyclerView;
import android.support.v7.widget.Toolbar;
import android.util.Log;
import android.view.View;
import android.widget.Toast;

import com.android.volley.Request;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;
import com.packegename.ImageLoader.MySingleton;
import com.packegename.RecyclerView.RecyclerClickListener;
import com.packegename.RecyclerView.RecyclerTouchListener;
import com.packegename.Another.AnotherActivity;
import com.packegename.SqlPhpAdapterRecyclerView.Items;
import com.packegename.SqlPhpAdapterRecyclerView.ItemsAdapter;
import com.packegename.Utils.Utils;
import com.kosalgeek.android.json.JsonConverter;

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

import java.util.ArrayList;

public class MainActivity extends Activity {

private static final String TAG = "MainActivity";
RecyclerView recyclerView;
String url = "http://192.168.0.108/customer/product.php";

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

    Toolbar toolbar = (Toolbar) findViewById(R.id.toolbar);
    toolbar.setTitle("Barber");

    LoadData();
}

private void LoadData() {
    ProgressDialog progressDialog = new ProgressDialog(Barber.this);
    progressDialog.setMessage("Please wait ...");
    progressDialog.setCancelable(true);
    progressDialog.setProgressStyle(ProgressDialog.STYLE_SPINNER);
    progressDialog.setIndeterminate(true);
    progressDialog.show();

    if (getNetworkAvailability()) {
        getData();
        progressDialog.dismiss();
    } else {
        //getFeedFromDatabase();
        Toast.makeText(getApplicationContext(), "No internet connection!", Toast.LENGTH_LONG).show();
    }
}

private boolean getNetworkAvailability() {
    return Utils.isNetworkAvailable(getApplicationContext());
}

private void getData() {
    recyclerView = (RecyclerView) findViewById(R.id.recyclerView);
    //LinearLayoutManager manager = new LinearLayoutManager(this);
    //RecyclerView.LayoutManager manager = new StaggeredGridLayoutManager(2, StaggeredGridLayoutManager.VERTICAL);
    RecyclerView.LayoutManager manager = new GridLayoutManager(Barber.this, 2);
    recyclerView.setLayoutManager(manager);


    StringRequest stringRequest = new StringRequest(Request.Method.GET, url,
            new Response.Listener<String>() {
                @Override
                public void onResponse(final String response) {
                    Log.d(TAG, response);

                    ArrayList<Items> ItemsList = new JsonConverter<Items>().toArrayList(response, Items.class);
                    ItemsAdapter adapter = new ItemsAdapter(getApplicationContext(), ItemsList);
                    recyclerView.setAdapter(adapter);
                    recyclerView.setHasFixedSize(true);

                    RecyclerTouchListener recyclerTouchListener = new RecyclerTouchListener(Barber.this, recyclerView, new RecyclerClickListener() {
                        @Override
                        public void onClick(View view, int position) {
                            //Toast.makeText(getApplicationContext(), "No." + position, Toast.LENGTH_LONG).show();
                            Items Items = new Items();
                            JSONArray jsonArray;
                            try {
                                jsonArray = new JSONArray(response);
                                JSONObject jsonObject = jsonArray.getJSONObject(position);
                                Intent intent = new Intent(getApplicationContext(), AnotherActivity.class);
                                // in main interface (Activity)
                                Items.profile_picture = jsonObject.getString("profile_picture");
                                intent.putExtra("profile_picture", Items.profile_picture = jsonObject.getString("profile_picture"));
                                //
                                Items.name = jsonObject.getString("name");
                                intent.putExtra("name", Items.name = jsonObject.getString("name"));
                                // in sub-interface (DetailsActivity)
                                Items.panorama = jsonObject.getString("panorama");
                                intent.putExtra("panorama", Items.panorama = jsonObject.getString("panorama"));
                                // Start Activity
                                startActivity(intent);
                            } catch (JSONException e) {
                                e.printStackTrace();
                            }
                        }

                        public void onLongClick(View view, int position) {
                            Toast.makeText(getApplicationContext(), "Long Click", Toast.LENGTH_LONG).show();
                        }
                    });
                    recyclerView.addOnItemTouchListener(recyclerTouchListener);

                }
            },

            new Response.ErrorListener() {
                @Override
                public void onErrorResponse(VolleyError error) {
                    if (error != null) {
                        Log.d(TAG, error.toString());
                        Toast.makeText(getApplicationContext(), "No internet connection", Toast.LENGTH_LONG).show();
                    }
                }
            }
    );
    MySingleton.getInstance(getApplicationContext()).addToRequestQueue(stringRequest);
}
}