Inserting Data to Mysql Server as json String - No Data uploading

Question

Referring to various examples over stack, I wrote below code to send data to MySQL server table, but nothing is uploading there. Here is code for my Android method.

 public void sendtoserver(final String data) {
        Log.e("LWFAB", "Sending Data to Server");
        //Send data to server now
        new Thread(new Runnable() {
            @Override
            public void run() {
                try {
                    URL bulkdataurl = new URL("http://myphp.php?");
                    HttpURLConnection bulkcon = (HttpURLConnection) bulkdataurl.openConnection();
                    bulkcon.setConnectTimeout(15000);
                    bulkcon.setReadTimeout(15000);
                    bulkcon.setRequestMethod("POST");
                    bulkcon.setDoOutput(true);
                    BufferedOutputStream bufferedOutputStream = new BufferedOutputStream(bulkcon.getOutputStream());
                    BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(bufferedOutputStream));
                    bufferedWriter.write(data);
                    bufferedWriter.flush();
                    bufferedWriter.close();
                    bufferedOutputStream.close();
                    bulkcon.connect();
                    //OutputStreamWriter outputStreamWriter = new OutputStreamWriter(bulkcon.getOutputStream());
                    //outputStreamWriter.write(data);
                    //outputStreamWriter.flush();

                    //Get Server Response
                    BufferedReader bufferedReader;
                    bufferedReader = new BufferedReader(new InputStreamReader(bulkcon.getInputStream()));
                    StringBuilder stringBuilder = new StringBuilder();
                    String line = null;

                    while ((line = bufferedReader.readLine()) != null) {
                        stringBuilder.append(line + "\n");
                    }
                    System.out.println(stringBuilder.toString());
                    bufferedReader.close();

                    System.out.println("Sending Bulk Data " + bulkcon);


                } catch (Exception e) {
                    e.printStackTrace();
                }
            }
        }).start();

    }
}

I m not getting any error. Below is my php code

<?php
require_once("../dbconnect.php"); 

$json = file_get_contents('php://input');
$obj = json_decode($json, true);
error_log(print_r($obj, true));
$array_data = $obj["data"];
print_r($obj["data"]);


foreach ($array_data as $row) {
    print_r($row);
    $sql = "INSERT INTO test (vid, name,branch,date,time) VALUES ('" . $row["vid"] . "', '" . $row["name"] . "','".$row["branch"]."','".$row["date"]."','".$row["time"]."')";

    echo "$sql<br>";
    $conn->query($sql);
}

$conn->close();
?>

And sample of data being sent as string is as below:

{"data":[{"vid":"1","name":"raj","branch":"mech","date":"2-Sep-2017","time":"13:03:24 PM"}]}

Can u guide if there is something to fix.

Little Bobby says you may be at risk for SQL Injection Attacks. Learn about Prepared Statements with parameterized queries. I recommend PDO, which I wrote a function for to make it extremely easy, clean, and more secure than using non-parameterized queries. Also, This article may help you choose between MySQLi and PDO — GrumpyCrouton
– GrumpyCrouton, Commented Oct 2, 2017 at 12:47
Also note that the data you have shown is not valid json, the strings are not quoted. So $obj will always be empty. — jeroen
– jeroen, Commented Oct 2, 2017 at 12:48
@Panache stackoverflow.com/questions/10329500/… check this, you need the getString not getInt — Yamen Nassif
– Yamen Nassif, Commented Oct 2, 2017 at 13:02

Yamen Nassif · Accepted Answer · 2017-10-02 13:04:21Z

3

You are using cursor.getInt(1) which will return an integer from the cursor. You need to use cursor.getString() in Order to get the string and put them correctly in JSON.

This is a small example:

jsonObject.put("vid", curser.getString(cursor.getColumnIndex("vid")));

answered Oct 2, 2017 at 13:04

Yamen Nassif

2,4962 gold badges28 silver badges50 bronze badges

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

3 Comments

Panache Over a year ago

now getting correct format of json, still no data being uploaded? what else left, ps guide.

Yamen Nassif Over a year ago

1- check the URL. is it public ? accissable ? 2- check the connect to db try to add something like this to make sure you are connected : $con = mysql_connect('localhost','root','123456') or die('Cannot connect to the DB'); 3- try to add some headers URLConnection.setRequestProperty("Content-Type", "application/json"); 4- echo something on the server to see if you are recieving the request or not: echo json_encode($json));

Yamen Nassif Over a year ago

glad to help :).

Collectives™ on Stack Overflow

Inserting Data to Mysql Server as json String - No Data uploading

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related