首页 > 解决方案 > 无法在php和mysql中删除用户

问题描述

我想删除一个用户,但是当我单击垃圾桶(删除)图标时。我有一个完全空白的页面,这是我面临的问题。我在这方面尝试了很多东西,但是我面临着同样的问题。我认为它不在数据库用户中,问题可能在代码中。这是我的php代码。

//dash.php
 <?php
     if(@$_GET['q']==1) {

        $result = mysqli_query($con,"SELECT * FROM user") or die('Error');
        echo  '<div class="panel"><div class="table-responsive"><table class="table table-striped title1">
        <tr><td><b>S.N.</b></td><td><b>Name</b></td><td><b>Gender</b></td><td><b>College</b></td><td><b>Course</b></td><td><b>Email</b></td><td><b>Mobile</b></td><td></td></tr>';
        $c=1;
        while($row = mysqli_fetch_array($result)) {
            $name = $row['name'];
            $mob = $row['mob'];
            $gender = $row['gender'];
            $email = $row['email'];
            $college = $row['college'];
          $course = $row['course'];

            echo '<tr><td>'.$c++.'</td><td>'.$name.'</td><td>'.$gender.'</td><td>'.$college.'
</td><td>'.$course.'</td><td>'.$email.'</td><td>'.$mob.'</td>
            <td><a title="Delete User" href="update.php?demail='.$email.'">
<b><span class="glyphicon glyphicon-trash" aria-hidden="true"></span></b></a></td></tr>';
        }
        $c=0;
        echo '</table></div></div>';

        }
        ?>


            //update.php
            <?php
            include_once 'dbConnection.php';
            session_start();
            $email=$_SESSION['email'];
            //delete feedback
            if(isset($_SESSION['key'])){
            if(@$_GET['fdid'] && $_SESSION['key']=='bondad7785068889') {
            $id=@$_GET['fdid'];
            $result = mysqli_query($con,"DELETE FROM feedback WHERE id='$id' ") or die('Error');
            header("location:dash.php?q=3");
            }
            }


            //delete user

            if(isset($_SESSION['key'])){
            if(@$_GET['demail'] && $_SESSION['key']=='bondad7785068889') {
            $demail=@$_GET['demail'];
            $r1 = mysqli_query($con,"DELETE FROM rank WHERE email='$demail' ") or die('Error');
            $r2 = mysqli_query($con,"DELETE FROM history WHERE email='$demail' ") or die('Error');
            $result = mysqli_query($con,"DELETE FROM user WHERE email='$demail' ") or die('Error');
            header("location:dash.php?q=1");
            }
            }
            ?>


             //dbConnection.php

以下是截图:

这是用户的截图

空白页(错误)

数据库表内部:用户

标签: phpmysqldatabasexampp

解决方案


推荐阅读