duanaozhong0696 2019-05-15 14:43
浏览 94
已采纳

弹出确认删除PHP

So my code is below which read from dmgeqdelete.php that will instantly delete data from database. <td align="center"> <a href="dmgeqdelete.php?damagedID=<?php echo $row["damagedID"]; ?>" >Delete</a> </td>

Im trying to add a pop up confirmation for above code. i have tried <td align="center"> <a href="dmgeqdelete.php?damagedID=<?php echo $row["damagedID"]; ?>" onclick="return confirm('Are you sure?')">Delete</a> </td> end up with no action happen

dmgeqdelete.php

<?php
include('dbConfig.php');
$damagedID=$_REQUEST['damagedID'];
$query = "DELETE FROM damagedeq WHERE damagedID=$damagedID"; 
$result = mysqli_query($conn,$query) or die ( mysqli_error());
header("Location: dmgeqview.php"); 
?>

full code

<?php
include('dbConfig.php');
?>
<!DOCTYPE html>
<html>

<head>
  <meta charset="utf-8">
  <title>View Damaged Equipment Records</title>
  <link rel="stylesheet" href="css/style.css" />
</head>

<body>
  <div class="form">
    <p><a href="report.php">Home</a> | <a href="index.php">Logout</a></p>
    <h2>View Records</h2>
    <table width="100%" border="1" style="border-collapse:collapse;">
      <thead>
        <tr>
          <th><strong>No</strong></th>
          <th><strong>Damage ID's</strong></th>
          <th><strong>EQ ID's</strong></th>
          <th><strong>Student ID's</strong></th>
          <th><strong>Staff ID's</strong></th>
          <th><strong>Date reported</strong></th>
          <th><strong>Date repaired</strong></th>
          <th><strong>Equipment Status</strong></th>
        </tr>
      </thead>
      <tbody>
        <?php
$count=1;
$sel_query="Select * from damagedeq ORDER BY damagedID desc;";
$result = mysqli_query($conn,$sel_query);
while($row = mysqli_fetch_assoc($result)) { ?>
          <tr>
            <td align="center">
              <?php echo $count; ?>
            </td>
            <td align="center">
              <?php echo $row["damagedID"]; ?>
            </td>
            <td align="center">
              <?php echo $row["equipmentID"]; ?>
            </td>
            <td align="center">
              <?php echo $row["studentID"]; ?>
            </td>
            <td align="center">
              <?php echo $row["staffID"]; ?>
            </td>
            <td align="center">
              <?php echo $row["dateReported"]; ?>
            </td>
            <td align="center">
              <?php echo $row["dateRepaired"]; ?>
            </td>
            <td align="center">
              <?php echo $row["equipmentStatus"]; ?>
            </td>
            <td align="center">
              <a href="dmgequp.php?damagedID=<?php echo $row[" damagedID "]; ?>">Edit</a>
            </td>
            <td align="center">
              <a href="dmgeqdelete.php?damagedID=<?php echo $row[" damagedID "]; ?>">Delete</a>
            </td>
          </tr>
          <?php $count++; } ?>
      </tbody>
    </table>
  </div>
</body>

</html>

</div>
  • 写回答

1条回答 默认 最新

  • doulangdang9986 2019-05-15 14:55
    关注

    Here you just need to stop the further execution of the code

    onclick="return confirm('Are you sure?')"

    adding the return false at the end like this

    onclick="return confirm('Are you sure?'); return false;"

    When clicking on cancel nothing will happen, but if click on ok it will go to link
    Here is a full code snippet

    <!DOCTYPE html>
<html>

<head>
  <meta charset="utf-8">
  <title>View Damaged Equipment Records</title>
  <link rel="stylesheet" href="css/style.css" />
</head>

<body>
  <div class="form">
    <p><a href="report.php">Home</a> | <a href="index.php">Logout</a></p>
    <h2>View Records</h2>
    <table width="100%" border="1" style="border-collapse:collapse;">
      <thead>
        <tr>
          <th><strong>No</strong></th>
          <th><strong>Damage ID's</strong></th>
          <th><strong>EQ ID's</strong></th>
          <th><strong>Student ID's</strong></th>
          <th><strong>Staff ID's</strong></th>
          <th><strong>Date reported</strong></th>
          <th><strong>Date repaired</strong></th>
          <th><strong>Equipment Status</strong></th>
        </tr>
      </thead>
      <tbody>
        <tr>
          <td align="center">000</td>
          <td align="center">111</td>
          <td align="center">222</td>
          <td align="center">333</td>
          <td align="center">444</td>
          <td align="center">555</td>
          <td align="center">666</td>
          <td align="center">777</td>
          <td align="center">
            <a href="dmgequp.php?damagedID=aaa">Edit</a>
          </td>
          <td align="center">
            <a href="dmgeqdelete.php?damagedID=bbb" onclick="return confirm('Are you sure?'); return false;">Delete</a>
          </td>
        </tr>
      </tbody>
    </table>
  </div>
</body>

</html>

    </div>
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题？

悬赏问题

  • ¥15 如何在scanpy上做差异基因和通路富集？
  • ¥20 关于#硬件工程#的问题，请各位专家解答！
  • ¥15 关于#matlab#的问题：期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707，使系统具有较小的超调量
  • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
  • ¥30 截图中的mathematics程序转换成matlab
  • ¥15 动力学代码报错，维度不匹配
  • ¥15 Power query添加列问题
  • ¥50 Kubernetes&Fission&Eleasticsearch
  • ¥15 報錯：Person is not mapped，如何解決？
  • ¥15 c++头文件不能识别CDialog