Non riesco a connettermi ad un database online
Ciao ragazzi, ho un problema da risolvere. Ho scaricato un'app che faceva una connessione ad un database. Ho inserito i dati del mio database e l'app va, stampandomi il giusto risultato della mia query.
Ho provato a rifare l'app, apparentemente identica a quella che ho scaricato. Dico apparentemente xkè in realtà a me non va. Vi elenco i miei files
activity_main.xml
MainActivity.java
la classe che richiama JSON
Codice PHP:
package com.db.connection;
import java.io.BufferedReader;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.HttpClient;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.message.BasicNameValuePair;
import android.util.Log;
public class sendQuery {
/////////// Public method to send Query ///////////
public static String send(String query) {
String result = "0";
InputStream is = null;
//the query to send
ArrayList<NameValuePair> querySend = new ArrayList<NameValuePair>();
querySend.add(new BasicNameValuePair("querySend",query));
//http post
try{
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://www.ilmiosito.com/query.php");
httppost.setEntity(new UrlEncodedFormEntity(querySend));
HttpResponse response = httpclient.execute(httppost);
HttpEntity entity = response.getEntity();
is = entity.getContent();
}catch(Exception e){
Log.e("log_tag", "Error in http connection "+e.toString());
}
//convert response to string
try{
BufferedReader reader = new BufferedReader(
new InputStreamReader(is,"iso-8859-1"),8);
StringBuilder sb = new StringBuilder();
String line = null;
while ((line = reader.readLine()) != null) {
sb.append(line + "\n");
}
is.close();
result=sb.toString();
}catch(Exception e){
Log.e("log_tag", "Error converting result: "+e.toString());
}
Log.i("SendQUERY", result);
return result;
}
}
e infine il mio php query.php
Codice PHP:
<?php
mysql_connect("***","***","***");
mysql_select_db("***");
$query = $_REQUEST['querySend'];
$sql=mysql_query($query);
while($row=mysql_fetch_assoc($sql))
$output[]=$row;
print(json_encode($output));
mysql_close();
?>
.
chiaramente ho dato il permesso INTERNET nell' AndroidManifest
spero riusciate a risolvere almeno voi!