删除无法使用连接按钮的代码 - Delete code not working with connecting button

在页面上，我试图在具有其他编辑功能的更新表单上使用删除按钮，但在所有尝试中，我的删除似乎都与此相混淆。

这是指向该网站的链接，因此您可以测试：http://exhibitjewellery.com/editstocktest.php（该按钮当前位于"系列中的所有部件"下，单击名称可将表单打开为可折叠面板）

我已经使用了dreaweaver cs5向导，如果这有助于了解其余代码的外观的话。你能帮我吗？

<?php 
if (isset($_GET['delete'])) {
echo 'Do you really want to delete ' . $_GET['delete'] . '? <a  href="editstock.php?yesdelete=' . $_GET['delete'] . '">Yes</a> | <a href="editstock.php">No</a>';
exit();
}
if (isset($_GET['yesdelete'])) {
$deleteSQL = sprintf("DELETE FROM pieces WHERE id='%s' LIMIT 1",
                   GetSQLValueString($_POST['id'], "int"));
mysql_select_db($database_connectmysql, $connectmysql);
$Result1 = mysql_query($deleteSQL, $connectmysql) or die(mysql_error());
header("location: editstock.php"); 
exit();
}
?>

通过此按钮激活的上述代码：

<input name="delete" type="button" id="delete" value="delete" style="width:20%; float:right"/>

如果您在http://exhibitjewellery.com/editstocktest.php您将看到您的表单使用method="post"

<form action="/editstocktest.php?" method="post" name="form4" id="form4">

所以你不能我们$_GET-

if (isset($_GET['delete'])) {}

此外，在您的删除链接中，您使用的是delete的值，但我认为您想要id-$_POST['id']

最后，当您单击该链接时，$_POST['id']不再可在if (isset($_GET['yesdelete']))中使用，因此您需要将id添加到url 中

编辑1
这里有一个建议的方法来改变它，尽管基于url删除从来都不是一个好主意。最好确保只有管理员才能通过这种方式访问/删除。注意，GetSQLValueString()是Dreamweaver创建的函数，因此您需要确保在定义该函数的位置包含该文件。

<?php 
if (isset($_POST['delete'])) {
echo 'Do you really want to delete ' . $_POST['piece'] . '? <a  href="editstock.php?yesdelete=' . $_POST['id'] . '">Yes</a> | <a href="editstock.php">No</a>';
exit();
}
if (isset($_GET['yesdelete'])) {
include('file where GetSQLValueString() is defined'); // you have to change **file where GetSQLValueString() is defined** to the file path
$deleteSQL = sprintf("DELETE FROM pieces WHERE id='%s' LIMIT 1",
                   GetSQLValueString($_GET['yesdelete'], "int"));
mysql_select_db($database_connectmysql, $connectmysql);
$Result1 = mysql_query($deleteSQL, $connectmysql) or die(mysql_error());
header("location: editstock.php"); 
exit();
}
?>

编辑#2
由于要使用onclick执行删除功能，因此需要修改location.href并使用$_GET。

你的html按钮

<input name="delete" type="button" id="delete" value="delete" style="width:20%; float:right" onclick="window.location.href = '?delete=delete&id=<?php echo $row['id']; ?>&piece=<?php echo $row['piece']; ?>'"/>

我不知道您是如何填充表单元素的，所以请更改$row['id']&$row['piece']添加到您的方法中。

然后你的删除功能-

<?php 
if (isset($_GET['delete'])) {
echo 'Do you really want to delete ' . $_GET['piece'] . '? <a  href="editstock.php?yesdelete=' . $_GET['id'] . '">Yes</a> | <a href="editstock.php">No</a>';
exit();
}
if (isset($_GET['yesdelete'])) {
include('file where GetSQLValueString() is defined'); // you have to change **file where GetSQLValueString() is defined** to the file path
$deleteSQL = sprintf("DELETE FROM pieces WHERE id='%s' LIMIT 1",
                   GetSQLValueString($_GET['yesdelete'], "int"));
mysql_select_db($database_connectmysql, $connectmysql);
$Result1 = mysql_query($deleteSQL, $connectmysql) or die(mysql_error());
header("location: editstock.php"); 
exit();
}
?>

编辑3
如果找不到dreamweaver定义函数的位置，可以重新声明它-

<?php 
if (isset($_GET['delete'])) {
echo 'Do you really want to delete ' . $_GET['piece'] . '? <a  href="editstock.php?yesdelete=' . $_GET['id'] . '">Yes</a> | <a href="editstock.php">No</a>';
exit();
}
if (isset($_GET['yesdelete'])) {
// redefine if does not exist
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType,
$theDefinedValue = "", $theNotDefinedValue = "") 
{
if (PHP_VERSION < 6) {
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ?
mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;    
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}

$deleteSQL = sprintf("DELETE FROM pieces WHERE id='%s' LIMIT 1",
                   GetSQLValueString($_GET['yesdelete'], "int"));
mysql_select_db($database_connectmysql, $connectmysql);
$Result1 = mysql_query($deleteSQL, $connectmysql) or die(mysql_error());
header("location: editstock.php"); 
exit();
}
?>

试试这个

<form action="" method="get">
    <input name="delete" type="submit" id="delete" value="delete" style="width:20%; float:right"/>
</form>

或

<input name="delete" type="button" id="delete" value="delete" style="width:20%; float:right" onclick="window.location.href = '?delete=delete'" />

我知道这听起来像是一个愚蠢的问题，但你在使用HTML表单吗？此外，您可能希望输入类型为"提交"，而不是"按钮"

又名

<form action="" method="GET">
    <input type="submit" name="delete" id="delete" value="delete" style="width:20%; float:right"/>
</form>