PHP Mysql - 删除按钮继续删除最新行 [英] PHP Mysql - Delete button keeps on deleting latest row

问题描述

当我遇到一个毛刺，我总是找到找到答案StackOverflow，但这一次，虽然我确定修复很容易，我只是不能似乎得到它的权利！

When i run into a glitch, I always find find the answer on StackOverflow, but this time, although I'm sure the fix is easy, I just can't seem to get it right !

基本上，我试图在从我的mysql数据库获取的每一行旁边添加一个删除按钮。如果需要，用户应该能够删除特定的帖子。

Basically, i'm trying to add a "delete" button next to each row fetched from my mysql database. The users should be able to delete a specific post, if needed.

当我点击删除按钮，它总是被删除的最新行。所以我想在每一行传递的值有错误：看起来他们被最新的一个覆盖。

When i hit the delete button, it's always the latest row that gets deleted. So i guess there's something wrong with the value passed in each row : seems like they're overridden by the latest one.

下面是我的代码：

<?php  
$table = query("SELECT post, postid FROM post_list WHERE id = ? ORDER BY 
time DESC LIMIT 15", $_SESSION["id"]);
foreach ($table as $row) 
{ 
      $post = $row["post"];
      $postid = $row["postid"];  
      echo ("<table>");
      echo ("<tr>");
      echo("<td>" . $post . "</td>");
      echo("</td>")?>            
      <div id="posteraser">
       <form action='' method='post'>
          <input type='hidden' name='postid' value='<?php echo $postid?>'>
          <input type='submit' name='posteraser'>Delete</input>
       </form>
      </div>       
     <?php 
     echo ("</td>");
     echo ("</tr>");
     echo ("</table>");
     echo '<hr>';
}  
?>

在同一页面上有删除按钮代码：

And below on the same page, there's the delete button code:

<?php
if(isset($_POST['posteraser']))
{
    $sql = query("DELETE FROM post_list WHERE postid = '$postid' ");       
    redirect ('home.php');
}
?>

任何帮助/提示将非常感谢！
非常感谢！

Any help/tips will be much appreciated ! Thanks a lot !

推荐答案

您必须在这里传递 $ _ POST ['postid ']

if(isset($_POST['posteraser'])){
   $postid = $_POST['postid'];
   $sql = query("DELETE FROM post_list WHERE postid = '$postid' ");       
   redirect ('home.php');
}

或 b
$ b

OR as procedure way

$sql = query("DELETE FROM post_list WHERE postid = ? ",$postid);  

这篇关于PHP Mysql - 删除按钮继续删除最新行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！