javascript - 如何使用JSON编码的数据定义具有SQL行ID的元素

我正在使用jQuery AJAX处理表单数据，它的PHP端应删除服务器上的两个文件，然后删除数据库中的SQL行（用于发送给它的ID）。然后，包含SQL行的元素应更改颜色，上移，删除，然后下一个SQL行移入其位置。动画内容发生在ajax回调的beforeSend和success函数中。

该脚本不起作用，当用户单击按钮时，页面URL会更改为php脚本的URL，但不会在服务器或数据库中删除项目和文件。也不会发生任何动画。

这是我第一次使用jQuery ajax，我认为在回调期间如何定义元素存在问题。任何帮助都会很棒：

js

$("document").ready(function(){
    $(".delform").submit(function(){
data = $(this).serialize() + "&" + $.param(data);
        if (confirm("Are you sure you want to delete this listing?")) {
            $.ajax({
                type: "POST",
                dataType: "json",
                url: "delete_list.php",
                data: data,
                beforeSend: function()  {
                    $( "#" + data["idc"] ).animate({'backgroundColor':'#fb6c6c'},600);
                                        },
                success: function() {
                    $( "#" + data["idc"] ).slideUp(600,function() {
                    $( "#" + data["idc"] ).remove();
                                          });
                                    }
                    });
                    return false;
        }
    });
});

的PHP

  if (isset($_POST["id"]))
{
$idc = $_POST["id"];

if (isset($_POST["ad_link"]) && !empty($_POST["ad_link"]))
    {
$ad_linkd=$_POST["ad_link"];
unlink($ad_linkd);
    }

if (isset($_POST["listing_img"]) && !empty($_POST["listing_img"]))
        {
$listing_imgd=$_POST["listing_img"];
unlink($listing_imgd);
        }

try                 {
require('../dbcon2.php');
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "DELETE FROM listings WHERE id = $idc";
$conn->exec($sql);

             }
catch (PDOException $e) {
echo $sql . "<br>" . $e->getMessage();
                    }
    echo json_encode($idc);
 }

html

<div id="record-<?php echo $id; ?>">
           *bunch of stuff*
   <form method="post" class="delform">
<input name="id" type="hidden" id="id" value="<?php echo $id; ?>" />
<input name="ad_link" type="hidden" id="ad_link" value="<?php echo $ad_link; ?>" />
<input name="listing_img" type="hidden" id="listing_img" value="<?php echo $listing_img; ?>" />
<button type="submit">Delete</button>
  </form>
    </div>

最佳答案

您应该像这样修复您的php代码

try {
    require('../dbcon2.php');
    // It's better, if you will going to use MySQL DB, use the class designed to connect with it.
    $conn = mysqli_connect("Servername", "usernameDB", "PasswordDB", "NameDB");
    $sql = "DELETE FROM listings WHERE id = $idc";
    mysqli_query($conn, $sql);
    // you have to create a asociative array for a better control
    $data = array("success" => true, "idc" => $idc);
    // and you have to encode the data and also exit the code.
    exit(json_encode($data));
} catch (Exception $e) {
    // you have to create a asociative array for a better control
    $data = array("success" => false, "sentence" => $sql, "error" => $e.getMessage());
    // and you have to encode the data and also exit the code.
    exit(json_encode($data));
}

现在，您将JS代码Ajax更改为此。

$.ajax({
    type: "POST",
    dataType: "json",
    url: "delete_list.php",
    data: data,
    beforeSend: function()  {
        $( "#" + data["idc"] ).animate({'backgroundColor':'#fb6c6c'},600);
    },
    success: function(response) {
        // the variable response is the data returned from 'delete_list.php' the JSON
        // now validate if the data returned run well
        if (response.success) {
            $( "#" + response.idc ).slideUp(600,function() {
                $( "#" + response.idc ).remove();
            });
        } else {
            console.log("An error has ocurred: sentence: " + response.sentence + "error: " + response.error);
        }
    },
    // add a handler to error cases.
    error: function() {
        alert("An Error has ocurred contacting with the server. Sorry");
    }
});

关于javascript - 如何使用JSON编码的数据定义具有SQL行ID的元素，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/27000840/