Android app与php之间收发数据问题

Question

我在从Android应用程序向php页面发送数据时遇到了问题……我在android端有一个按钮，可以让我转到这个活动：

public class Post extends Activity {

public void postData(View v){
     //Create a new HttpClient and Post Header
        HttpClient httpclient = new DefaultHttpClient();
        HttpPost httppost = new HttpPost("http://192.168.1.67/phptester/insertdata.php"); 
        List<BasicNameValuePair> nameValuePairs = new ArrayList<BasicNameValuePair>(4);

        try {
            // Add your data
            nameValuePairs.add(new BasicNameValuePair("id", "1"));
            nameValuePairs.add(new BasicNameValuePair("descr", "Fire"));
            nameValuePairs.add(new BasicNameValuePair("lat", "1.333"));
            nameValuePairs.add(new BasicNameValuePair("lng", "1.333"));

            httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs)); 

            // Execute HTTP Post Request
            HttpResponse response = httpclient.execute(httppost);
            HttpEntity entity = response.getEntity();
            InputStream is = entity.getContent();
            Log.i("postData", response.getStatusLine().toString());



        } catch (IOException e) {
            Log.e("log_tag", "Error in http connection "+e.toString());
        }
}

}

这是我的php代码：

  <?php
   $conn = mysql_connect("localhost", "root", "") or die(mysql_error());

   mysql_select_db("locationdb", $conn);

   if (isset($_POST["id"]) && isset($_POST['descr']) && isset($_POST['lat']) && isset($_POST['lng']))
   {
     $id = $_POST["id"];
     $descr = $_POST["descr"]; 
     $lat = $_POST["lat"];
     $lon = $_POST["lon"];

     $query = mysql_query("INSERT INTO location (ID, Description, lat, lng) VALUES('6', '$descr', '1.666', '1.666')");

     echo "data inserted";
     mysql_query($query);

}

else {

    echo "Not data was intered ".mysql_error() ;
}

?>

最让我头疼的问题是数据库中没有存储数据，我不知道为什么！看起来php无法从Android app....Any获取数据，提前感谢帮助..

Answer 1

这不是一个解决方案，但将帮助您了解服务器发送回您的应用程序的数据，从而帮助您调试问题。

String response = httpclient.execute(httppost, new BasicResponseHandler());
Log.i("myapp", "Reply from server: " + response);

现在，你从PHP脚本中echo回来的任何东西都会打印到Android日志中，这可能会让你更容易弄清楚到底发生了什么。

Answer 2

尝试一些故障排除(确保logfile可写)：

file_put_contents('logfile', print_r($_POST, true)."\n\n", FILE_APPEND);

还会记录数据库中的错误：

$query = 'INSERT INTO ...';
mysql_query($query) or
   file_put_contents('logfile', 'DB error: '.mysql_error()."\nQuery: ".$query."\n\n", FILE_APPEND);