Android mysql php sorunu

0 Cevap php

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();

Daha sonra java kodu aşağıdaki yoluyla bağlanmak

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 + "\n");
            }
            is.close();
            result = sb.toString();
            //result = replaceString(sb.toString());
        } catch (Exception e) {
            Log.e("Connect", "Error converting result " + e.toString());
        }
    }

I üzerinden bir sorgu yapmak yaptığınızda

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

Bu emülatör ile büyük işler yaparken telefonda kullanırken bir sorun var.

Herkes bu yüzden bir ipucu var?

Şimdiden teşekkürler

0 Cevap