dongqiao3833 2016-06-27 08:14
浏览 5
已采纳

从下拉列表中删除值

I'm trying to Code a function that allow me to delete a selected value from a Dropdown list. 

<?php
require_once("db.inc.php");
?>
</head>
<body>
<form action="" method="POST">
 <?php





$stmt = $mysqli->prepare("SELECT anr, name FROM artikel");
$stmt->execute();
$stmt->bind_result($anr, $name);


echo "<select name='selected_name'><br />";

while ($stmt->fetch()) {

echo '<option value='.$anr.'>'.$anr.' | '.$name.'</option>';


if(isset($_POST['loeschen'])){

    $stmt = $mysqli->prepare("DELETE FROM artikel WHERE anr=?");
        $stmt->bind_param('i', $anr);
        $stmt->execute();
        $stmt->close();
        $mysqli->close();

    }

}   


  ?>
  <input type="submit" value="Datensatz löschen" name="loeschen">
</form>
</body>
</html>

My Problem is that the values are going to be deleted even i don't press the submit button. Thank you in advance for your suggestions.

  • 写回答

2条回答 默认 最新

  • dscojuxf69080 2016-06-27 08:21
    关注

    Use Post value instead of $anr.

    <?php
require_once("db.inc.php");
?>
</head>
<body>
<?php
if(isset($_POST['selected_name'])){

    $stmt = $mysqli->prepare("DELETE FROM artikel WHERE anr=?");
        $stmt->bind_param('i', $_POST['selected_name']);
        $stmt->execute();
        $stmt->close();
        $mysqli->close();

    }

}
?>
<form action="" method="POST">
 <?php

$stmt = $mysqli->prepare("SELECT anr, name FROM artikel");
$stmt->execute();
$stmt->bind_result($anr, $name);
echo "<select name='selected_name'><br />";
while ($stmt->fetch()) {
echo '<option value='.$anr.'>'.$anr.' | '.$name.'</option>';
}
echo "</select>";
  ?>
  <input type="submit" value="Datensatz löschen" name="loeschen">
</form>
</body>
</html>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题？

悬赏问题

  • ¥15 拟通过pc下指令到安卓系统，如果追求响应速度，尽可能无延迟，是不是用安卓模拟器会优于实体的安卓手机？如果是，可以快多少毫秒？
  • ¥20 神经网络Sequential name=sequential, built=False
  • ¥16 Qphython 用xlrd读取excel报错
  • ¥15 单片机学习顺序问题！！
  • ¥15 ikuai客户端多拨vpn，重启总是有个别重拨不上
  • ¥20 关于#anlogic#sdram#的问题，如何解决？(关键词-performance)
  • ¥15 相敏解调 matlab
  • ¥15 求lingo代码和思路
  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应