php - 当我向数据库插入一个值时，它向数据库插入了两行

Question

在 Android 应用程序中，我使用 Php 代码将数据插入到 sql 数据库中当我向数据库中插入一条记录时，它正在插入两条记录。这里是

PHP:

<?php
$mysql_host     = "localhost";
$mysql_database = "...";
$mysql_user     = "...";
$mysql_password = "...";

$con            = mysql_connect($mysql_host, $mysql_user,$mysql_password,$mysql_database) || die("Error DB Connect");

$selectedDb     = mysql_select_db($mysql_database)||  die("Error in opening DB");

$points =  $_POST["points"];
$user   =  $_POST["user"];

$sql    =  "INSERT INTO `cusTrans`( `CID`, `Point`, `Date`, `time`,`Description`)
            VALUES ($user,$points,CURRENT_DATE,CURRENT_TIME,'Claim Point')";

if (mysql_query($sql)) {
    echo "OK";
} else {
    echo "Fault".mysql_error();
}
?>

安卓:

httpclientCD     =  new DefaultHttpClient();
httppostCD       =  new HttpPost("http://.../ClaimRecord.php");      
nameValuePairsCD =  new ArrayList<NameValuePair>(2);
nameValuePairsCD.add(new BasicNameValuePair("user", cus_id1));
nameValuePairsCD.add(new BasicNameValuePair("points", "1"));
httppostCD.setEntity(new UrlEncodedFormEntity(nameValuePairsCD));

// Execute HTTP Post Request
responseCD = httpclientCD.execute(httppostCD);
ResponseHandler<String> responseHandler = new BasicResponseHandler();
final String response1 = httpclientCD.execute(httppostCD, responseHandler);
System.out.println("Response CusUpdatePOint : "+id+"--" + response1);

Answer 1

您能否尝试在您的 android 部分中注释掉以 ResponseCD 开头的行？抱歉，我的回答很简短，但我在用手机。