Android mysql php问题

Question

I have an application which gets some data from a remote database. I use PHP with the following code to connect to the data base.

mysql_connect($host,$username,$password) or die( "no connection");
@mysql_select_db($database) or die( "Unable to select database");

$query = $_REQUEST['query'];
$q=mysql_query($query);

while($e=mysql_fetch_assoc($q)) {
    $output[]=$e;
}
print(json_encode($output));

mysql_close();

I then connect via following java code

public void connect(ArrayList<NameValuePair> nameValuePairs) {
        result = "";
        InputStream is = null;

        String url = "http://'ipadress'/PhpProject1/EmptyPHP.php";

        //Get the content
        try {
            HttpClient httpClient = new DefaultHttpClient();
            HttpPost httpPost = new HttpPost(url);
            httpPost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
            HttpResponse httpResponse = httpClient.execute(httpPost);
            HttpEntity httpEntity = httpResponse.getEntity();

            is = httpEntity.getContent();
        } catch (Exception e) {
            Log.e("Connect", "Error in http connection " + e.toString());
        }
        //Convert content toString
        try {
            BufferedReader reader = new BufferedReader(new InputStreamReader(is, HTTP.UTF_8), 8);
            StringBuilder sb = new StringBuilder();
            String line = null;

            while ((line = reader.readLine()) != null) {
                sb.append(line + "
");
            }
            is.close();
            result = sb.toString();
            //result = replaceString(sb.toString());
        } catch (Exception e) {
            Log.e("Connect", "Error converting result " + e.toString());
        }
    }

When i have done that I make a query through

public void query(String query){
        ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
        nameValuePairs.add(new BasicNameValuePair("query", query));
        connect(nameValuePairs);
    } 

While this works great with the emulator there is a problem when using it on the phone.

Anyone has a clue why this is?

Thank you in advance

Answer 1

Make sure to connect your real device to the your private network to actually be able to access that server.

Easiest option would be a WiFi network in the same subnet as the server. Otherwise your phone won't be able to access the network as it is not public.