php : reading json arraylist and saving data in mysql?

Question

I want to read arraylist from android into php in order to store in database, but I'm not able to find exact code for it. Can anybody guide me in the direction to solve this problem ?

Here is my java code for creating the arraylist

private void loadCart()
{

    productList.clear();
    Cursor cursor = dbHelper.getCarProducts();
    cursor.moveToFirst();
    do {
        CartProduct cartProduct = new CartProduct();
        cartProduct.setProductName("Name: "+cursor.getString(cursor.getColumnIndex("_Name")));
        cartProduct.setProductCost("Cost: "+cursor.getString(cursor.getColumnIndex("_Cost")));
        cartProduct.setProductPrice("Price: "+cursor.getString(cursor.getColumnIndex("_Price")));
        cartProduct.setProductQuantity("Quantity: "+cursor.getString(cursor.getColumnIndex("_Quantity")));
        productList.add(cartProduct);

    }while(cursor.moveToNext());


}

I'm using retrofit2 in order to send the arraylist to the server, but as I have seen in other question here I'm not able to get the url for the file_get_contents ?

@Pritamkumar this is the java and i'm unable to begin with php code — atul kumar
– atul kumar, Commented Sep 15, 2017 at 8:09
What u exactly want to do, is u want to send Name, Cost... type of data to server or u want to receive and and store it into db. if u want to send ur data to server then use retrofit as u mentioned but first u have web service to receive it if u send me this what kind of data format it will able to receive then I am able to guide u. — SWAPDROiD
– SWAPDROiD, Commented Sep 15, 2017 at 8:29
i want to send all data at once in order to store in the db column wise in one go — atul kumar
– atul kumar, Commented Sep 15, 2017 at 8:36

SWAPDROiD · Accepted Answer · 2017-09-19 04:16:54Z

Here you go...

Step 1: Add retrofit dependency in your gradle.app

compile 'com.squareup.retrofit:retrofit:1.9.0'

Step 2: Make an RestClient class like below.

public class RestClient {
    private static final String BASE_URL = DataConstants.TEST_URL; //Place your web service URL here
    private ApiInterface apiService;

    public RestClient()
    {
        RequestInterceptor requestInterceptor = new RequestInterceptor() {
            @Override
            public void intercept(RequestFacade request) {

                request.addHeader("Accept", "application/json");
            }
        };

        RestAdapter restAdapter = new RestAdapter.Builder()
                .setLogLevel(RestAdapter.LogLevel.FULL)
                .setRequestInterceptor(requestInterceptor)
                .setEndpoint(BASE_URL)
                .build();

        apiService = restAdapter.create(ApiInterface.class);
    }

    public ApiInterface getApiService()
    {
        return apiService;
    }
}

Step 3: Make an Interface for POST URL.

public interface ApiInterface {
    @POST("/sendData")
    void sendData(@Body JsonObject jsonObject,
                          Callback<DataModel> dataModelCallback);
}

Step 4: Make an POJO class like below.

public class DataModel{
    private String success;

public String getSuccess() {
        return success;
    }

public void setSuccess(String success) {
        this.success = success;
    }

}

Step 5: Make an call of webservice from your activity like below.

private void callWebService(String user_id) {
        try {//TODO SEND
            final Utility utility = new Utility(this);
            utility.showProgressDialog();
            JsonObject myJsonData = new JsonObject();
            myJsonData.addProperty("user_id", user_id);
            Gson gsonData = new GsonBuilder().create();
            JsonArray dataArray = new JsonArray();
            dataArray = gsonData.toJsonTree(productList).getAsJsonArray();  //Here you want to add your array list i.e productList
            myJsonData.add("assign_to", jaAssignee);

            new RestClient().getApiService().sendData(myJsonData, new Callback<DataModel>() {
                @Override
                public void success(DataModel dataModel, Response response) {
                    utility.hideProgressDialog();
                    try {
                        String success = dataModel.getSuccess();
                        if (success.equalsIgnoreCase("Success")) {
                            //Do what you want to do
                        }
                    } catch (Exception e) {
                    }
                }

                @Override
                public void failure(RetrofitError error) {
                    utility.hideProgressDialog();
                }
            });
        } catch (Exception e) {
        }
    }

Hope this will help you!

i need php script in order to parse my array/list in order to store data in the database

The90sArtist · Accepted Answer · 2017-09-15 09:58:08Z

0

Send all your data in one go. Create JsonArray and add each object by creating JsonObject. After its done upload all the data in one go. You'll just have to decode that array in php.

Advantage of using this is, you can manage the response in retrofit very well (being it asynchronous)

answered Sep 15, 2017 at 9:58

The90sArtist

1951 gold badge2 silver badges12 bronze badges

2 Comments

atul kumar Over a year ago

could give me the php script for parsing the json array

The90sArtist Over a year ago

You can find it anywhere. Search json_decode function in php.

Pritamkumar · Accepted Answer · 2017-09-15 10:39:59Z

0

you can parse json value in php by

<?php 
   header('Content-type: application/json');
   $jsonString = file_get_contents('php://input');   
   $jsonArray = json_decode($jsonString,true);

   print_r($jsonArray);/* print array */

?>

edited Sep 15, 2017 at 10:39

answered Sep 15, 2017 at 10:21

Pritamkumar

6861 gold badge12 silver badges31 bronze badges

2 Comments

atul kumar Over a year ago

for file_get_contents which link should be given?

Pritamkumar Over a year ago

no link is required as you are expecting data from android by json data

atul kumar · Accepted Answer · 2017-10-09 19:33:39Z

After almost searching for 3+ weeks and n+ hours of frustration, i've finally found an working solution to my problem and sharing it with people so they could benefit from it (as i was blocked from another a/c due to asking too many questions and down votes ) , in order to send your array list to your server we need to use another library and the best fit according to my need is async-http library by loop j and these are the steps to import and use the library in your program :-

1.)import the library into your project by writing this statement in your bulid.gradle(app module):-

compile 'com.loopj.android:android-async-http:1.4.9'

2.)Create the following variables in order to use them in your program:-

 AsyncHttpClient (a client to send data to your server)
    RequestPrarms (Data sent to your server for parsing and further operations )
    String url(Link to your server where actually operations occurs)

3.) Now we use these variables and run the program :-

p

arams.put("OrderSummary", <your array list>);
           httpClient.post(APIURL.API_URL,params, new AsyncHttpResponseHandler() {
               @Override
               public void onSuccess(int statusCode, Header[] headers, byte[] responseBody) {
                   //your operations on success
               }

               @Override
               public void onFailure(int statusCode, Header[] headers, byte[] responseBody, Throwable error) {
                    Toast.makeText(getApplicationContext(),error.toString(),Toast.LENGTH_LONG).show();
               }
           });

i hope this clears your doubts somewhat i'm still creating my php side in order to insert data in the database

Collectives™ on Stack Overflow

php : reading json arraylist and saving data in mysql?

4 Answers 4

1 Comment

2 Comments

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related