我正在用php开发一个用于web服务的android应用程序。在我的应用程序中,我在php文件中插入、更新、删除和搜索查询,并保存到www根目录中,然后我将php文件调用到android应用程序中。搜索功能运行良好,但删除功能不起作用。我已经附上了php文件、android代码和错误。有人能帮我吗???
**filename** (deletedetail.php)
<?php
include "config.php";
$id = $_POST['id'];
$sql1="delete from detail where id ='$id'";
$result=mysql_query($sql1);
if($result)
{
echo"OK";
}
else
{
echo "Error";
}
?>
**android CODE**
public String deleteDetail(int id) {
try {
httpclient = new DefaultHttpClient();
httppost = new HttpPost(
"http://10.0.2.2/dreamhotel/deletedetail.php"); // change this to your URL.....
nameValuePairs = new ArrayList<NameValuePair>(1);
nameValuePairs.add(new BasicNameValuePair("id",Integer.toString(id)));
ResponseHandler<String> responseHandler = new BasicResponseHandler();
response = httpclient.execute(httppost,responseHandler);
} catch (Exception e) {
System.out.println(e.getMessage());
}
return response;
}
Error in Android
at com.android.internal.os.LoggingPrintStream.println(LoggingPrintStream.java:298)
请使用HTTP GET方法而不是HTTP POST,对于HTTP GET方法,url应为.
http://10.0.2.2/dreamhotel/deletedetail.php?id=1
并制作一些chnage服务器端:用户服务器端$_GET或$_REQUEST,而不是$_POST。
请参阅下面我编辑了您的代码。
<?php
include "config.php";
//$id = $_POST['id'];
$id = $_GET['id'];
$sql1="delete from detail where id ='$id'";
$result=mysql_query($sql1);
if($result)
{
echo"OK";
}
else
{
echo "Error";
}
?>