Android与PHP服务器交互

服务器端：server.php

  1 <?php  2         include('dbconfig.php');  3   4   5         $address = $_POST['address'];  6         $longitude = $_POST['longitude'];  7         $latitude = $_POST['latitude'];  8   9  10         if(empty($address) or empty($longitude) or empty($latitude)){ 11                 die("You have to fill all the fields!"); 12         } 13         $conn = mysql_connect($server,$username,$password); 14         if(!$conn){ 15                 die("connection failed:".mysql_error()); 16         } 17  18         mysql_select_db($dbName,$conn); 19  20         $query = "insert into ".$tableName." values(NULL,'".$address."',".$longitude.",".$latitude.",'".date('Y-m-d H:i:s',time())."');"; 21         $result = mysql_query($query,$conn); 22         if(!$result){ 23                 die("mysql error:".mysql_error()); 24         } 25  26         echo "add information to database sucessfullly!"; 27 ?>

Android端：

package com.wenix;import java.io.IOException;import java.io.UnsupportedEncodingException;import java.net.HttpURLConnection;import java.util.ArrayList;import java.util.List;import org.apache.http.HttpConnection;import org.apache.http.HttpEntity;import org.apache.http.HttpResponse;import org.apache.http.HttpStatus;import org.apache.http.NameValuePair;import org.apache.http.client.ClientProtocolException;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 org.apache.http.util.EntityUtils;import android.app.Activity;import android.os.Bundle;import android.util.Log;import android.widget.TextView;public class MainActivity extends Activity {private static final String TAG = "MainActivity";TextView tv = null;    /** Called when the activity is first created. */    @Override    public void onCreate(Bundle savedInstanceState) {        super.onCreate(savedInstanceState);        setContentView(R.layout.main);                tv = (TextView)findViewById(R.id.ouputTxt);                String url = "http://10.52.31.96/server.php";        HttpPost httpRequest = new HttpPost(url);                List<NameValuePair> params = new ArrayList<NameValuePair>();        params.add(new BasicNameValuePair("address", "hubuxiang"));        params.add(new BasicNameValuePair("longitude", "100.252255"));        params.add(new BasicNameValuePair("latitude", "-15.415121"));                try {HttpEntity httpEntity = new UrlEncodedFormEntity(params,"utf-8");httpRequest.setEntity(httpEntity);HttpClient httpClient = new DefaultHttpClient();HttpResponse httpResponse = httpClient.execute(httpRequest);if(httpResponse.getStatusLine().getStatusCode() == HttpStatus.SC_OK){String result = EntityUtils.toString(httpResponse.getEntity());tv.setText(result);Log.i(TAG,"result = "+result);}else{tv.setText("request error");}} catch (UnsupportedEncodingException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (ClientProtocolException e) {// TODO Auto-generated catch blocke.printStackTrace();} catch (IOException e) {// TODO Auto-generated catch blocke.printStackTrace();}    }}

运行APP，得到如下结果：

Android与PHP服务器交互_第1张图片

数据库数据如下：

Android与PHP服务器交互_第2张图片

更多相关文章

随机推荐