无法获取要执行的PDO删除语句

Question

I am having trouble getting a form to post a variable and then have my PDO statement execute a delete. I do know that the variable $resulting[WID] does have the correct value stored in it in my form. The problem is lies in passing the variable from this form to the code below to execute the delete statement. The error am getting is: Invalid parameter number: parameter was not defined

//here is the php/PDO code:

 if(isset($_POST['remove'])){
 $the_WID = $_POST['WID'];
 echo "here is the WID" . $the_WID;

 $dlt = "DELETE FROM writing WHERE writing.WID = :writing.WID";
 $stmtdlt = $dbh->prepare($dlt);
 $stmtdlt->bindParam(':writing.WID', $the_WID, PDO::PARAM_INT);                                           
 $stmtdlt->execute(); 
 }

//here is the form

<form action="" method="post">
<button type="submit">Delete</button>
<input TYPE="hidden" name="remove" VALUE="<?php $resulting[WID]; ?>">
</form>

Answer 1

1. $the_WID = $_POST['WID']; should be $the_WID = $_POST['remove'];.

2. You need to echo your value: value="<?php echo $resulting[WID]; ?>"

3. From the answer to this question, it appears that you cannot use . in a placeholder:

BINDCHR = [:][a-zA-Z0-9_]+;

You can use alphanumeric + underscore.

Change your PHP to:

if(isset($_POST['remove'])){
    $the_WID = $_POST['remove'];
    echo "here is the WID" . $the_WID;

    $dlt = "DELETE FROM writing WHERE writing.WID = :writingWID";
    $stmtdlt = $dbh->prepare($dlt);
    $stmtdlt->bindParam(':writingWID', $the_WID, PDO::PARAM_INT);                                           
    $stmtdlt->execute(); 
}

and your HTML form to:

<form action="" method="post">
<button type="submit">Delete</button>
<input type="hidden" name="remove" value="<?php echo $resulting[WID]; ?>">
</form>