Sending data from Android app to MySQL database

Question

I am a newbie attempting to send data from an Android app to a MySQL database set up on a localhost server via xampp. This method is supposed to put a name, username, password, phone number, and age into an arraylist of type NameValuePair.

@Override
    protected Void doInBackground(Void... params) {
            ArrayList<NameValuePair> dataToSend = new ArrayList<>();
            dataToSend.add(new BasicNameValuePair("name", user.name));
            dataToSend.add(new BasicNameValuePair("age", user.age + ""));
            dataToSend.add(new BasicNameValuePair("username", user.username));
            dataToSend.add(new BasicNameValuePair("password", user.password));
            dataToSend.add(new BasicNameValuePair("phoneNumber", user.phoneNumber));

        HttpParams httpRequestParams = new BasicHttpParams();
        HttpConnectionParams.setConnectionTimeout(httpRequestParams, CONNECTION_TIMEOUT);
        HttpConnectionParams.setSoTimeout(httpRequestParams, CONNECTION_TIMEOUT);

        HttpClient client = new DefaultHttpClient(httpRequestParams);

        HttpPost post = new HttpPost("localhost/Register.php");

        try{
            post.setEntity(new UrlEncodedFormEntity(dataToSend));
            client.execute(post);
        }catch(Exception e){
            e.printStackTrace();
        }
        return null;
    }

When I run the application, I receive the following exception:

Target host must not be null, or set in parameters. scheme=null, host=null, path=localhost/Register.php

My research leads me to believe that there's a problem with the url string, but I don't know specifically what the issue is.

Thanks in advance.

(P.S. I am also aware of the awful security implications of storing a password in plain text on a database. Just trying to learn how to interact between apps and databases. Thx)

It connects you to localhost, because in some emulators localhost is directly not working. — Sarvagna Mehta
– Sarvagna Mehta, Commented Jun 11, 2015 at 4:26
@bharat is SYSTEM_IP_ADDRESS the same as the localhost address? — Johnny
– Johnny, Commented Jun 11, 2015 at 18:31

Sarvagna Mehta · Accepted Answer · 2015-06-11 03:29:23Z

2

Try this code to post data if the localhost replacement doesn't work for you.

   HttpParams params = new DefaultHttpParams(); // setup whatever params you what
    HttpClient client = new DefaultHttpClient(params);
    HttpPost post = new HttpPost("someurl");
    post.setEntity(new UrlEncodedFormEntity()); // with list of key-value pairs
    client.execute(post, new ResponseHandler(){}); // implement ResponseHandler to handle response correctly.

answered Jun 11, 2015 at 3:29

Sarvagna Mehta

3403 silver badges16 bronze badges

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

Comments

Johnny · Accepted Answer · 2015-06-23 20:38:07Z

0

My issue was simply that I was using the wrong ip address. For some reason or another, localhost does not work. I figured out my system's ipv4 address (not 10.0.2.2) and used that and it worked.

answered Jun 23, 2015 at 20:38

Johnny

1051 silver badge13 bronze badges

Collectives™ on Stack Overflow

Sending data from Android app to MySQL database

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