Android HttpURLConnection POST not working.

Question

I'm trying to check if a number exists in the database, but am unable to send forward the data from android to php. Should the data be String, JSON or HashMap? How do I send it?

Java

try {

            URL url = new URL("http://192.168.0.106/cei/tourist_home_activities.php");
            HttpURLConnection conn = (HttpURLConnection) url.openConnection();
            conn.setRequestMethod("POST");
            conn.setReadTimeout(15*1000);
            conn.setConnectTimeout(15*1000);
            conn.setRequestProperty( "Content-Type", "application/json" );
            conn.setRequestProperty("Accept", "application/json");
            conn.setDoOutput(true);
            conn.setDoInput(true);
            conn.connect();

            OutputStream os = conn.getOutputStream();

            BufferedWriter bufferedWriter = new BufferedWriter(new OutputStreamWriter(os,"UTF-8"));

            bufferedWriter.write(*Here is where I assume I input data*);
            bufferedWriter.flush();
            bufferedWriter.close();
            os.close();

            InputStream inputStream = conn.getInputStream();
            BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream,"iso-8859-1"));
            String line = "";

            while ((line = bufferedReader.readLine())!=null)
            {
                response+= line;
            }
            bufferedReader.close();
            inputStream.close();
            conn.disconnect();

        } catch (IOException e) {
            e.printStackTrace();
        }

PHP

<?php

$servername = "127.0.0.1";
$username = "root";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
} 

mysqli_select_db($conn,"discover_ilhabela");

$PIN=$_POST['pin'];

$result = mysqli_query($conn, "SELECT Name FROM `monitors` WHERE     `PIN`='$PIN'");

/*  if (mysql_num_rows($result)==1)
{
 print("1"); 
}
else
{
 print("0");
} */

 print($PIN);

 ?>

I'm trying to check if there is any result to confirm that the number exists in the database, but first I'm just trying to return the string and it's returning as empty.

Thanks for the code you shared, I used it as it is and worked perfectly well — Christopher Kikoti, Mar 24 '17 at 12:34

score 0 · Accepted Answer · edited May 23 '17 at 12:00

0

Your PHP endpoint expects $_POST['pin'] so you should send as plain text. Refer to this: How to add parameters to HttpURLConnection using POST

edited May 23 '17 at 12:00

Community

1
1

answered Sep 18 '16 at 19:33

user1506104

6,554
4
71
89

Isn't NameValuePair deprecated though? – MihirK98 Sep 18 '16 at 19:34
you can do bufferedWriter.write("pin=1234".getBytes()); – user1506104 Sep 18 '16 at 19:40
1

I saw the hashmap answer, and thank you for the other suggestion too. Really appreciate it. :) – MihirK98 Sep 18 '16 at 19:42
np. you should accept the answer by clicking the check mark. with that, we keep others from doing extra effort to solve the problem when in fact it is already resolved. :) – user1506104 Sep 18 '16 at 19:48

Android HttpURLConnection POST not working.

1 Answers1