php - 无法在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
以下是截图:
解决方案
推荐阅读
- go - PATCH API 不适用于 Google Cloud Run 实例
- c# - 为什么我的 .exe 文件在我安装程序时不起作用?
- c - 用 C 语言编写一个程序,从文件中读取最多 100 个整数,其中文件中的第一个值是文件中后续值的数量
- flutter - 如何在颤振中实现即将到来的日期倒计时
- dataframe - 无法在 DataFrames.jl 中执行列转换
- python - 使用 PIP 安装 jupyterlab
- sharepoint-online - SpFx + Ribbon function call
- perl - Perl optimization: inlining a function changed the results
- html - bootstrap4 row height needs to be smaller
- excel - 如何匹配索引vba