我在每一行上都有批准按钮，单击它后，它应更新数据库中该特定行的批准状态

Question

我是displaying一张桌子，桌子的每一行都有approve和拒绝button，单击批准后的状态应该为reflect to database as approved。我尝试过，但是单击任何行的批准按钮后，它将被设置status为所有行的批准状态。我的PHP代码是：$doc_re = "select * from files where receiver='$user'";$record = mysqli_query($conn,$doc_re);if($record){    echo " <br><center><span class='badge badge-light' style='font-size:30px; background-color:teal;color:white;padding:10px;'>RECEIVED RECORDS</span></center>";    echo "<br><table class='table' border='3' style='background-color:rgba(2,2,2,0.7);'>";    echo "<thead class='thead-dark' >";    echo "<tr style='font-size:23px;'><th style='color:skyblue;'><center>TO</center></th>          <th style='color:skyblue;'><center>FROM</center></th>          <th style='color:skyblue;'><center>FILE</center></th>          <th style='color:skyblue;'><center>MESSAGE</center></th>          <th style='color:skyblue;'><center>APPROVE</center></th>          <th style='color:skyblue;'><center>REJECT</center></th>          <th style='color:skyblue;'><center>STATUS</center></th></tr></thead>";    while($r = mysqli_fetch_array($record,MYSQLI_ASSOC))    {        echo "<tr><td style='color:white; font-size:18px;'><center><strong>{$r['receiver']}</strong></center></td>            <td style='color:white; font-size:18px;'><center><strong>{$r['sender']}</strong></center></td>            <td style='color:white; font-size:18px;'><center><strong><a href='".$r['file']."'>{$r['file']}</a></strong></center></td>            <td style='color:white; font-size:18px;'><center><strong>{$r['message']}</strong></center></td>            <form method='POST'>            <td><center>将所有行的状态设置为已批准

Answer 1

我认为您的查询有问题。它没有针对数据库表文件中的正确值。应该是这样的：

if(isset($_POST['approve'])) 

  $q = "update files set Status='APPROVED' where receiver='{$r['receiver']}' and sender='{$r['sender']}' and file='{$r['file']}'";

elseif(isset($_POST['reject']))

  $q = "update files set Status='REJECTED' where receiver='{$r['receiver']}' and sender='{$r['sender']}' and file='{$r['file']}'";

$res = mysqli_query($conn,$q);