Android interacts with PHP server

Transferred from: http://blog.csdn.net/ab_ba/article/details/7912424

Server side: server.php

[HTML]View Plaincopy

2. 1 <? PHP   
4. 2 include (' dbconfig.php ');
6. 3
8. 4
10. 5 $Address = $_post[' address ';
12. 6 $Longitude = $_post[' longitude '];
14. 7 $Latitude = $_post[' latitude '];
16. 8
18. 9
20. if (empty ($address) or empty ($longitude) or empty ($latitude)) {
22. One die ("one has to fill all the fields!");
24. 12}
26. $conn = mysql_connect($server, $username, $password);
28. if (! $conn) {
30. ("Connection failed:". Mysql_error ());
32. 16}
34. 17
36. mysql_select_db ($dbName, $conn);
38. 19
40. $Query = "INSERT into". $tableName. "VALUES (NULL," ". $address." ', ". $longitude.", "  . $latitude. "," ". Date (' y-m-d h:i:s ', Time ())."; ";
42. $result = mysql_query($query, $conn);
44. if (! $result) {
46. Die ("MySQL error:". Mysql_error ());
48. 24}
50. 25
52. echo "Add information to Database sucessfullly!";
54. ?>

Android side:

[Java]View Plaincopy

2. Package  Com.wenix;
6. Import  java.io.IOException;
8. Import  java.io.UnsupportedEncodingException;
10. Import  java.net.HttpURLConnection;
12. Import  java.util.ArrayList;
14. Import  java.util.List;
18. Import  org.apache.http.HttpConnection;
20. Import  org.apache.http.HttpEntity;
22. Import  Org.apache.http.HttpResponse;
24. Import  Org.apache.http.HttpStatus;
26. Import  Org.apache.http.NameValuePair;
28. Import  org.apache.http.client.ClientProtocolException;
30. Import  org.apache.http.client.HttpClient;
32. Import  org.apache.http.client.entity.UrlEncodedFormEntity;
34. Import  Org.apache.http.client.methods.HttpPost;
36. Import  org.apache.http.impl.client.DefaultHttpClient;
38. Import  Org.apache.http.message.BasicNameValuePair;
40. Import  org.apache.http.util.EntityUtils;
44. Import  android.app.Activity;
46. Import  Android.os.Bundle;
48. Import  Android.util.Log;
50. Import  Android.widget.TextView;
54. Public class mainactivity extends Activity {
56. Private   static final String TAG = "mainactivity";
58. TextView TV = null;
60. /** Called when the activity is first created. * /   
62. @Override   
64. Public void onCreate (Bundle savedinstancestate) {
66. Super  . OnCreate (savedinstancestate);
68. Setcontentview (R.layout.main);
72. TV = (TextView) Findviewbyid (r.id.ouputtxt);
76. String url = "http://10.52.31.96/server.php";
78. HttpPost HttpRequest = new httppost (URL);
82. list<namevaluepair> params = new arraylist<namevaluepair> ();
84. Params.add (new basicnamevaluepair ("Address", "Hubuxiang"));
86. Params.add (new basicnamevaluepair ("longitude", "100.252255"  ));
88. Params.add (new basicnamevaluepair ("latitude", "15.415121"  ));
92. Try  {  
94. Httpentity httpentity = new urlencodedformentity (params,"Utf-8");
96. Httprequest.setentity (httpentity);
100. HttpClient HttpClient = new defaulthttpclient ();
102. HttpResponse HttpResponse = Httpclient.execute (HttpRequest);
106. if (Httpresponse.getstatusline (). Getstatuscode () = = HTTPSTATUS.SC_OK) {
108. String result = entityutils.tostring (httpresponse.getentity ());
110. Tv.settext (result);
112. LOG.I (TAG,"result ="+result);
114. }Else{
116. Tv.settext ("Request Error");
118. }
120. } catch (unsupportedencodingexception e) {
122. //TODO auto-generated catch block   
124. E.printstacktrace ();
126. } catch (clientprotocolexception e) {
128. //TODO auto-generated catch block   
130. E.printstacktrace ();
132. } catch (IOException e) {
134. //TODO auto-generated catch block   
136. E.printstacktrace ();
138. }
140. }
142. }

Run the app and get the following results:

The database data is as follows: