ltc.github.io/deleteuser.php at master · Iitianci/ltc.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<title>删除会员页面</title>
	<link rel="stylesheet" type="text/css" href="./css/bg.css"/>
	<link rel="stylesheet" type="text/css" href="./css/deleteuser.css"/>
</head>
<body>
<div id="deleteuser_frame">
	<form  action="" method="post" name="form1">
        <h3>删除会员页面</h3>
        		<p>
                <label class="label_input">姓名：</label>
                <input class="text_field" type="text" name="xm" />
				</p>
				<p><input class="button" type="submit" name="tj" value="删除"/></p>
		<input class="button" type="submit" name="fh" value="刷新"/>
		<input class="button" type="submit" name="fhgl" value="返回管理页面"/>

</body>
</html>
<?php
	$con=@mysql_connect('localhost','root',"root")or die("连接失败".mysql_error());
	mysql_query("set names utf8");
	mysql_query("set character set utf8");
	mysql_query("set character_set_set_results= utf8");
	$s=@mysql_select_db("BookLoanSystem") or die('选择数据库失败');
	$selectSQ= "select * from User";
	$selectBo= "select * from Borrow";
	if(isset($_POST["tj"])){
		$xm=$_POST['xm'];
	}
	$flag=0;
	$sum=0;
	$a=0;
	$b=0;
	$size=5;
	if(isset($_GET["curren"]))
		$curren=$_GET["curren"];
	else $curren=1;
	$result = @mysql_query($selectSQ);
	while($row=mysql_fetch_array($result)){
		$sum++;
	}
if(isset($_POST["tj"])){
	$result = @mysql_query($selectSQ);
	while($row=mysql_fetch_array($result)){
		if($xm==$row['user_name']){
			$deleted="delete from User where user_id={$row['user_id']}";
			$flag=1;
			break;
		}
		if($flag==1)
		break;
	}
	$resultBo = @mysql_query($selectBo);
	while($row1=mysql_fetch_array($resultBo)){
		if($xm==$row1['Bor_user']){
			$deleted1="delete from Borrow where Bor_id={$row1['Bor_id']}";
			$dele1=@mysql_query($deleted1);
		}
	}
	$dele=@mysql_query($deleted);
	//$dele1=@mysql_query($deleted1);
	if($dele)
		echo "<script>alert('成功删除！'); </script>";
	else
		echo "<script>alert('没有此人，删除失败！'); </script>";
}
else{
	echo "<table id='bg' border=1 width='400px;'>";
	echo "<td>"; echo "姓名"; echo "</td>";
	echo "<td>"; echo "性别"; echo "</td>";
	echo "</tr>";
	$result = @mysql_query($selectSQ);
	while($row=mysql_fetch_array($result)){
		$a++;
		while($a>$size*($curren-1)){
			$b++;
			echo "<td>".$row['user_name']."</td>";
			echo "<td>".$row['user_sex']."</td>";
			echo "</tr>";
			break;
		}
		if($b>=$size)
		break;
	}
	echo "<table id='bg' border=1 width='400px;'>";
	echo "<td>"."当前是第".($curren)."页"."</td>";
	echo "<td>"."一共有".(ceil($sum/$size))."页"."</td>";
	echo "<td>"."<a href='deleteuser.php?curren=".(1)."'>首页</a>"."</td>";
	if($curren==1)
		echo "<td>"."<a href='deleteuser.php?curren=".($curren=1)."'>上一页</a>"."</td>";
	else
		echo "<td>"."<a href='deleteuser.php?curren=".($curren-1)."'>上一页</a>"."</td>";
	if($curren==ceil($sum/$size))
		echo "<td>"."<a href='deleteuser.php?curren=".(ceil($sum/$size))."'>下一页</a>"."</td>";
	else
		echo "<td>"."<a href='deleteuser.php?curren=".($curren+1)."'>下一页</a>"."</td>";
	echo "<td>"."<a href='deleteuser.php?curren=".(ceil($sum/$size))."'>尾页</a>"."</td>";
	echo "</tr>";
}
if(isset($_POST["fh"])){
		header("location:../deleteuser.php");
}
if(isset($_POST["fhgl"])){
		header("location:../guanli.php");
}
?>