Android Sync SQLite Database with Server using PHP and MySQL

January 28, 2017 by Belal Khan 78 Comments

Lets learn Android Sync SQLite Database with Server. Assume we have to send some information from the application to our webserver and internet is not available on the device at a particular time. So instead of giving error to the user that internet is not available we can store the data to SQLite and send it later automatically when the internet is available. And this is what we are going to learn in this Android Sync SQLite Database with Server Tutorial.

Android Sync Sqlite Database with Server Demo

You can first see what we are going to learn in this video where I am showing the application.

Now lets move ahead and start Android Sync Sqlite Database with Server.

Creating Web Service and MySQL Database

Creating Database

I have the following database. I am using XAMPP you can use anything you want.

So we have the database table. Now we will create a php script that will handle the insertion to the database.

Creating Web Service

Creating Script

Create folder in your root directory (in my case it is htdocs).
Now create a php file inside the folder, I have created saveName.php. And write the following code.

<?php

/*
* Database Constants
* Make sure you are putting the values according to your database here 
*/
define('DB_HOST','localhost');
define('DB_USERNAME','root');
define('DB_PASSWORD','');
define('DB_NAME', 'android');

//Connecting to the database
$conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

//checking the successful connection
if($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

//making an array to store the response
$response = array(); 

//if there is a post request move ahead 
if($_SERVER['REQUEST_METHOD']=='POST'){
	
	//getting the name from request 
	$name = $_POST['name']; 

	//creating a statement to insert to database 
	$stmt = $conn->prepare("INSERT INTO names (name) VALUES (?)");
	
	//binding the parameter to statement 
	$stmt->bind_param("s", $name);
	
	//if data inserts successfully
	if($stmt->execute()){
		//making success response 
		$response['error'] = false; 
		$response['message'] = 'Name saved successfully'; 
	}else{
		//if not making failure response 
		$response['error'] = true; 
		$response['message'] = 'Please try later';
	}
	
}else{
	$response['error'] = true; 
	$response['message'] = "Invalid request"; 
}

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

<?php

* Database Constants

* Make sure you are putting the values according to your database here

define('DB_HOST','localhost');

define('DB_USERNAME','root');

define('DB_PASSWORD','');

define('DB_NAME', 'android');

//Connecting to the database

$conn = new mysqli(DB_HOST, DB_USERNAME, DB_PASSWORD, DB_NAME);

//checking the successful connection

if($conn->connect_error) {

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

}

//making an array to store the response

$response = array();

//if there is a post request move ahead

if($_SERVER['REQUEST_METHOD']=='POST'){

//getting the name from request

$name = $_POST['name'];

//creating a statement to insert to database

$stmt = $conn->prepare("INSERT INTO names (name) VALUES (?)");

//binding the parameter to statement

$stmt->bind_param("s", $name);

//if data inserts successfully

if($stmt->execute()){

//making success response

$response['error'] = false;

$response['message'] = 'Name saved successfully';

}else{

//if not making failure response

$response['error'] = true;

$response['message'] = 'Please try later';

}

}else{

$response['error'] = true;

$response['message'] = "Invalid request";

}

//displaying the data in json format

echo json_encode($response);

Testing Script

Now its time to test the script we created. So in my case the URL is http://localhost/SqliteSync/saveName.php
I am using POSTMAN to test the script and you can see it in below screenshot.

As you can see the script is working fine. Now lets move ahead in android project.

Android Sync SQLite Database with Server

Creating Android Project

Create a new project.
I have created AndroidMySQLSync with an Empty Activity.

Adding Permissions

We need the following permissions so first add these to AndroidManifest.xml.

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

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

Adding Dependencies

For network requests I am going to use Volley. So add the following line inside dependencies block of your app level build.gradle file.

dependencies {
    compile fileTree(dir: 'libs', include: ['*.jar'])
    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:25.0.1'

    //add this line
    compile 'com.android.volley:volley:1.0.0'

    
    testCompile 'junit:junit:4.12'
}

dependencies {

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

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:25.0.1'

//add this line

compile 'com.android.volley:volley:1.0.0'

testCompile 'junit:junit:4.12'

}

Handling SQLite Operations

In this case we have to use both SQLite and MySQL. So a class named DatabaseHelper.java and write the following code.

package net.simplifiedcoding.androidmysqlsync;

import android.content.ContentValues;
import android.content.Context;
import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

/**
 * Created by Belal on 1/27/2017.
 */
public class DatabaseHelper extends SQLiteOpenHelper {

    //Constants for Database name, table name, and column names
    public static final String DB_NAME = "NamesDB";
    public static final String TABLE_NAME = "names";
    public static final String COLUMN_ID = "id";
    public static final String COLUMN_NAME = "name";
    public static final String COLUMN_STATUS = "status";

    //database version
    private static final int DB_VERSION = 1;

    //Constructor 
    public DatabaseHelper(Context context) {
        super(context, DB_NAME, null, DB_VERSION);
    }

    //creating the database 
    @Override
    public void onCreate(SQLiteDatabase db) {
        String sql = "CREATE TABLE " + TABLE_NAME
                + "(" + COLUMN_ID +
                " INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME +
                " VARCHAR, " + COLUMN_STATUS +
                " TINYINT);";
        db.execSQL(sql);
    }

    //upgrading the database 
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        String sql = "DROP TABLE IF EXISTS Persons";
        db.execSQL(sql);
        onCreate(db);
    }

    /*
    * This method is taking two arguments
    * first one is the name that is to be saved
    * second one is the status
    * 0 means the name is synced with the server
    * 1 means the name is not synced with the server
    * */
    public boolean addName(String name, int status) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();

        contentValues.put(COLUMN_NAME, name);
        contentValues.put(COLUMN_STATUS, status);


        db.insert(TABLE_NAME, null, contentValues);
        db.close();
        return true;
    }

    /*
    * This method taking two arguments
    * first one is the id of the name for which
    * we have to update the sync status 
    * and the second one is the status that will be changed
    * */
    public boolean updateNameStatus(int id, int status) {
        SQLiteDatabase db = this.getWritableDatabase();
        ContentValues contentValues = new ContentValues();
        contentValues.put(COLUMN_STATUS, status);
        db.update(TABLE_NAME, contentValues, COLUMN_ID + "=" + id, null);
        db.close();
        return true;
    }

    /*
    * this method will give us all the name stored in sqlite 
    * */
    public Cursor getNames() {
        SQLiteDatabase db = this.getReadableDatabase();
        String sql = "SELECT * FROM " + TABLE_NAME + " ORDER BY " + COLUMN_ID + " ASC;";
        Cursor c = db.rawQuery(sql, null);
        return c;
    }

    /*
    * this method is for getting all the unsynced name
    * so that we can sync it with database 
    * */
    public Cursor getUnsyncedNames() {
        SQLiteDatabase db = this.getReadableDatabase();
        String sql = "SELECT * FROM " + TABLE_NAME + " WHERE " + COLUMN_STATUS + " = 0;";
        Cursor c = db.rawQuery(sql, null);
        return c;
    }
}

100

101

102

103

package net.simplifiedcoding.androidmysqlsync;

import android.content.ContentValues;

import android.content.Context;

import android.database.Cursor;

import android.database.sqlite.SQLiteDatabase;

import android.database.sqlite.SQLiteOpenHelper;

/**

* Created by Belal on 1/27/2017.

public class DatabaseHelper extends SQLiteOpenHelper {

//Constants for Database name, table name, and column names

public static final String DB_NAME = "NamesDB";

public static final String TABLE_NAME = "names";

public static final String COLUMN_ID = "id";

public static final String COLUMN_NAME = "name";

public static final String COLUMN_STATUS = "status";

//database version

private static final int DB_VERSION = 1;

//Constructor

public DatabaseHelper(Context context) {

super(context, DB_NAME, null, DB_VERSION);

}

//creating the database

@Override

public void onCreate(SQLiteDatabase db) {

String sql = "CREATE TABLE " + TABLE_NAME

+ "(" + COLUMN_ID +

" INTEGER PRIMARY KEY AUTOINCREMENT, " + COLUMN_NAME +

" VARCHAR, " + COLUMN_STATUS +

" TINYINT);";

db.execSQL(sql);

}

//upgrading the database

@Override

public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

String sql = "DROP TABLE IF EXISTS Persons";

db.execSQL(sql);

onCreate(db);

}

* This method is taking two arguments

* first one is the name that is to be saved

* second one is the status

* 0 means the name is synced with the server

* 1 means the name is not synced with the server

* */

public boolean addName(String name, int status) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues contentValues = new ContentValues();

contentValues.put(COLUMN_NAME, name);

contentValues.put(COLUMN_STATUS, status);

db.insert(TABLE_NAME, null, contentValues);

db.close();

return true;

}

* This method taking two arguments

* first one is the id of the name for which

* we have to update the sync status

* and the second one is the status that will be changed

* */

public boolean updateNameStatus(int id, int status) {

SQLiteDatabase db = this.getWritableDatabase();

ContentValues contentValues = new ContentValues();

contentValues.put(COLUMN_STATUS, status);

db.update(TABLE_NAME, contentValues, COLUMN_ID + "=" + id, null);

db.close();

return true;

}

* this method will give us all the name stored in sqlite

* */

public Cursor getNames() {

SQLiteDatabase db = this.getReadableDatabase();

String sql = "SELECT * FROM " + TABLE_NAME + " ORDER BY " + COLUMN_ID + " ASC;";

Cursor c = db.rawQuery(sql, null);

return c;

}

* this method is for getting all the unsynced name

* so that we can sync it with database

* */

public Cursor getUnsyncedNames() {

SQLiteDatabase db = this.getReadableDatabase();

String sql = "SELECT * FROM " + TABLE_NAME + " WHERE " + COLUMN_STATUS + " = 0;";

Cursor c = db.rawQuery(sql, null);

return c;

}

Handling Volley RequestQueue

We are going to use Volley for http request. So for this we will create a singleton class.
Create a class named VolleySingleton and write the following code.

package net.simplifiedcoding.androidmysqlsync;

import android.content.Context;
import android.graphics.Bitmap;
import android.support.v4.util.LruCache;

import com.android.volley.Request;
import com.android.volley.RequestQueue;
import com.android.volley.toolbox.ImageLoader;
import com.android.volley.toolbox.Volley;

/**
 * Created by Belal on 21/09/16.
 */
public class VolleySingleton {

    private static VolleySingleton mInstance;
    private RequestQueue mRequestQueue;
    private static Context mCtx;

    private VolleySingleton(Context context) {
        mCtx = context;
        mRequestQueue = getRequestQueue();

    }

    public static synchronized VolleySingleton getInstance(Context context) {
        if (mInstance == null) {
            mInstance = new VolleySingleton(context);
        }
        return mInstance;
    }

    public RequestQueue getRequestQueue() {
        if (mRequestQueue == null) {
            // getApplicationContext() is key, it keeps you from leaking the
            // Activity or BroadcastReceiver if someone passes one in.
            mRequestQueue = Volley.newRequestQueue(mCtx.getApplicationContext());
        }
        return mRequestQueue;
    }

    public <T> void addToRequestQueue(Request<T> req) {
        getRequestQueue().add(req);
    }

}

package net.simplifiedcoding.androidmysqlsync;

import android.content.Context;

import android.graphics.Bitmap;

import android.support.v4.util.LruCache;

import com.android.volley.Request;

import com.android.volley.RequestQueue;

import com.android.volley.toolbox.ImageLoader;

import com.android.volley.toolbox.Volley;

/**

* Created by Belal on 21/09/16.

public class VolleySingleton {

private static VolleySingleton mInstance;

private RequestQueue mRequestQueue;

private static Context mCtx;

private VolleySingleton(Context context) {

mCtx = context;

mRequestQueue = getRequestQueue();

}

public static synchronized VolleySingleton getInstance(Context context) {

if (mInstance == null) {

mInstance = new VolleySingleton(context);

}

return mInstance;

}

public RequestQueue getRequestQueue() {

if (mRequestQueue == null) {

// getApplicationContext() is key, it keeps you from leaking the

// Activity or BroadcastReceiver if someone passes one in.

mRequestQueue = Volley.newRequestQueue(mCtx.getApplicationContext());

}

return mRequestQueue;

}

public <T> void addToRequestQueue(Request<T> req) {

getRequestQueue().add(req);

}

Building Interface

MainActivity

Now inside activity_main.xml write the following code.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/activity_main"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    android:paddingBottom="@dimen/activity_vertical_margin"
    android:paddingLeft="@dimen/activity_horizontal_margin"
    android:paddingRight="@dimen/activity_horizontal_margin"
    android:paddingTop="@dimen/activity_vertical_margin"
    tools:context="net.simplifiedcoding.androidmysqlsync.MainActivity">

    <LinearLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:orientation="horizontal">

        <EditText
            android:id="@+id/editTextName"
            android:layout_width="match_parent"
            android:layout_height="wrap_content"
            android:layout_weight="3"
            android:hint="Enter a name" />

        <Button
            android:id="@+id/buttonSave"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:layout_weight="1"
            android:text="Save" />

    </LinearLayout>

    <ListView
        android:id="@+id/listViewNames"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"></ListView>

</LinearLayout>

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

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

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

android:id="@+id/activity_main"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical"

android:paddingBottom="@dimen/activity_vertical_margin"

android:paddingLeft="@dimen/activity_horizontal_margin"

android:paddingRight="@dimen/activity_horizontal_margin"

android:paddingTop="@dimen/activity_vertical_margin"

tools:context="net.simplifiedcoding.androidmysqlsync.MainActivity">

<LinearLayout

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:orientation="horizontal">

<EditText

android:id="@+id/editTextName"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:layout_weight="3"

android:hint="Enter a name" />

<Button

android:id="@+id/buttonSave"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:layout_weight="1"

android:text="Save" />

</LinearLayout>

<ListView

android:id="@+id/listViewNames"

android:layout_width="match_parent"

android:layout_height="wrap_content"></ListView>

</LinearLayout>

The above code will generate the following output.

Android Sync SQLite Database with Server

As you can see we have an EditText, a Button and a ListView.
Now let me tell you what we are going to do. We will save the Name from EditText and we will also display the saved name in ListView with the Sync Status. So the next part is designing a layout for our Custom ListView.

ListView

Create an xml file inside layout directory. I have created names.xml.

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"
    android:padding="@dimen/activity_horizontal_margin"
    android:layout_width="match_parent" android:layout_height="match_parent">

    <TextView
        android:text="Name"
        android:layout_alignParentLeft="true"
        android:id="@+id/textViewName"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />

    <ImageView
        android:background="@drawable/success"
        android:layout_alignParentRight="true"
        android:id="@+id/imageViewStatus"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content" />
    
</RelativeLayout>

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

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

android:padding="@dimen/activity_horizontal_margin"

android:layout_width="match_parent" android:layout_height="match_parent">

<TextView

android:text="Name"

android:layout_alignParentLeft="true"

android:id="@+id/textViewName"

android:layout_width="wrap_content"

android:layout_height="wrap_content" />

<ImageView

android:background="@drawable/success"

android:layout_alignParentRight="true"

android:id="@+id/imageViewStatus"

android:layout_width="wrap_content"

android:layout_height="wrap_content" />

</RelativeLayout>

As you can see we have a TextView to display the name and an ImageView to display the status.
Download the icons from the below link, we have two images to display queued or synced.

[download id=”4043″]

You have to copy the downloaded icons inside drawable folder.

Building ListView

Model Class

Now create a class Name.java and write the following code.

package net.simplifiedcoding.androidmysqlsync;

/**
 * Created by Belal on 1/27/2017.
 */

public class Name {
    private String name;
    private int status;

    public Name(String name, int status) {
        this.name = name;
        this.status = status;
    }

    public String getName() {
        return name;
    }

    public int getStatus() {
        return status;
    }
}

package net.simplifiedcoding.androidmysqlsync;

/**

* Created by Belal on 1/27/2017.

public class Name {

private String name;

private int status;

public Name(String name, int status) {

this.name = name;

this.status = status;

}

public String getName() {

return name;

}

public int getStatus() {

return status;

}

Now we will create an Adapter for our ListView.

Adapter

Create a class NameAdapter.java and write the following code.

package net.simplifiedcoding.androidmysqlsync;

import android.content.Context;
import android.view.LayoutInflater;
import android.view.View;
import android.view.ViewGroup;
import android.widget.ArrayAdapter;
import android.widget.ImageView;
import android.widget.TextView;

import java.util.List;

/**
 * Created by Belal on 1/27/2017.
 */

public class NameAdapter extends ArrayAdapter<Name> {

    //storing all the names in the list
    private List<Name> names;

    //context object
    private Context context;

    //constructor 
    public NameAdapter(Context context, int resource, List<Name> names) {
        super(context, resource, names);
        this.context = context;
        this.names = names;
    }

    @Override
    public View getView(int position, View convertView, ViewGroup parent) {
        
        //getting the layoutinflater 
        LayoutInflater inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);
        
        //getting listview itmes
        View listViewItem = inflater.inflate(R.layout.names, null, true);
        TextView textViewName = (TextView) listViewItem.findViewById(R.id.textViewName);
        ImageView imageViewStatus = (ImageView) listViewItem.findViewById(R.id.imageViewStatus);

        //getting the current name 
        Name name = names.get(position);

        //setting the name to textview
        textViewName.setText(name.getName());

        //if the synced status is 0 displaying 
        //queued icon 
        //else displaying synced icon 
        if (name.getStatus() == 0)
            imageViewStatus.setBackgroundResource(R.drawable.stopwatch);
        else
            imageViewStatus.setBackgroundResource(R.drawable.success);

        return listViewItem;
    }
}

package net.simplifiedcoding.androidmysqlsync;

import android.content.Context;

import android.view.LayoutInflater;

import android.view.View;

import android.view.ViewGroup;

import android.widget.ArrayAdapter;

import android.widget.ImageView;

import android.widget.TextView;

import java.util.List;

/**

* Created by Belal on 1/27/2017.

public class NameAdapter extends ArrayAdapter<Name> {

//storing all the names in the list

private List<Name> names;

//context object

private Context context;

//constructor

public NameAdapter(Context context, int resource, List<Name> names) {

super(context, resource, names);

this.context = context;

this.names = names;

}

@Override

public View getView(int position, View convertView, ViewGroup parent) {

//getting the layoutinflater

LayoutInflater inflater = (LayoutInflater) context.getSystemService(Context.LAYOUT_INFLATER_SERVICE);

//getting listview itmes

View listViewItem = inflater.inflate(R.layout.names, null, true);

TextView textViewName = (TextView) listViewItem.findViewById(R.id.textViewName);

ImageView imageViewStatus = (ImageView) listViewItem.findViewById(R.id.imageViewStatus);

//getting the current name

Name name = names.get(position);

//setting the name to textview

textViewName.setText(name.getName());

//if the synced status is 0 displaying

//queued icon

//else displaying synced icon

if (name.getStatus() == 0)

imageViewStatus.setBackgroundResource(R.drawable.stopwatch);

else

imageViewStatus.setBackgroundResource(R.drawable.success);

return listViewItem;

}

Coding MainActivity

Now lets come inside MainActivity.java and write the following code.

package net.simplifiedcoding.androidmysqlsync;

import android.Manifest;
import android.app.ProgressDialog;
import android.content.BroadcastReceiver;
import android.content.Context;
import android.content.Intent;
import android.content.IntentFilter;
import android.content.pm.PackageManager;
import android.database.Cursor;
import android.net.ConnectivityManager;
import android.support.v4.content.ContextCompat;
import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.ListView;
import android.widget.Toast;

import com.android.volley.AuthFailureError;
import com.android.volley.Request;
import com.android.volley.RequestQueue;
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.JSONException;
import org.json.JSONObject;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

    /*
    * this is the url to our webservice
    * make sure you are using the ip instead of localhost
    * it will not work if you are using localhost
    * */
    public static final String URL_SAVE_NAME = "http://192.168.1.107/SqliteSync/saveName.php";

    //database helper object
    private DatabaseHelper db;

    //View objects
    private Button buttonSave;
    private EditText editTextName;
    private ListView listViewNames;
    
    //List to store all the names
    private List<Name> names;

    //1 means data is synced and 0 means data is not synced 
    public static final int NAME_SYNCED_WITH_SERVER = 1;
    public static final int NAME_NOT_SYNCED_WITH_SERVER = 0;

    //a broadcast to know weather the data is synced or not 
    public static final String DATA_SAVED_BROADCAST = "net.simplifiedcoding.datasaved";

    //Broadcast receiver to know the sync status 
    private BroadcastReceiver broadcastReceiver;

    //adapterobject for list view
    private NameAdapter nameAdapter;

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        
        //initializing views and objects 
        db = new DatabaseHelper(this);
        names = new ArrayList<>();

        buttonSave = (Button) findViewById(R.id.buttonSave);
        editTextName = (EditText) findViewById(R.id.editTextName);
        listViewNames = (ListView) findViewById(R.id.listViewNames);

        //adding click listener to button 
        buttonSave.setOnClickListener(this);

        //calling the method to load all the stored names
        loadNames();

        //the broadcast receiver to update sync status
        broadcastReceiver = new BroadcastReceiver() {
            @Override
            public void onReceive(Context context, Intent intent) {
                
                //loading the names again 
                loadNames();
            }
        };

        //registering the broadcast receiver to update sync status 
        registerReceiver(broadcastReceiver, new IntentFilter(DATA_SAVED_BROADCAST));
    }

    /*
    * this method will 
    * load the names from the database 
    * with updated sync status
    * */
    private void loadNames() {
        names.clear();
        Cursor cursor = db.getNames();
        if (cursor.moveToFirst()) {
            do {
                Name name = new Name(
                        cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_NAME)),
                        cursor.getInt(cursor.getColumnIndex(DatabaseHelper.COLUMN_STATUS))
                );
                names.add(name);
            } while (cursor.moveToNext());
        }

        nameAdapter = new NameAdapter(this, R.layout.names, names);
        listViewNames.setAdapter(nameAdapter);
    }

    /*
    * this method will simply refresh the list 
    * */
    private void refreshList() {
        nameAdapter.notifyDataSetChanged();
    }

    /*
    * this method is saving the name to ther server 
    * */
    private void saveNameToServer() {
        final ProgressDialog progressDialog = new ProgressDialog(this);
        progressDialog.setMessage("Saving Name...");
        progressDialog.show();

        final String name = editTextName.getText().toString().trim();

        StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_SAVE_NAME,
                new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        progressDialog.dismiss();
                        try {
                            JSONObject obj = new JSONObject(response);
                            if (!obj.getBoolean("error")) {
                                //if there is a success
                                //storing the name to sqlite with status synced
                                saveNameToLocalStorage(name, NAME_SYNCED_WITH_SERVER);
                            } else {
                                //if there is some error 
                                //saving the name to sqlite with status unsynced 
                                saveNameToLocalStorage(name, NAME_NOT_SYNCED_WITH_SERVER);
                            }
                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                    }
                },
                new Response.ErrorListener() {
                    @Override
                    public void onErrorResponse(VolleyError error) {
                        progressDialog.dismiss();
                        //on error storing the name to sqlite with status unsynced 
                        saveNameToLocalStorage(name, NAME_NOT_SYNCED_WITH_SERVER);
                    }
                }) {
            @Override
            protected Map<String, String> getParams() throws AuthFailureError {
                Map<String, String> params = new HashMap<>();
                params.put("name", name);
                return params;
            }
        };

        VolleySingleton.getInstance(this).addToRequestQueue(stringRequest);
    }

    //saving the name to local storage 
    private void saveNameToLocalStorage(String name, int status) {
        editTextName.setText("");
        db.addName(name, status);
        Name n = new Name(name, status);
        names.add(n);
        refreshList();
    }

    @Override
    public void onClick(View view) {
        saveNameToServer();
    }
}

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

package net.simplifiedcoding.androidmysqlsync;

import android.Manifest;

import android.app.ProgressDialog;

import android.content.BroadcastReceiver;

import android.content.Context;

import android.content.Intent;

import android.content.IntentFilter;

import android.content.pm.PackageManager;

import android.database.Cursor;

import android.net.ConnectivityManager;

import android.support.v4.content.ContextCompat;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.ListView;

import android.widget.Toast;

import com.android.volley.AuthFailureError;

import com.android.volley.Request;

import com.android.volley.RequestQueue;

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.JSONException;

import org.json.JSONObject;

import java.util.ArrayList;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

public class MainActivity extends AppCompatActivity implements View.OnClickListener {

* this is the url to our webservice

* make sure you are using the ip instead of localhost

* it will not work if you are using localhost

* */

public static final String URL_SAVE_NAME = "http://192.168.1.107/SqliteSync/saveName.php";

//database helper object

private DatabaseHelper db;

//View objects

private Button buttonSave;

private EditText editTextName;

private ListView listViewNames;

//List to store all the names

private List<Name> names;

//1 means data is synced and 0 means data is not synced

public static final int NAME_SYNCED_WITH_SERVER = 1;

public static final int NAME_NOT_SYNCED_WITH_SERVER = 0;

//a broadcast to know weather the data is synced or not

public static final String DATA_SAVED_BROADCAST = "net.simplifiedcoding.datasaved";

//Broadcast receiver to know the sync status

private BroadcastReceiver broadcastReceiver;

//adapterobject for list view

private NameAdapter nameAdapter;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

//initializing views and objects

db = new DatabaseHelper(this);

names = new ArrayList<>();

buttonSave = (Button) findViewById(R.id.buttonSave);

editTextName = (EditText) findViewById(R.id.editTextName);

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

//adding click listener to button

buttonSave.setOnClickListener(this);

//calling the method to load all the stored names

loadNames();

//the broadcast receiver to update sync status

broadcastReceiver = new BroadcastReceiver() {

@Override

public void onReceive(Context context, Intent intent) {

//loading the names again

loadNames();

}

};

//registering the broadcast receiver to update sync status

registerReceiver(broadcastReceiver, new IntentFilter(DATA_SAVED_BROADCAST));

}

* this method will

* load the names from the database

* with updated sync status

* */

private void loadNames() {

names.clear();

Cursor cursor = db.getNames();

if (cursor.moveToFirst()) {

do {

Name name = new Name(

cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_NAME)),

cursor.getInt(cursor.getColumnIndex(DatabaseHelper.COLUMN_STATUS))

);

names.add(name);

} while (cursor.moveToNext());

}

nameAdapter = new NameAdapter(this, R.layout.names, names);

listViewNames.setAdapter(nameAdapter);

}

* this method will simply refresh the list

* */

private void refreshList() {

nameAdapter.notifyDataSetChanged();

}

* this method is saving the name to ther server

* */

private void saveNameToServer() {

final ProgressDialog progressDialog = new ProgressDialog(this);

progressDialog.setMessage("Saving Name...");

progressDialog.show();

final String name = editTextName.getText().toString().trim();

StringRequest stringRequest = new StringRequest(Request.Method.POST, URL_SAVE_NAME,

new Response.Listener<String>() {

@Override

public void onResponse(String response) {

progressDialog.dismiss();

try {

JSONObject obj = new JSONObject(response);

if (!obj.getBoolean("error")) {

//if there is a success

//storing the name to sqlite with status synced

saveNameToLocalStorage(name, NAME_SYNCED_WITH_SERVER);

} else {

//if there is some error

//saving the name to sqlite with status unsynced

saveNameToLocalStorage(name, NAME_NOT_SYNCED_WITH_SERVER);

}

} catch (JSONException e) {

e.printStackTrace();

}

new Response.ErrorListener() {

@Override

public void onErrorResponse(VolleyError error) {

progressDialog.dismiss();

//on error storing the name to sqlite with status unsynced

saveNameToLocalStorage(name, NAME_NOT_SYNCED_WITH_SERVER);

}

}) {

@Override

protected Map<String, String> getParams() throws AuthFailureError {

Map<String, String> params = new HashMap<>();

params.put("name", name);

return params;

}

};

VolleySingleton.getInstance(this).addToRequestQueue(stringRequest);

}

//saving the name to local storage

private void saveNameToLocalStorage(String name, int status) {

editTextName.setText("");

db.addName(name, status);

Name n = new Name(name, status);

names.add(n);

refreshList();

}

@Override

public void onClick(View view) {

saveNameToServer();

}

Now if you will run the application it will save the name to MySQL and SQLite with the sync or unsynced status.
But to send the unsynced names to the server automatically we have to detect the Network Status of the phone. For this we need one more broadcast receiver.

Detecting Network State

Creating Broadcast Receiver

Create a class named NetworkStateChecker.java and write the following code.

package net.simplifiedcoding.androidmysqlsync;

import android.content.BroadcastReceiver;
import android.content.Context;
import android.content.Intent;
import android.database.Cursor;
import android.net.ConnectivityManager;
import android.net.NetworkInfo;

import com.android.volley.AuthFailureError;
import com.android.volley.Request;
import com.android.volley.Response;
import com.android.volley.VolleyError;
import com.android.volley.toolbox.StringRequest;

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

import java.util.HashMap;
import java.util.Map;

/**
 * Created by Belal on 1/27/2017.
 */

public class NetworkStateChecker extends BroadcastReceiver {
    
    //context and database helper object
    private Context context;
    private DatabaseHelper db;

    
    @Override
    public void onReceive(Context context, Intent intent) {

        this.context = context;

        db = new DatabaseHelper(context);

        ConnectivityManager cm = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE);
        NetworkInfo activeNetwork = cm.getActiveNetworkInfo();
        
        //if there is a network
        if (activeNetwork != null) {
            //if connected to wifi or mobile data plan
            if (activeNetwork.getType() == ConnectivityManager.TYPE_WIFI || activeNetwork.getType() == ConnectivityManager.TYPE_MOBILE) {
                
                //getting all the unsynced names
                Cursor cursor = db.getUnsyncedNames();
                if (cursor.moveToFirst()) {
                    do {
                        //calling the method to save the unsynced name to MySQL
                        saveName(
                                cursor.getInt(cursor.getColumnIndex(DatabaseHelper.COLUMN_ID)),
                                cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_NAME))
                        );
                    } while (cursor.moveToNext());
                }
            }
        }
    }

    /*
    * method taking two arguments
    * name that is to be saved and id of the name from SQLite
    * if the name is successfully sent
    * we will update the status as synced in SQLite
    * */
    private void saveName(final int id, final String name) {
        StringRequest stringRequest = new StringRequest(Request.Method.POST, MainActivity.URL_SAVE_NAME,
                new Response.Listener<String>() {
                    @Override
                    public void onResponse(String response) {
                        try {
                            JSONObject obj = new JSONObject(response);
                            if (!obj.getBoolean("error")) {
                                //updating the status in sqlite 
                                db.updateNameStatus(id, MainActivity.NAME_SYNCED_WITH_SERVER);
                                
                                //sending the broadcast to refresh the list 
                                context.sendBroadcast(new Intent(MainActivity.DATA_SAVED_BROADCAST));
                            }
                        } catch (JSONException e) {
                            e.printStackTrace();
                        }
                    }
                },
                new Response.ErrorListener() {
                    @Override
                    public void onErrorResponse(VolleyError error) {

                    }
                }) {
            @Override
            protected Map<String, String> getParams() throws AuthFailureError {
                Map<String, String> params = new HashMap<>();
                params.put("name", name);
                return params;
            }
        };

        VolleySingleton.getInstance(context).addToRequestQueue(stringRequest);
    }

}

100

101

102

103

104

105

package net.simplifiedcoding.androidmysqlsync;

import android.content.BroadcastReceiver;

import android.content.Context;

import android.content.Intent;

import android.database.Cursor;

import android.net.ConnectivityManager;

import android.net.NetworkInfo;

import com.android.volley.AuthFailureError;

import com.android.volley.Request;

import com.android.volley.Response;

import com.android.volley.VolleyError;

import com.android.volley.toolbox.StringRequest;

import org.json.JSONException;

import org.json.JSONObject;

import java.util.HashMap;

import java.util.Map;

/**

* Created by Belal on 1/27/2017.

public class NetworkStateChecker extends BroadcastReceiver {

//context and database helper object

private Context context;

private DatabaseHelper db;

@Override

public void onReceive(Context context, Intent intent) {

this.context = context;

db = new DatabaseHelper(context);

ConnectivityManager cm = (ConnectivityManager) context.getSystemService(Context.CONNECTIVITY_SERVICE);

NetworkInfo activeNetwork = cm.getActiveNetworkInfo();

//if there is a network

if (activeNetwork != null) {

//if connected to wifi or mobile data plan

if (activeNetwork.getType() == ConnectivityManager.TYPE_WIFI || activeNetwork.getType() == ConnectivityManager.TYPE_MOBILE) {

//getting all the unsynced names

Cursor cursor = db.getUnsyncedNames();

if (cursor.moveToFirst()) {

do {

//calling the method to save the unsynced name to MySQL

saveName(

cursor.getInt(cursor.getColumnIndex(DatabaseHelper.COLUMN_ID)),

cursor.getString(cursor.getColumnIndex(DatabaseHelper.COLUMN_NAME))

);

} while (cursor.moveToNext());

}

* method taking two arguments

* name that is to be saved and id of the name from SQLite

* if the name is successfully sent

* we will update the status as synced in SQLite

* */

private void saveName(final int id, final String name) {

StringRequest stringRequest = new StringRequest(Request.Method.POST, MainActivity.URL_SAVE_NAME,

new Response.Listener<String>() {

@Override

public void onResponse(String response) {

try {

JSONObject obj = new JSONObject(response);

if (!obj.getBoolean("error")) {

//updating the status in sqlite

db.updateNameStatus(id, MainActivity.NAME_SYNCED_WITH_SERVER);

//sending the broadcast to refresh the list

context.sendBroadcast(new Intent(MainActivity.DATA_SAVED_BROADCAST));

}

} catch (JSONException e) {

e.printStackTrace();

}

new Response.ErrorListener() {

@Override

public void onErrorResponse(VolleyError error) {

}

}) {

@Override

protected Map<String, String> getParams() throws AuthFailureError {

Map<String, String> params = new HashMap<>();

params.put("name", name);

return params;

}

};

VolleySingleton.getInstance(context).addToRequestQueue(stringRequest);

}

Adding Receiver in Manifest

Add the following code in your AndroidManifest.xml file inside application tag.

        <receiver android:name=".NetworkStateChecker">
            <intent-filter>
                <action android:name="android.net.conn.CONNECTIVITY_CHANGE" />
            </intent-filter>
        </receiver>

<intent-filter>

</intent-filter>

</receiver>

Registering Receiver

You also need to register the receiver. So add the following line inside onCreate() method of your MainActivity.java file.

 registerReceiver(new NetworkStateChecker(), new IntentFilter(ConnectivityManager.CONNECTIVITY_ACTION));

1	registerReceiver(new NetworkStateChecker(), new IntentFilter(ConnectivityManager.CONNECTIVITY_ACTION));

Now you can run your application.

Testing the Application

Run your application. And try saving the name when internet is available also turn off the internet and again try saving your name.
Android Sync SQLite Database with Server
When the internet will be available again the data will be automatically sent to MySQL.

Download Source Code

You can get the source code from the following GitHub repository.

So thats it for this android sync sqlite database with server tutorial friends. Feel free to leave your comments if you are having any troubles making the project. Also follow the steps carefully as the post is very long. And if you found this helpful please favor us by sharing this post in your social network. 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

Avikal says

February 3, 2017 at 9:12 am

Great work i m just looking that……………..
Thanks Sir

Reply
Juma Allan says

February 4, 2017 at 11:16 am

Thanks
This has saved me

Reply
stef says

February 18, 2017 at 9:24 pm

Hi there! I tried your code. I was able to launch the app on my ADV (on android studio) and to save data in local (on sqllite) but I was not able to sync data from sqlite to my mysql server. Maybe I wrong something….What should I verify?

Reply
- pj says
  
  February 28, 2017 at 12:28 pm
  
  I have the same issue. If you find an answer please share.
  
  Reply
- Que says
  
  July 4, 2017 at 3:34 am
  
  Have you changed the URL to your PHP file?
  
  If not, you might change them in app > main > java > MainActivity.java. Refer line 44.
  
  Change to your ip address.
  
  Reply
- Sergio says
  
  September 21, 2017 at 1:51 pm
  
  something goes wtong with the previous comment…
  
  upd:
  1. Close code in the savename.php file with tag:
  
  ?>
  
  2. Fix following constants according to your hosting params. I.e.:
  ‘DB_HOST’ , ‘subdomain.domain.ext’ <— url where your db created
  'DB_USERNAME' , 'u0100125_admin' <— db user with admin rights
  'DB_PASSWORD' , 'mySimpleTestPassw0rd' <— db admin's password
  'DB_NAME' , 'u0100125_names_db' prepare(“INSERT INTO t_users (name) VALUES (?)”); ”
  
  where:
  “your_table_name” – the name of the table in the DB, which contains column “your_column_name”
  in this example table name is “names”, column name is “name”.
  
  Reply
- Daviie says
  
  July 18, 2018 at 6:23 am
  
  Make sure that your MYSQL server can be accessed Remotely, I had the same problem but after fixing that it worked.
  
  Reply
Khettalie says

February 21, 2017 at 4:23 am

Thanks for the code, Its work on my localhost but why can not work when i am upload to cpanel server the data can not update can you tell me why sir??

Reply
TheSpencer says

February 22, 2017 at 9:27 am

Thanks Belal for your article, it works like it should. Now I have to understand the code 🙂

Reply
Hazael says

February 24, 2017 at 8:17 am

Hello thanks for your code, a question how would the synchronization of Mysql to Sqlite?

Reply
Ibrahim Samad says

February 27, 2017 at 4:07 pm

I have a situation where I want to initialize my app with data from mysql only when the app is installed for the first time. The problem I run into however is that, when using volley in the onCreate() of SQLiteOpenHelper class, the app starts before the network request completes. This results in blank screen for the first time. What can I do to make sure the UI only runs after network request is complete?

Reply
andyyy says

March 7, 2017 at 3:27 pm

Hi! Why is it not working in me? I changed the IP address but still, {“error”:true,”message”:”Invalid request”} keep on appearing. Please someone help me. 🙁

Reply
- Ibrahim Samad says
  
  March 9, 2017 at 1:08 pm
  
  It means you are not making a POST Request from your Android codes. Probably you are rather making GET or other request.
  
  Reply
eko says

March 25, 2017 at 10:49 am

Hello,

firstly thanks for your good article.
at the moment everything works apart from couple of bugs. i try this app on real device. when there is internet connection it syncs without any trouble. for test purpose i switched off internet and then i added some name as a result it didnt sysnc, so far everything is as expected. then i switched on wifi and it added data to mysql straighaway however it added two time. in that case what cause the double entry?

Reply
- Majdi says
  
  May 15, 2017 at 8:04 pm
  
  Same probleme . any solution!!?
  
  Reply
Jason N says

March 29, 2017 at 6:17 am

Any chance you could assist in modifying your code to allow more information to be added? This is exactly what i have been trying to do, but i need to have something like name, address, phone, email added to the database, but the “sync” screen is fine just displaying a list of names with sync buttons next to it.

Reply
Ruvany Valencio says

April 21, 2017 at 7:59 pm

Hi,

When I turn off the internet it saves well in sqlite, but when I start it stores me duplicate records in mysql. please help.

Reply
- karthi says
  
  May 19, 2017 at 10:45 am
  
  Dear Ruvany Valencio,
  Did you solve this method.if you solved kindly tell how to avoid duplicate Record in My sql
  
  Reply
karthikeyan says

April 24, 2017 at 10:43 am

Dear Belal Khan nice tutorial thankyou.

When i am offline(Sqlite) to datas entry and saved in listview successfully .When internet in connection on the values added in two times to mysql how to avoid duplicate.

Reply
rajat says

April 28, 2017 at 7:52 pm

{“error”:true,”message”:”Please try later”}.i am getting this error.please help

Reply
Rosky says

April 28, 2017 at 10:07 pm

I cant seem to find the Server Source Code? Is it missing from the github repo?

Reply
Maki says

May 16, 2017 at 3:36 pm

Where is registerReceiver from?

Reply
kunal says

June 7, 2017 at 6:04 am

its Greats Job … Bro Lot of Thank u ….

But i have Question how to sync multiple fields i have large table .. with above 50+ columns .
how to solve ?

Reply
- student says
  
  April 1, 2018 at 8:39 pm
  
  have you find how to sync multiple fields i have large table, f you solved kindly tell me how .
  i have the same problem
  
  Reply
Neeraj says

June 17, 2017 at 4:49 pm

i always get this output {“error”:true,”message”:”Invalid request”} when i run the php file in my localhost. Can you help me?

Reply
- Belal Khan says
  
  June 18, 2017 at 8:47 am
  
  Make sure you are performing a POST request.
  
  Reply
Send says

June 24, 2017 at 6:58 pm

How add another data in listviews? i tride? but nothing///

Reply
SenD says

June 27, 2017 at 5:40 pm

hi, how can update data in mysql and Sqlite

Reply
GABRIEL PIRES says

July 5, 2017 at 1:22 am

Wow show, but how could I send text + image captured from the camera?

Reply
johan lu says

July 5, 2017 at 1:24 am

Would be cool, a code in github with text sync + sqlite images for mysql.

Reply
James says

July 11, 2017 at 6:49 am

Great Tutorial. Thanks for sharing.

Reply
Nilesh says

July 17, 2017 at 10:03 am

how to check which api call and sync data from database in android

Reply
Alif says

August 1, 2017 at 2:36 am

Hi,

When I turn off the internet it saves well in sqlite, but when I start it stores me duplicate records in mysql. please help.

Reply
Jose Rodriguez says

August 11, 2017 at 6:58 pm

Hey Belal!

I’m becoming a fan of yours!
Very well explained and easy to follow!
Congratulations!

Greetings from Argentina!
Jose

Reply
Ritu says

August 12, 2017 at 5:28 am

I m working on an app project task management which has timer for task which should work offline also but m confused which data should be stored offline as there may be many task and projects

Reply
Rossi Mundecke says

August 12, 2017 at 3:01 pm

Good day.
I have liked your post on facebook and google plus, but the like buttons for facebook or google plus does not work at all.
How do you get the github repository

Reply
- Belal Khan says
  
  August 13, 2017 at 9:09 am
  
  I checked it is working.. something wrong on your side.. but no worries here is the link for you
  https://github.com/probelalkhan/android-sqlite-mysql-sync-example
  
  Reply
  - dashiingsuma says
    
    August 21, 2017 at 5:37 am
    
    Please give the link to php file.There is an error of undifined index at line 27 when i copy php code.Please help
    
    Reply
Rahul says

August 12, 2017 at 3:45 pm

Hi,
Can you please upload a tutorials for Synchronize the data of Server and Sqlite Database using Content Provider

Reply
Jesse says

September 11, 2017 at 12:27 am

yeah, the php script ain’t working for me, returning an error….and I have no idea how to fix that

Reply
Shaxzodbek says

September 12, 2017 at 8:42 am

Great work! Belal Khan numer one forever! Thanks Sir

Reply
Matt says

October 4, 2017 at 4:33 am

Hi, Postman show me this:

Fatal error: Call to a member function bind_param() on boolean in
/opt/lampp/htdocs/android/saveName.php on line
33

Can someone help?

Reply
Janam Soni says

October 18, 2017 at 1:38 pm

$stmt->bind_param(“s”, $name);

here “s” for string
because $name is string type.

Reply
Janam Soni says

October 18, 2017 at 1:41 pm

Thanks, man it’s working fine.
your style of explaining is very well.

To those wamp user who are getting error in LAN put Require all granted in hhtpd-vhost.conf file

Reply
Ganesh Das says

November 18, 2017 at 5:39 am

Its awesome..
but i want to sync my 2 column from database so.. can you please help me … what to do …?

Reply
Luis says

November 20, 2017 at 3:34 am

Hi. Great tutorial. Have you been able to fix the duplicate entries created after sync with server?
Thanks

Reply
Bilal Sabir says

November 21, 2017 at 6:06 pm

Hello Bilal very nice tutorial can you please help in an issue i want to retrieve the name value back to edittext by clicking on any row of listview. can you please provide me a code for listview onitemclicklistner because i am unavle to get the data back. I hope you will respond to my request.
Salam

Reply
GoRo says

November 22, 2017 at 9:01 am

Good Day,

I have a strange issue, the app is working like intended but there is a bug somewhere.

If I turn on Airplane mode and add 3 – 4 names and switch Airplane mode off, only one name is being synced to the MySQL server, but all other names are being marked as uploaded, if I check the SQLite database on the local device, all of them have been marked with a 1 on the table Status? Any idea on why this would happen?

Like always, your assistance would be highly appreciated.

Kind Regards,
GoRo

Reply
Muhammad Bilal Sabir says

November 22, 2017 at 2:40 pm

Hello can you create a tutorial where we can upload an image too. it will be very helpful

Reply
Chitranjan Singh says

November 27, 2017 at 4:29 pm

Dear Belal,

Thank you so much for posting this article.Can you please post multiple fields sync from sqlite to MySQL remote server..

I used you article. Its working fine but whenever i am try to sync multiple fields its throwing error please help me..

Reply
- GoRo says
  
  November 30, 2017 at 9:10 am
  
  Just make sure your PHP POST have all these fields as $XXX
  
  Code:
  
  StringRequest stringRequest = new StringRequest(Request.Method.POST, url_create_product,
  new Response.Listener() {
  @Override
  public void onResponse(String ServerResponse) {
  
  // Hiding the progress dialog after all task complete.
  progressDialog.dismiss();
  
  String insertSQL = “INSERT INTO GPSPLOTS \n” +
  “(outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, datecap, syncedd)\n” +
  “VALUES \n” +
  “(?, ?, ?, ?, ?, ?, ?, ?, ?, ?);”;
  
  mDatabase.execSQL(insertSQL, new String[]{outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, GPSDate,NAME_SYNCED_WITH_SERVER});
  
  finish();
  
  }
  
  Reply
  - GoRo says
    
    November 30, 2017 at 9:13 am
    
    protected Map getParams() {
    
    // Creating Map String Params.
    Map params = new HashMap();
    
    // Adding All values to Params.
    params.put(“OutletNo”, outletno);
    params.put(“Latitude”, lati);
    params.put(“Longitude”, longi);
    params.put(“DeviceSERIAL”, dserial);
    params.put(“GPS”, GPS);
    params.put(“NEWADDR”, GPSA);
    params.put(“ACC”, ACC);
    
    return params;
    }
    
    };
    
    // Creating RequestQueue.
    RequestQueue requestQueue = Volley.newRequestQueue(MainActivity.this);
    
    // Adding the StringRequest object into requestQueue.
    requestQueue.add(stringRequest);
    
    }
    
    Reply
    - GoRo says
      
      November 30, 2017 at 9:15 am
      
      The above you should edit according to your needs, below is the full code for your assistance.
      
      Full Code:
      
      private void addGPSCustomer() {
      
      //SQL Import
      
      EditText tb = (EditText) findViewById(R.id.OutletNo);
      TextView txtLatitude = (TextView) findViewById(R.id.txtLatitude1);
      TextView txtLongitude = (TextView) findViewById(R.id.txtLongitude1);
      TextView serial = (TextView) findViewById(R.id.serial);
      TextView gcdo = (TextView) findViewById(R.id.geoc);
      TextView addressup = (TextView) findViewById(R.id.addressup);
      TextView Cutna = (TextView) findViewById(R.id.customernamep);
      
      final String outletno = tb.getText().toString();
      final String outletname = Cutna.getText().toString().trim();
      final String lati = txtLatitude.getText().toString();
      final String longi = txtLongitude.getText().toString();
      final String dserial = serial.getText().toString();
      final String GPS = gcdo.getText().toString();
      final String GPSA = addressup.getText().toString();
      final String ACC = accu.getText().toString();
      
      //getting the current time for joining date
      Calendar cal = Calendar.getInstance();
      SimpleDateFormat sdf = new SimpleDateFormat(“yyyy-MM-dd hh:mm:ss”);
      final String GPSDate = sdf.format(cal.getTime());
      
      //validating the inptus
      requestQueue = Volley.newRequestQueue(MainActivity.this);
      
      progressDialog = new ProgressDialog(MainActivity.this);
      
      progressDialog.setMessage(“Please Wait, We are Inserting Your Data on Server”);
      progressDialog.show();
      
      // Creating string request with post method.
      StringRequest stringRequest = new StringRequest(Request.Method.POST, url_create_product,
      new Response.Listener() {
      @Override
      public void onResponse(String ServerResponse) {
      
      // Hiding the progress dialog after all task complete.
      progressDialog.dismiss();
      
      // Showing response message coming from server.
      // Toast.makeText(MainActivity.this, ServerResponse, Toast.LENGTH_LONG).show();
      
      String insertSQL = “INSERT INTO GPSPLOTS \n” +
      “(outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, datecap, syncedd)\n” +
      “VALUES \n” +
      “(?, ?, ?, ?, ?, ?, ?, ?, ?, ?);”;
      
      //using the same method execsql for inserting values
      //this time it has two parameters
      //first is the sql string and second is the parameters that is to be binded with the query
      mDatabase.execSQL(insertSQL, new String[]{outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, GPSDate,NAME_SYNCED_WITH_SERVER});
      
      // Toast.makeText(MainActivity.this, “- ” + outletno + ” ” + outletname + ” -\n\n”+”Added Successfully”, Toast.LENGTH_LONG).show();
      
      finish();
      
      }
      },
      new Response.ErrorListener() {
      @Override
      public void onErrorResponse(VolleyError volleyError) {
      
      // Hiding the progress dialog after all task complete.
      progressDialog.dismiss();
      
      // Showing error message if something goes wrong.
      // Toast.makeText(MainActivity.this, volleyError.toString(), Toast.LENGTH_LONG).show();
      
      String insertSQL = “INSERT INTO GPSPLOTS \n” +
      “(outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, datecap, syncedd)\n” +
      “VALUES \n” +
      “(?, ?, ?, ?, ?, ?, ?, ?, ?, ?);”;
      
      //using the same method execsql for inserting values
      //this time it has two parameters
      //first is the sql string and second is the parameters that is to be binded with the query
      mDatabase.execSQL(insertSQL, new String[]{outletno, outletname, lati, longi, dserial, GPS, GPSA, ACC, GPSDate,NAME_NOT_SYNCED_WITH_SERVER});
      
      // Toast.makeText(MainActivity.this, “- ” + outletno + ” ” + outletname + ” -\n\n”+”Added Successfully”, Toast.LENGTH_LONG).show();
      
      finish();
      }
      }) {
      @Override
      protected Map getParams() {
      
      // Creating Map String Params.
      Map params = new HashMap();
      
      // Adding All values to Params.
      params.put(“OutletNo”, outletno);
      params.put(“Latitude”, lati);
      params.put(“Longitude”, longi);
      params.put(“DeviceSERIAL”, dserial);
      params.put(“GPS”, GPS);
      params.put(“NEWADDR”, GPSA);
      params.put(“ACC”, ACC);
      
      return params;
      }
      
      };
      
      // Creating RequestQueue.
      RequestQueue requestQueue = Volley.newRequestQueue(MainActivity.this);
      
      // Adding the StringRequest object into requestQueue.
      requestQueue.add(stringRequest);
      
      }
      
      Reply
      - GoRo says
        
        November 30, 2017 at 9:17 am
        
        PHP File to be aligned with your SQL, here is mine:
trishul says

January 17, 2018 at 5:17 am

send me the code to delete the inserted data in the database and the same to reflect the deletetion in the app

Reply
- Gunjan says
  
  July 16, 2018 at 5:54 pm
  
  got any solution to this?
  
  Reply
Nurfaiqah says

January 20, 2018 at 3:35 am

how to add 2 column ?? i always get error .

Reply
Bryce says

February 7, 2018 at 3:10 am

how about SQL server? how to implement it?

Reply
Carlos says

February 16, 2018 at 12:43 am

Great tutorial.
Thanks for sharing.

Can you show how to make bidirectional sync?
thanks again.

Reply
Jimmy says

April 14, 2018 at 5:14 am

Is there any example of how can i Decide on wich Broadcast Receiver to register if I Edit a Name and want to update ther server on MSQL isntead of Inserting?

I have manage to edit but don;t now How to do it with the Broadcast Receiver.

Reply
Diego Montoya says

April 19, 2018 at 5:00 pm

HI, does anyone know how to sync more than one Table?
I Need to find out how to do that,because I have an app that needs to download at least 5 tables when network service is avalible.
I appreciate your advices.

Reply
jeph says

May 31, 2018 at 12:49 pm

hello. your work is amazing. it works on mine. however. i want to send data from mysql to sqlite. just reverse sequence in yours.

Reply
delicatecoder says

June 20, 2018 at 2:32 am

hi, what is public static final String DATA_SAVED_BROADCAST = “net.simplifiedcoding.datasaved”;
in mainactivity for?thanks sir.

Reply
- KIRPAL says
  
  October 19, 2018 at 6:26 am
  
  What is String DATA_SAVED_BROADCAST = “net.simplifiedcoding.datasaved”?
  
  Reply
karthi says

July 7, 2018 at 6:37 am

hai belan khan,
nice tutorial working fine thanks.

Now SQLite to MYSQL Synchronization.

i need MYSQL to SQLite SYNC how to do this kindly post 1 tutorial.

thanks

Reply
Karthi says

July 7, 2018 at 6:39 am

hai belan khan,

nice tutorial working fine thanks.

Now SQLite to MYSQL Synchronization.

i need MYSQL to SQLite SYNC how to do this kindly post 1 tutorial.

thanks

Reply
shruti says

July 13, 2018 at 1:08 pm

hello i tried your tutorial and it works as per my requirement…
But can u show me how can i send text + imgae to sqlite and server using volley ? Thanks in advance.. 🙂

Reply
karthikeyan says

July 20, 2018 at 12:45 pm

hai belan khan,

nice tutorial working fine thanks.

But some mobile Update same entries Duplicate to store my sql how to resolve this issue.

thanks

Reply
- MJ says
  
  July 20, 2018 at 12:57 pm
  
  I am Having the same problem here.The app is sending duplicate to the remote server
  
  Reply
- James says
  
  July 20, 2018 at 6:52 pm
  
  I was able to solve the issue of duplicates as below:
  @Override
  public void onResume() {
  super.onResume();
  registerReceiver(networkStateReceiver, new IntentFilter(android.net.ConnectivityManager.CONNECTIVITY_ACTION));
  }
  
  @Override
  public void onPause() {
  unregisterReceiver(networkStateReceiver);
  super.onPause();
  }
  @Override
  protected void onDestroy() {
  super.onDestroy();
  if(receiver !=null) {
  unregisterReceiver(networkStateReceiver);
  }
  
  Read more on this here
  https://stackoverflow.com/questions/6169059/android-event-for-internet-connectivity-state-change
  
  Reply
Marcelo says

July 31, 2018 at 1:40 pm

I have a set of data to send, but I can only send the next one when the previous response arrives. How can I make this request synchronously?

Reply
Chandre' Maverick G. Unsan says

August 9, 2018 at 1:27 pm

Hey dude thanks for making this , i use your code in making our thesis and thank you so much.

Reply
pritam says

August 26, 2018 at 7:36 am

how to connect my local host xampp server mysql

Reply
rezha says

September 10, 2018 at 4:21 am

you have example use retrofit2? from sqlite to post retrofit?

Reply
Bayu says

September 22, 2018 at 2:26 am

Can you make for update too not just insert?

Reply
andi says

October 6, 2018 at 4:40 pm

how to add field in saveName.php? so not just only name. so i can input name, address, number phone etc.
i confused in editing rest api in file saveName.php

Reply
Alpesh says

November 19, 2018 at 6:24 pm

hi Sir,

Do you have a tutorial for

How to save listview data with multiple columns in Mysql database with one single click.

Reply
shubi says

December 18, 2018 at 12:28 pm

plz tell me how the android the truthspy application work
and tell how to create my own spy app

Reply

Android Sync SQLite Database with Server using PHP and MySQL

Android Sync Sqlite Database with Server Demo

Creating Web Service and MySQL Database

Creating Database

Creating Web Service

Creating Script

Testing Script

Android Sync SQLite Database with Server

Creating Android Project

Adding Permissions

Adding Dependencies

Handling SQLite Operations

Handling Volley RequestQueue

Building Interface

MainActivity

ListView

Building ListView

Model Class

Adapter

Coding MainActivity

Detecting Network State

Creating Broadcast Receiver

Adding Receiver in Manifest

Registering Receiver

Testing the Application

Download Source Code

Related

About Belal Khan

Comments

Leave a Reply to Diego Montoya Cancel reply

About Simplified Coding

Quick Links

Android Sync Sqlite Database with Server Demo

Creating Web Service and MySQL Database

Creating Database

Creating Web Service

Creating Script

Testing Script

Android Sync SQLite Database with Server

Creating Android Project

Adding Permissions

Adding Dependencies

Handling SQLite Operations

Handling Volley RequestQueue

Building Interface

MainActivity

ListView

Building ListView

Model Class

Adapter

Coding MainActivity

Detecting Network State

Creating Broadcast Receiver

Adding Receiver in Manifest

Registering Receiver

Testing the Application

Download Source Code

Sharing is Caring:

Related

About Belal Khan

Comments

Leave a Reply to Diego Montoya Cancel reply

About Simplified Coding

Quick Links

Categories