Fetch data in Json array and send it to server

Question

I am developing an android application where I am fetch all the data in j son array. Now i want to send said Json array to MySQL database on server.

db.open();     
ArrayList<HashMap<String, String>> arrayList = db.Record();    
Gson gson = new Gson();   
String jsonPesan = gson.toJson(arrayList);  
db.close();

Try this tutorial, androidhive.info/2012/05/how-to-connect-android-with-php-mysql — Hein
– Hein, Commented Feb 8, 2016 at 6:48

Community · Accepted Answer · 2017-05-23 11:59:25Z

0

You need to make web-service ,you can post your data to server using webservice.

How to send data to MySQL DB without using JDBC , PHP or any other webservice?

edited May 23, 2017 at 11:59

CommunityBot

11 silver badge

answered Feb 8, 2016 at 6:47

Vasant

3,6053 gold badges21 silver badges34 bronze badges

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

Comments

Aziz · Accepted Answer · 2016-02-08 07:24:42Z

0

You can use JSON API to create a json array and then use URL Builder to send the json as a parameter to the API.

jsonAttriArray = new JSONArray();
                                try {
                                    if (!someInput.getText().toString().equalsIgnoreCase(""))
                                             {
                                        JSONObject jsonObject1 = new JSONObject();
                                        jsonObject1.put("object1", someInput.getText());

                                        jsonAttriArray.put(jsonObject1);
                                    }
                                    if (!someInput2.getText().toString().equalsIgnoreCase(""))
                                             {
                                        JSONObject jsonObject2 = new JSONObject();
                                        jsonObject2.put("object2", someInput2.getText());

                                        jsonAttriArray.put(jsonObject2);

                                    }

                                } catch (Exception e) {
                                    // TO DO
                                }

Uri.Builder builder = new Uri.Builder(); builder.appendQueryParameter("jsonparams", jsonAttriArray.toString());

 String query = builder.build().getEncodedQuery();
            OutputStream os = conn.getOutputStream();
            BufferedWriter writer = new BufferedWriter(new OutputStreamWriter(os, "UTF-8"));
            writer.write(query);
            writer.flush();
            writer.close();
            os.close();

answered Feb 8, 2016 at 7:24

Aziz

2441 silver badge5 bronze badges

5 Comments

Aziz Over a year ago

db.open(); ArrayList<HashMap<String, String>> arrayList = db.Record(); Gson gson = new Gson(); String jsonPesan = gson.toJson(arrayList); db.close(); You already have the code just start a loop and insert the arrayList values in the Json array like what I did in above code and then you have the json String with you. You try first and then it it doesn't work we can look into it

Qamar Din Over a year ago

Dear how to connect server and that this j son array to server database MySQL please help me

Qamar Din Over a year ago

Dear Aziz reply please

Aziz Over a year ago

Hein provided you with a tutorial link, please follow that and do everything step by step

Qamar Din Over a year ago

dear this tutorials bit difficult for me pleas help me tell me step to connect with server and post data in MySQL database

Collectives™ on Stack Overflow

Fetch data in Json array and send it to server

2 Answers 2

Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related