从下拉列表中删除选定的数据(php) - Removing selected data from drop down list(php)

Removing selected data from drop down list(php)

本文关键字：数据 php 下拉列表删除 | 更新日期: 2023-09-27

我需要创建一个函数，该函数将我的数据从数据库检索到下拉列表中，然后选择并删除所选数据。我把下拉列表设置成&工作，但我遇到一些错误与我的"删除"功能。

  <body> 
<?php
//connecting to database
 $server = 'localhost'; 
 $username = 'root'; 
 $password = 'infosys'; 
 $database = 'project'; 
 mysql_connect($server,$username,$password) or die(mysql_error());
 mysql_select_db($database) or die(mysql_error());
//dropdown list to retrieve sentence
$sql = "SELECT words FROM sentence";
$result = mysql_query($sql);
 echo "<select name  
='dropdownlist'>";
while ($row = mysql_fetch_array($result)) {
 echo "<option value='" . $row['words'] ."'>" . $row['words'] ."</option>";
}
echo "</select>";
?>
 <form method="post" action="remove.php"> 
 <input type="submit" value="Remove" /> 
 </form> 
 <a href="index.php" >View list</a>
 </body>

后面跟着另一个php文件

<?php
 $server = 'localhost'; 
 $username = 'root'; 
 $password = 'infosys'; 
 $database = 'project'; 
 mysql_connect($server,$username,$password) or die(mysql_error()); 
 mysql_select_db($database) or die(mysql_error());

$dropdownlist1 = $_POST['dropdownlist'];
$dropdownlist2 = $dropdownlist1.value; 
if(isset($_GET['id'])) {
 $mysql_query("DELETE FROM 'words' WHERE id = $dropdownlist2");
 header("location: index.php");
 exit();
}
?>

将选择框或下拉框移动到form标签内，

 <form method="post" action="remove.php">    
        <select name ='dropdownlist'>
        <?php while ($row = mysql_fetch_array($result)) { ?>
           <option value='<?php echo $row['words'];?>'><?php echo $row['words'];?></option>
         <?php } ?>
        </select>
    <input type="submit" value="Remove" /> 
 </form>

在php,

if(isset($_POST['dropdownlist'])) {
      $dropdownlist1 = $_POST['dropdownlist'];
  mysql_query("DELETE FROM `sentence` WHERE `words` = '$dropdownlist1' ");
  header("location: index.php");
  exit();
}

注意:使用mysqli_*或PDO函数代替mysql_*函数(已弃用)