How can I send SQLite data from Android to MySQL server?

Question

I am trying to send SQLite data with an MySQL online server, but to no avail. Naturally, I ran to Google and was lucky to find this . Apparently, it should work, and it works, but I am not receiving data on my server.

I know that this question is asked here and here , but I could not fix it using the above suggestions.

Here is what I have tried. Here's how I convert SQLite data to JSON using GSON:

public String composeJSONfromSQLite() { ArrayList<HashMap<String, String>> offlineList; offlineList = new ArrayList<HashMap<String, String>>(); String selectQuery = "SELECT * FROM offlineTable "; SQLiteDatabase database = this.getWritableDatabase(); Cursor cursor = database.rawQuery(selectQuery, null); if (cursor.moveToFirst()) { do { HashMap<String, String> map = new HashMap<String, String>(); map.put("zip", cursor.getString(1)); map.put("phone", cursor.getString(2)); map.put("uid", cursor.getString(3)); offlineList.add(map); } while (cursor.moveToNext()); } database.close(); Gson gson = new GsonBuilder().create(); //Use GSON to serialize Array List to JSON return gson.toJson(offlineList); } 

And this is how I send it to my server:

 public void syncSQLiteMySQLDB() { AsyncHttpClient client = new AsyncHttpClient(); RequestParams params = new RequestParams(); params.put("offline",loadCheckoutDB.composeJSONfromSQLite()); Log.d("offline data log", loadCheckoutDB.composeJSONfromSQLite()); client.addHeader("session_id", getapikey()); client.addHeader("Content-Type", "application/json"); client.post("http://example.com/offline/api", params, new AsyncHttpResponseHandler() { @Override public void onSuccess(int statusCode, Header[] headers, byte[] responseBody) { String s = new String(responseBody); Log.d("response to sync", s); try { JSONObject obj = new JSONObject(s); if (obj.getBoolean("success")) { String success = obj.getString("message"); //Toast.makeText(getApplicationContext(), success, Toast.LENGTH_LONG).show(); } else { String failure = obj.getString("message"); //Toast.makeText(getApplicationContext(), failure, Toast.LENGTH_LONG).show(); } } catch (JSONException e) { } } @Override public void onFailure(int statusCode, Header[] headers, byte[] responseBody, Throwable error) { // Toast.makeText(getApplicationContext(), "Failed to sync with server", Toast.LENGTH_LONG).show(); Log.d("sqlite sync error", String.valueOf(error)); progbar.setVisibility(View.INVISIBLE); } }); } 

And when I register what JASON looks like with Android, I get this format:

 [{ "zip": "325, "phone": "78291849", "uid": "14538177211" }] 

But on my server, I still get an empty array. What am I doing wrong?

Here's what my request format should look like:

 { "offline":[ { "zip": "325, "phone": "78291849", "uid": "14538177211" } ] } 

This is how I get the request:

 public function massData() // offline sync { $input = Input::all(); return $input; 

Answer 1

Here is how I did it:

  public void syncSQLiteMySQLDB() { //i get my json string from sqlite, see the code i posted above about this final String json = loadCheckoutDB.composeJSONfromSQLite(); new Thread() { public void run() { makeRequest("http://myexample/offline/api", json); } }.start(); } public void makeRequest(String uri, String json) { try { HttpClient client = new DefaultHttpClient(); HttpPost httpPost = new HttpPost(uri); httpPost.setEntity(new StringEntity(json)); httpPost.setHeader("Accept", "application/json"); httpPost.setHeader("session_id", getapikey()); httpPost.setHeader("Content-type", "application/json"); HttpResponse response = client.execute(httpPost); if (response != null) { String responseBody = EntityUtils.toString(response.getEntity()); Log.d("response to sync", responseBody); Object jsonObj = new JSONTokener(responseBody).nextValue(); if (jsonObj instanceof JSONObject) { JSONObject jsonObject = (JSONObject) jsonObj; //further actions on jsonObjects } else if (jsonObj instanceof JSONArray) { //further actions on jsonArray JSONArray jsonArray = (JSONArray) jsonObj; } } } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (ClientProtocolException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } catch (JSONException e) { e.printStackTrace(); } } 

From registering numerous answers, I found that I did not send the content type using my previous method. After checking this code, it worked.

Answer 2

Add your list to the map, where the key is offline , and specify this list:

 public String composeJSONfromSQLite() { ArrayList<HashMap<String, String>> offlineList; offlineList = new ArrayList<HashMap<String, String>>(); String selectQuery = "SELECT * FROM offlineTable "; SQLiteDatabase database = this.getWritableDatabase(); Cursor cursor = database.rawQuery(selectQuery, null); if (cursor.moveToFirst()) { do { HashMap<String, String> map = new HashMap<String, String>(); map.put("zip", cursor.getString(1)); map.put("phone", cursor.getString(2)); map.put("uid", cursor.getString(3)); offlineList.add(map); } while (cursor.moveToNext()); } HashMap<String, ArrayList<HashMap<String, String>>> offlineMap = new HashMap<String, ArrayList<HashMap<String, String>>>(); offlineMap.put("offline", offlineList); database.close(); Gson gson = new GsonBuilder().create(); //Use GSON to serialize Array List to JSON return gson.toJson(offlineMap); }