Android to JSON to PHP to MySQL

Question

I'm trying to send a few STRING variables from android to PHP as JSON. I accomplished this using one of the guides on the internet but unfortunately its not working and i'm unable to solve it using other similar questions on StackOverflow.

Here's my android code :-

JSONObject jsonObject= new JSONObject();
JSONArray jsonArray=new JSONArray();

public class sendData extends AsyncTask<String, String, Void> {

    @Override
    protected Void doInBackground(String... params) {

        HttpClient httpClient = new DefaultHttpClient();
        HttpPost httpPost = new HttpPost("http://bdp.site40.net/sendRegData.php");

        try {
            HttpEntity httpEntity = new StringEntity(jsonArray.toString());
            httpPost.setEntity(httpEntity);
            httpClient.execute(httpPost);
        }
        catch (IOException e) {
        }

        return null;
    }
}

public void onClickSubmitButton(View view) throws JSONException {

    jsonObject.put("name",name);
    jsonObject.put("blood",blood);
    jsonObject.put("cell",cell);
    jsonObject.put("email", email);
    jsonObject.put("address",address);
    jsonObject.put("country",country);
    jsonObject.put("state",state);
    jsonObject.put("city",city);

    jsonArray.put(jsonObject);

    new sendData().execute();

}

And here is my PHP code :-

<?php 

    $json = file_get_contents("php://input");
    $data = json_decode($json);
    $name = $data[0]->name;
    $blood = $data[0]->blood;
    $cell = $data[0]->cell;
    $email = $data[0]->email;
    $address = $data[0]->address;
    $country = $data[0]->country;
    $state = $data[0]->state;
    $city = $data[0]->city;
    $con = mysql_connect("","","") or die(mysqli_connect_error());
    $db = mysql_select_db("",$con) or die(mysqli_connect_error());
    mysql_query("INSERT INTO Donors(Name,Blood,Mobile,E-Mail,Address,Country,State,City)VALUES('$name','$blood','$cell','$email','$address','$country','$state','$city')");

?>

After experimenting a little I have narrowed it down to the fact that the problem lies in which i SEND data to the PHP script AND/OR the way data is RECIEVED by the PHP script. Can anyone please look for the problem and correct it? Thank You!

Points to Note:

I have removed MySQL username,password,database name and host for privacy(obviously).
All the 8 variables are in String format.

@Satya but the PHP script does not get any values till i click on the Submit button on my app. So how do i get to see the values after i click the submit button? — sd3993
– sd3993, Commented Aug 28, 2013 at 6:00

trebron · Accepted Answer · 2013-08-28 06:09:16Z

0

Remove the lines:

httpPost.setHeader("JSONObject", jsonObject.toString());
httpPost.getParams().setParameter("JSONArray", jsonArray);

and put your JSON content in POST body instead:

HttpEntity entity = new StringEntity(jsonArray.toString());
httpPost.setEntity(entity);

You will also need to modify your PHP script in order to handle JSON array properly.

...
$name = $data[0]->name;
$blood = $data[0]->blood;
$cell = $data[0]->cell;
...

edited Aug 28, 2013 at 6:09

answered Aug 28, 2013 at 5:59

trebron

3561 silver badge4 bronze badges

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

8 Comments

sd3993 Over a year ago

That should be StringEntity entity = new StringEntity(jsonArray.toString()); right?? And any ideas on how I should modify my php script? I'm new to this.

trebron Over a year ago

replacing $data-> with $data[0]-> should be enough

sd3993 Over a year ago

ah yes ok. my bad. forgot the import statement. :/

sd3993 Over a year ago

ok so i made all the changes. but it still won't work. Nothing gets added to the MySQL database. I'm running the app from and emulator currently. Any specific changes that i need to make for the url in HttpPost??

trebron Over a year ago

Is bdp.site40.net/public_html/sendRegData.php url valid? I am redirected to error404.000webhost.com

|

Collectives™ on Stack Overflow

Android to JSON to PHP to MySQL

1 Answer 1

8 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

8 Comments

Your Answer

Sign up or log in

Post as a guest

Related