Erreur compilation application Android & MySQL
Bonjour;
Je souhaite q'une appli android se connecte à une bdd mysql pour y extraire des données.
lors de la compilation de mon app, émulateur android m"affiche l'erreur suivant:
Sorry!the application HelloMetaComputer(process.com.Android.HelloMetaComputer)has stopped unexpectedly. Please Try again
j'arrive pas a résoudre l'erreur. :(
Mon fichier php connexion_mysql.php :
Code:
1
2
3
4
5
6
7
8
9
|
$conn = mysql_connect ("localhost", "root", "");
$db_select = mysql_select_db ("etablissements", $conn);
$result =mysql_query("SELECT nom from ecoles", $conn);
while ($row=mysql_fetch_assoc($result))
$output[] = $row;
print(json_encode($output));
mysql_close($conn);
?> |
Et le code de mon Activity :
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
|
public class HelloMetaComputer extends ListActivity {
/** Called when the activity is first created. */
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
//setContentView(R.layout.main);
String result = null;
InputStream is = null;
JSONObject json_data=null;
ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
ArrayList<String> donnees = new ArrayList<String>();
try{
//commandes httpClient
HttpClient httpclient = new DefaultHttpClient();
HttpPost httppost = new HttpPost("http://10.0.2.2/connexion_mysql.php");
httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
HttpResponse response = httpclient.execute(httppost);
HttpEntity entity = response.getEntity();
is = entity.getContent();
}
catch(Exception e){
Log.i("taghttppost",""+e.toString());
Toast.makeText(getBaseContext(),e.toString() ,Toast.LENGTH_LONG).show();
}
//conversion de la réponse en chaine de caractère
try
{
BufferedReader reader = new BufferedReader(new InputStreamReader(is,"UTF-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.i("tagconvertstr",""+e.toString());
}
//recuperation des donnees json
try{
JSONArray jArray = new JSONArray(result);
for(int i=0;i<jArray.length();i++)
{
json_data = jArray.getJSONObject(i);
donnees.add(json_data.getString("nom"));
//r.add(json_data.getString("categorie"));
}
setListAdapter(new ArrayAdapter<String>(this, android.R.layout.simple_expandable_list_item_1, donnees));
}
catch(JSONException e){
Log.i("tagjsonexp",""+e.toString());
} catch (ParseException e) {
Log.i("tagjsonpars",""+e.toString());
}
}
} |
Merci :D
