How to send stored data on a SQLite db in android to PHP webserver using HTTP in android

Question

Is there a any way to submit data stored in an android SQLite database in format

--------------------------------------------
ID  PRODUCT_ID     AMOUNT
--------------------------------------------
1      001            4
2      008            5
3      006            2

to PHP web server using HTTP in android. I am maintaining a local database for specific transaction and after user complete the transaction I want to submit those data in to web system.Can anybody please help me regarding this.

Vinay S Shenoy · Accepted Answer · 2012-09-22 15:28:47Z

3

Convert each row of the database into a JSONObject and store all the rows into a JSONArray
Convert the JSONArray into a json string using jsonArray.toString() and make an HTTP POST request. Make sure to set the Content-Type parameter to application/json
On the server side, process the request accordingly and store it into a database.

Note: If you're having large amounts of data, it might be better to transfer the JSON Objects in batches. You can add parameters to the requests to denote batch ids when you reconstruct the database.

EDIT: I'm assuming you know how to fetch the cursor to the database.

You can use the following code

JSONObject jObject;
JSONArray jArray = new JSONArray()

while(cursor.moveToNext()) {

    jObject = new JSONObject();
    jObject.put("id", cursor.getInt("ID"));
    jObject.put("product_id", cursor.getString("PRODUCT_ID"));
    jObject.put("amount", cursor.getInt("AMOUNT"));
    jArray.put(jObject);

}

When you're building the HTTP POST request, do jArray.toString() to get a JSON string representing the array. Hope this helps.

edited Sep 22, 2012 at 15:28

answered Sep 22, 2012 at 13:21

Vinay S Shenoy

4,0283 gold badges33 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Damith Over a year ago

can you please provide me a sample code for convert each row of the database into a JSONObject using a loop.

Vinay S Shenoy Over a year ago

Be sure to put these in a try/catch block as these functions throw JSONExceptions.

Damith Over a year ago

Let me try it and come back to reply you.

Damith Over a year ago

I didn't use cursor because i already fetched data from the database and stored in a List<ShoppingCartEntity> list. I simply loop the list and used your concept inside the loop. Finally it worked for me.Thank you very much and this was my first question here.

Vinay S Shenoy Over a year ago

No problem.. :-). For future reference, don't store these values in a separate list when you can use the cursor directly. You might run into OutOfMemory errors. Put them into a list(or even better, a normal array) only if you need to do fast processing on those items.

Collectives™ on Stack Overflow

How to send stored data on a SQLite db in android to PHP webserver using HTTP in android

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related