html—如何在php、mysql中使用模式窗口删除while循环中打印的行

xeufq47z 于 2021-06-20 发布在 Mysql

关注(0)|答案(1)|浏览(256)

我对php非常在行，但我真的被困在这里想办法删除while循环中打印的行：

<?php 
    $sql5 = "SELECT * FROM user_exp WHERE id=".$_SESSION["ID"]."";
    $result3 = mysqli_query($conn, $sql5);
    if (mysqli_num_rows($result3) > 0) {
          // output data of each row
        while($row = mysqli_fetch_assoc($result3)) {
            echo "<h4>" . $row["exp_title"]. "<a href='#' title=''><i class='fa fa-pencil'></i><i onclick='location.href='userprofile.php?deleteID=".$row["auto_id"]."';' class='fa fa-minus-square' data-toggle='modal' data-target='#EXPDELModal' value='delete_exp'></i></a></h4>";
            echo "<p>" . $row["exp_detail"]. "</p>";   
        } 
    }
    else
    {
        echo "<div class='textfaded2'>Add you experience here.</div>";
    }
?>

注意：我想用一个很棒的字体图标来删除行，我用'auto\u id'作为自动增量，主键定义我要删除的行。
以下是模式代码：

<div class="modal fade" id="EXPDELModal" role="dialog">
    <div class="modal-dialog modal-sm">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Delete Experience</h4>
            </div>
            <div class="modal-body">
                <h3>Are you sure?</h3>
                <br>
                <br>
            </div>
            <div class="modal-footer">
                <form action="userprofile.php?deleteID=<?php '.$row["auto_id"].';?>" 
                    style="width: 100%;" method="post" value="delete_exp">
                    <button type="button" name="delete" class="btn btn-default" data- 
                    dismiss="modal">YES</button>
                    <button type="button" class="btn btn-default" data- 
                    dismiss="modal">NO</button>
                </form>
            </div>
        </div>
    </div>
</div>

最后是delete查询：

<?php
    if(isset($_POST['delete']))
    {
        $sql6="DELETE FROM `user_exp` WHERE auto_id=".$_GET['deleteID']."";
        $result=mysqli_query($conn,$sql6) or die();
    } 
?>

我要感谢你花时间阅读这篇文章。

mysql php Html

来源：https://stackoverflow.com/questions/51998990/how-to-delete-a-row-printed-in-a-while-loop-using-a-modal-window-in-php-mysql

1条答案

按热度按时间

46scxncf1#

<?php
$sql5 = "SELECT * FROM user_exp WHERE id=" . $_SESSION["ID"] . "";
$result3 = mysqli_query($conn, $sql5);
if (mysqli_num_rows($result3) > 0) {
while ($row = mysqli_fetch_assoc($result3)) {
    ?>
    <h4><?php echo $row["exp_title"]; ?>
        <a href='#' title=''>
            <i class='fa fa-pencil'></i>
            <i onclick='setValue("<?php $row["auto_id"]; ?>");' class='fa fa-minus-square' data-toggle='modal'
               data-target='#EXPDELModal'></i>
        </a>
    </h4>
    <p><?php echo $row["exp_detail"]; ?></p>;
    <?php
}
} else {
    echo "<div class='textfaded2'>Add you experience here.</div>";
}
if (isset($_POST['delete'])) {
    if($_POST['deleteID']) {
        $sql6 = "DELETE FROM `user_exp` WHERE auto_id=" . $_POST['deleteID'] . "";
        $result = mysqli_query($conn, $sql6) or die();
    }
}
?>
<script>
    function setValue(value) {
        document.getElementById("deleteId").value = value;
    }
</script>
<div class="modal fade" id="EXPDELModal" role="dialog">
    <div class="modal-dialog modal-sm">
        <div class="modal-content">
            <div class="modal-header">
                <button type="button" class="close" data-dismiss="modal">&times;</button>
                <h4 class="modal-title">Delete Experience</h4>
            </div>
            <div class="modal-body">
                <h3>Are you sure?</h3>
                <br>
                <br>
            </div>
            <div class="modal-footer">
                <form action="userprofile.php" style="width: 100%;" method="post" name="delete_exp">
                    <input type="hidden" value="0" name="deleteID" id="deleteId" readonly/>
                    <button type="submit" name="delete" class="btn btn-default" data-dismiss="modal">YES</button>
                    <button type="button" class="btn btn-default" data-dismiss="modal">NO</button>
                </form>
            </div>
        </div>
    </div>
</div>

赞(0）回复(0）举报 2021-06-20

我来回答

html—如何在php、mysql中使用模式窗口删除while循环中打印的行

1条答案

相关问题

热门标签

最新问答