Can't login from my Android app using HttpPost

Question

The php code

$userName=$_POST['userName'];
$userPassword=$_POST['userPassword'];
.
.
$result=MYSQL_QUERY("SELECT * FROM USER WHERE UserName='$userName' and   Password='$userPassword' ");

$count=mysql_num_rows($result);

if($count==1){

session_start();
$_SESSION["userName"] = "$userName";
echo 1;
header('Location: http://www.naviwi.com/points.php');
}
else {
header('Location: http://www.naviwi.com/signUp.php');
}
ob_end_flush();

?>

The java code. I get the username and password values from two TexitEdit IO.

public void userLogin(View view){


        HttpClient httpclient = new DefaultHttpClient();
        HttpPost httppost = new HttpPost("http://naviwi.com/checkLogin");

        List<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>(2);
        nameValuePairs.add(new BasicNameValuePair("userName", username));
        nameValuePairs.add(new BasicNameValuePair("userPassword", password));
        try {
            httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
        }catch(UnsupportedEncodingException e){
            et.append("UnsupportedEncodingException");
        }

        try {
            response = httpclient.execute(httppost);
        }catch (Exception e) {
            et.append("Server not Responding"+ response);
        }

        et.append(" Server respond "+response);
    }

So the problem is that I always get null. I want to get the 1 from the response method in PHP.

yet another NOMTE ... please at least do e.printStackTrace() at catch to see what error you are getting — Selvin, Dec 22 '14 at 11:03
Where can I find the result of this call. Im using android studio. — Zhexa, Dec 22 '14 at 11:26
@Zhexa What do you mean by "not working"? What is this supposed to do? Because you are simply doing nothing with the response. — tato.rodrigo, Dec 22 '14 at 13:22
@Zhexa So you have to update you PHP script to return such information (for example, return a JSON) instead of just doing a HTTP redirect to a HTML page. — tato.rodrigo, Dec 22 '14 at 13:57
The code I use in eclipse works with echo. When I move it to android Studio its no longer working. I tried to add JSON but still no luck. — Zhexa, Dec 22 '14 at 14:37

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

0

The SQL query is using a wrong field. The password field is called 'userPassword', so you query should be

$result=MYSQL_QUERY("SELECT * FROM USER WHERE UserName='$userName' and   userPassword='$userPassword' ");

WARNING: You're storing clear text passwords on your database and this is a really bad practice. You should hash them with a salt

edited May 23 '17 at 12:12

Community

1
1

answered Dec 22 '14 at 11:05

fjuan

2,214
2
17
20

1

The php is working when I access it from my webpage. In my database its Password not userPassword, so this is not the bug. – Zhexa Dec 22 '14 at 11:11
try this ` nameValuePairs.add(new BasicNameValuePair("Password", password));` – Clinton Dsouza Dec 22 '14 at 18:32

Can't login from my Android app using HttpPost

1 Answers1