Android : get data from MySQL using 'where' condition

Question

I am trying to get data from MySQL database to my android app using where condition. I already create a method for get data. This method give me all data as a string array from a single column. Look the bellow method :

String adress = "http://myserver_link/get_data.php";
InputStream inputStream = null;
String line = null, result = null, data[];

private void get_data(){
    try {
        URL url = new URL(adress);
        HttpURLConnection httpsURLConnection = (HttpURLConnection) url.openConnection();
        httpsURLConnection.setRequestMethod("GET");

        inputStream = new BufferedInputStream(httpsURLConnection.getInputStream());

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

    // read input stream into a string
    try{
        BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream));
        StringBuilder stringBuilder = new StringBuilder();

        while ((line = bufferedReader.readLine()) != null){
            stringBuilder.append(line + "\n");
        }

        inputStream.close();
        result = stringBuilder.toString();
    }
    catch (Exception e) {
        e.printStackTrace();
    }

    // Parse json data
    try{
        JSONArray jsonArray = new JSONArray(result);
        JSONObject jsonObject = null;

        data = new String[jsonArray.length()];
        for (int i=0; i<jsonArray.length(); i++){
            jsonObject = jsonArray.getJSONObject(i);
            data[i] = jsonObject.getString("user_adress"); // column name
        }
    }
    catch (Exception e){
        e.printStackTrace();
    }
}

This is my get data java method. And my get_data.php code is :

<?php 
require "conn.php";

$query = mysqli_query($conn, "select * from android_data");

if ($query) {
    while ($row = mysqli_fetch_array($query)) {
        $flag[] = $row;
    }
    print(json_encode($flag));
}

$conn->close();
 ?>

Now I want to write my get_data.php file like bellow :

<?php 
require "conn.php";

$user_name = $_POST["username"];

$query = mysqli_query($conn, "select * from android_data where username='$user_name'");

if ($query) {
    while ($row = mysqli_fetch_array($query)) {
        $flag[] = $row;
    }
    print(json_encode($flag));
}

$conn->close();
 ?>

But how I can send username using get_data() java method from my app?

You should look into prepared statements as well

apokryfos
– apokryfos

2018-03-09 08:19:19 +00:00
Commented Mar 9, 2018 at 8:19 — apokryfos
– apokryfos, Commented Mar 9, 2018 at 8:19

Nigel Ren · Accepted Answer · 2018-03-09 08:08:18Z

2

You should probably send this as a parameter on the URL...

String adress = "http://myserver_link/get_data.php?username=xxxxx";

Not done Java for a while, but you can create this string using the appropriate value for xxxxx.

This will then be passed in as $_GET["username"] instead of $_POST["username"]. So just replace this line

$user_name = $_POST["username"];

with

$user_name = $_GET["username"];

answered Mar 9, 2018 at 8:08

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Comments

User001 · Accepted Answer · 2018-06-03 20:17:56Z

0

Or you can change the Request method to POST in your Java code.

answered Jun 3, 2018 at 20:17

User001

34 bronze badges

Collectives™ on Stack Overflow

Android : get data from MySQL using 'where' condition

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related