ltc.github.io/borrowuser.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
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129

<!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/borrowuser.css"/>
</head>
<body>
<div id="borrowuser_frame">
	<form  action="" method="post" name="form1">
        <h3>借书信息页面</h3>
				<p>
				<input class="text_field" type="text" name="xm" placeholder="输入想要查找的会员名字" >
				</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="返回管理页面"/>

	</form>
</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";
	$selectUs= "select * from Borrow";
	$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"])){
	$xm=$_POST['xm'];
	$flag=0;
	$result = @mysql_query($selectSQ);
	while($row=mysql_fetch_array($result)){
		if($xm==$row['user_name']){
			echo "<table  id='bg' border=1 width='1000px;'>";
			echo "<td background-color:#00FFFF>"; echo "姓名"; echo "</td>";
			echo "<td background-color:#00FFFF>"; echo "未还的书籍"; echo "</td>";
			echo "<td background-color:#00FFFF>"; echo "借书时间"; echo "</td>";
			echo "</tr>";
			echo "<td>".$row['user_name']."</td>";
			echo "<td>";
			$resultUs= @mysql_query($selectUs);
			while($row1=mysql_fetch_array($resultUs)){
				if($xm==$row1['Bor_user'])
				{
					echo $row1['Bor_book'];
					echo "<br>";
				}
			}
			echo "</td>";
			echo "<td>";
			$resultUs= @mysql_query($selectUs);
			while($row1=mysql_fetch_array($resultUs)){
				if($xm==$row1['Bor_user'])
				{
					echo $row1['Bor_time'];
					echo "<br>";
				}
			}
			echo "</td>";
			echo "</tr>";
			$flag=1;
			break;
		}
		if($flag==1)
		break;
	}
	if($flag==0){
		echo "<script>alert('没有该会员！'); </script>";
	}
}
else{
	echo "<table  id='bg' border=1 width='500px;'>";
	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='borrowuser.php?curren=".(1)."'>首页</a>"."</td>";
	if($curren==1)
		echo "<td>"."<a href='borrowuser.php?curren=".($curren=1)."'>上一页</a>"."</td>";
	else
		echo "<td>"."<a href='borrowuser.php?curren=".($curren-1)."'>上一页</a>"."</td>";
	if($curren==ceil($sum/$size))
		echo "<td>"."<a href='borrowuser.php?curren=".(ceil($sum/$size))."'>下一页</a>"."</td>";
	else
		echo "<td>"."<a href='borrowuser.php?curren=".($curren+1)."'>下一页</a>"."</td>";
	echo "<td>"."<a href='borrowuser.php?curren=".(ceil($sum/$size))."'>尾页</a>"."</td>";
	echo "</tr>";
}
if(isset($_POST["fh"])){
		header("location:../borrowuser.php");
}
if(isset($_POST["fhgl"])){
		header("location:../guanli.php");
}

?>