Android程序通过Apache服务器执行PHP程序连接Mysql数据库(重要！)

看了网上别人的文章弄了许久，总算成功了，提醒一下,android程序得导入包org.apache的jar包.

db_config.php:

<?php
/**
 * Created by PhpStorm.
 * User: Ollydebug
 * Date: 2015/11/17
 * Time: 20:05
 */

define('DB_USER',"root");   //db user
define('DB_PASSWORD',"");   //db password
define('DB_DATABASE',"test");   //database name
define('DB_SERVER',"localhost");  //db server


?>

server.php:

<?php
/**
 * Created by PhpStorm.
 * User: Ollydebug
 * Date: 2015/11/17
 * Time: 19:48
 */

include('db_config.php');

$address = $_POST['address'];
$longitude = $_POST['longitude'];
$latitude = $_POST['latitude'];
$id = $_POST['_id'];
$tableName = "androidtable";

if(empty($address)or empty($longitude)or empty($latitude)){
    die("You have to fill all the fields!");
}
$conn = mysql_connect(DB_SERVER,DB_USER,DB_PASSWORD);

if(!$conn){
    die("connection failed:".mysql_error());
}

mysql_select_db(DB_DATABASE,$conn);

$query = "insert into ".$tableName." values(".$id.",'".$address."',".$longitude.",".$latitude.",'".date('Y-m-d H:i:s',time())."');";

$result = mysql_query($query,$conn);

if(!$result){
    die("mysql error:".mysql_error());
}


echo "add information to database sucessfullly!";



?>

Android:

请求网络为耗时操作，必须操作在子线程当中.另外别忘了加权限.题主开头各种坑......

   <uses-permission android:name="android.permission.INTERNET" />

java:

(啰嗦一下，PHP文件得放到apache服务器的文件夹下，然后注意不能用localhost)

android访问服务器的时候不能用localhost或者127.0.0.1,因为android自己本身也有本地服务器,这样就找不到你的地址，

必须得用内网的ip地址,切记！！

package com.example.ollydebug.myapplication;

import android.os.Bundle;
import android.os.Handler;
import android.os.Message;
import android.support.v7.app.AppCompatActivity;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.TextView;

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 java.io.IOException;
import java.io.UnsupportedEncodingException;
import java.util.ArrayList;
import java.util.List;


public class MainActivity extends AppCompatActivity {

    private static final String TAG = "MainActivity";
    private TextView tv = null;
    private Button button = null;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);
        tv = (TextView)findViewById(R.id.outputTxt);
        button = (Button)findViewById(R.id.button);
        button.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                System.out.println("-->开启子线程");
                new TaskThread().start();
            }
        });
    }

    Handler handler = new Handler() {
        public void handleMessage(Message msg) {
            switch (msg.what) {
                case 0:
                {
                    System.out.println("-->回到主线程刷新ui任务");
                    String result = "add information to database sucessfullly!";
                    tv.setText(result);
                    Log.i(TAG,"result = "+result);
                }
                break;

                default:
                    break;
            }
        };
    };


    class TaskThread extends Thread {
        public void run() {
            System.out.println("-->做一些耗时的任务");
            String url = "http://172.19.82.99/AndroidInteraction/server.php";
            HttpPost httpRequest = new HttpPost(url);
            List<NameValuePair> params = new ArrayList<NameValuePair>();
            params.add(new BasicNameValuePair("_id","1"));
            params.add(new BasicNameValuePair("address", "yinchengzhi"));
            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());
                    System.out.println(result);

                    /*
                    如果要更新视图不能在子线程中更新，只能在主线程中刷新UI
                    tv.setText(result);
                    Log.i(TAG,"result = "+result);
                    */

                    Message msg = new Message();
                    msg.what = 0;
                    handler.sendMessage(msg);

                }else{
                    tv.setText("request error");
                }
            } catch (UnsupportedEncodingException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (ClientProtocolException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
            try {
                sleep(500);
            } catch (InterruptedException e) {
                e.printStackTrace();
            }
            handler.sendEmptyMessage(0);
        };
    };

}

xml:

（这个简单！不罗嗦了！）

<?xml version="1.0" encoding="utf-8"?>
<android.support.design.widget.CoordinatorLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:fitsSystemWindows="true"
    tools:context="com.example.ollydebug.myapplication.MainActivity">

    <android.support.design.widget.AppBarLayout
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:theme="@style/AppTheme.AppBarOverlay">

        <android.support.v7.widget.Toolbar
            android:id="@+id/toolbar"
            android:layout_width="match_parent"
            android:layout_height="?attr/actionBarSize"
            android:background="?attr/colorPrimary"
            app:popupTheme="@style/AppTheme.PopupOverlay" />

    </android.support.design.widget.AppBarLayout>

    <include layout="@layout/content_main" />

    <android.support.design.widget.FloatingActionButton
        android:id="@+id/fab"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:layout_gravity="bottom|end"
        android:layout_margin="@dimen/fab_margin"
        android:src="@android:drawable/ic_dialog_email" />

</android.support.design.widget.CoordinatorLayout>