2

I'm trying to pass a value to my php webservice. I already use this code for pass the "name" value :

 private class MyAsyncTask extends AsyncTask<String, Void, Void> {

    protected Void doInBackground (String... params)
    {
            Intent intent = getIntent();
            String name = intent.getStringExtra("KEY_NAME");
            //HttpClient httpclient = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("http://10.0.2.2/secure_login/get_data_user.php");

            List<NameValuePair> nameValuePair = new ArrayList<NameValuePair>(1);
            nameValuePair.add(new BasicNameValuePair("KEY_NAME", name));
            DefaultHttpClient hc = new DefaultHttpClient();
           // HttpResponse response = hc.execute(httppost);


            try {
                httppost.setEntity(new UrlEncodedFormEntity(nameValuePair));
            } catch (UnsupportedEncodingException e){
                // writing error to log
                e.printStackTrace();
            }

            try {
                HttpResponse response = hc.execute(httppost);
                HttpEntity entity = response.getEntity();
                InputStream inStream = entity.getContent();
                // writing response to log
                Log.d("Http Response:", response.toString());

               } catch (ClientProtocolException e) {
                   // writing exception to log
                   e.printStackTrace();
               } catch (IOException e) {
                   e.printStackTrace();
               }
            return null;



    }

And this, for convert Stream to String.

          protected String convertStreamToString(InputStream inStream)
            {
               BufferedReader reader = new BufferedReader(new InputStreamReader(inStream));
               StringBuilder sb = new StringBuilder();

               String line = null;
               try 
               {
                   while ((line = reader.readLine()) != null) 
                   {
                       sb.append(line + "\n");
                   }
               } 
               catch (IOException e) 
               {
                   e.printStackTrace();
               } 
               finally 
               {
                   try 
                   {
                       inStream.close();
                   } 
                   catch (IOException e) 
                   {
                       e.printStackTrace();
                   }
               }
               return sb.toString();
            }
  }

But I only got this response in log cat : org.apache.http.message.BasicHttpResponse@43e4c068

I need to pass the "name" value so my php webservice can retrieve and do the query like this :

 if (isset($_GET['name'])) {
$name = $_GET['name'];

require_once 'DB_Functions.php';
$db = new DB_Functions();
$result = mysql_query("SELECT name, email from users where name = '$name'");

How do I should fix it? Thank you in advance.

user2476947
  • 25
  • 1
  • 8

1 Answers1

0

You are sending a post request in android and trying to retrieve the parameter in PHP with $_GET.

Try to access the name variable via $_POST:

if (isset($_POST['name']))
    $name = mysql_real_escape_string($_POST['name']);

require_once 'DB_Functions.php';
$db = new DB_Functions();
$result = mysql_query("SELECT name, email from users where name = '$name'");

Important: Don't forget to escape the strings before you put them in your SQL statement with mysql_real_escape_string to avoid SQL injections.

shi
  • 480
  • 6
  • 10