-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathusers_page.php
executable file
·204 lines (188 loc) · 7.35 KB
/
users_page.php
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
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
<?php
session_start();
if(!$_SESSION['logged']){
//header("Location: login_page.php");
echo 'logged out '.$_SESSION['username'];
exit;
}
?>
<!DOCTYPE html>
<html>
<meta name="viewport" content="width=device-width, initial-scale=1">
<link rel="stylesheet" href="http://www.w3schools.com/lib/w3.css">
<head>
<title>Database Project 1</title>
</head>
<body style="margin:2%" class="w3-large">
<div class="w3-card-4">
<div class="w3-container w3-orange">
<h2>Professor Search Engine</h2>
</div>
<!--First search box: basic search, natral join of basic and academic-->
<div class="w3-card-4" style="margin:1%">
<div class="w3-container w3-green">
<h3>Basic Information</h3>
</div>
<form action="users_page.php" method="get" class="w3-row-padding">
<div class="w3-third">
<label class="w3-label">Faculty Name</label>
<input class="w3-input w3-border" type="text" name="name">
</div>
<div class="w3-third">
<label class="w3-label">Department</label>
<select class="w3-select w3-border" type="text" name="dept">
<option value="" disabled selected>Choose the department</option>
<option value="Electrical">Electrical and Computer Engineering</option>
<option value="Computer">Computer Science and Engineering</option>
<option value="Material">Material Science and Engineering</option>
<option value="Aerospace">Aerospace Engineering</option>
<option value="Biomedical">Biomedical Engineering</option>
<option value="Chemial">Chemial Engineering</option>
<option value="Civil">Civil Engineering</option>
<option value="Engineering Technology and Industrial">Engineering Technology and Industrial</option>
<option value="Industrial">Industrial and Systems Engineering</option>
<option value="Nuclear">Nuclear Engineering</option>
<option value="Ocean">Ocean Engineering</option>
<option value="Petroleum">Petroleum Engineering</option>
</select>
</div>
<div class="w3-third">
<label class="w3-label">Title</label>
<input class="w3-input w3-border" type="text" name="title">
</div>
<div class="w3-panel w3-padding-1"></div>
<div align="right">
<input class="w3-btn w3-lime" type="button" name="insert" value="Add New Professor" onClick="Javascript:window.location.href = 'insert.php';"/>
<input class="w3-btn w3-green" type="submit" name="basic_search" value="Basic Search">
</div>
<div style="padding:5px"></div>
</form>
</div>
<!--Second search box: publication search, natral join of basic and publication-->
<div class="w3-card-4" style="margin:1%">
<div class="w3-container w3-teal">
<h3>Publications</h3>
</div>
<form action="users_page.php" method="get" class="w3-row-padding">
<div class="w3-third">
<label class="w3-label">Author Name</label>
<input class="w3-input w3-border" type="text" name="name">
</div>
<div class="w3-third">
<label class="w3-label">Department</label>
<select class="w3-select w3-border" type="text" name="dept">
<option value="" disabled selected>Choose the department</option>
<option value="Electrical">Electrical and Computer Engineering</option>
<option value="Computer">Computer Science and Engineering</option>
<option value="Material">Material Science and Engineering</option>
<option value="Aerospace">Aerospace Engineering</option>
<option value="Biomedical">Biomedical Engineering</option>
<option value="Chemial">Chemial Engineering</option>
<option value="Civil">Civil Engineering</option>
<option value="Engineering Technology and Industrial">Engineering Technology and Industrial</option>
<option value="Industrial">Industrial and Systems Engineering</option>
<option value="Nuclear">Nuclear Engineering</option>
<option value="Ocean">Ocean Engineering</option>
<option value="Petroleum">Petroleum Engineering</option>
</select>
</div>
<div class="w3-third">
<label class="w3-label">Publication Title</label>
<input class="w3-input w3-border" type="text" name="ptitle">
</div>
<div class="w3-panel w3-padding-1"></div>
<div align="right">
<input class="w3-btn w3-teal" type="submit" name="pub_search" value="Publication Search">
</div>
<div style="padding:5px"></div>
</div>
</form>
<!--Third search box: Area search, natral join of basic and research-->
<div class="w3-card-4" style="margin:1%">
<div class="w3-container w3-indigo">
<h3>Research Area</h3>
</div>
<form action="users_page.php" method="get" class="w3-row-padding">
<div class="w3-third">
<label class="w3-label">Faculty Name</label>
<input class="w3-input w3-border" type="text" name="name">
</div>
<div class="w3-third">
<label class="w3-label">Department</label>
<select class="w3-select w3-border" type="text" name="dept">
<option value="" disabled selected>Choose the department</option>
<option value="Electrical">Electrical and Computer Engineering</option>
<option value="Computer">Computer Science and Engineering</option>
<option value="Material">Material Science and Engineering</option>
<option value="Aerospace">Aerospace Engineering</option>
<option value="Biomedical">Biomedical Engineering</option>
<option value="Chemial">Chemial Engineering</option>
<option value="Civil">Civil Engineering</option>
<option value="Engineering Technology and Industrial">Engineering Technology and Industrial</option>
<option value="Industrial">Industrial and Systems Engineering</option>
<option value="Nuclear">Nuclear Engineering</option>
<option value="Ocean">Ocean Engineering</option>
<option value="Petroleum">Petroleum Engineering</option>
</select>
</div>
<div class="w3-third">
<label class="w3-label">Research Area</label>
<input class="w3-input w3-border" type="text" name="area">
</div>
<div class="w3-panel w3-padding-1"></div>
<div align="right">
<input class="w3-btn w3-indigo" type="submit" name="area_search" value="Research Area Search">
</div>
<div style="padding:5px"></div>
</div>
</form>
<div class="w3-panel w3-padding-8"></div>
</div>
<!--End of search box-->
<div class="w3-panel w3-padding-16"></div>
<div class="w3-card-4">
<div class="w3-container w3-blue">
<h2>Search Results</h2>
</div>
<?php
//check if the starting row variable was passed in the URL or not
if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
//we give the value of the starting row to 0 because nothing was found in URL
$startrow = 0;
// if new search, reset the session infomation
$_SESSION['table_type']="";
//otherwise we take the value from the URL
} else {
$startrow = (int)$_GET['startrow'];
}
// basic information search result
if (isset($_GET['basic_search']) or $_SESSION['table_type'] == "basic"){
include 'basic_table.php';
}
// publication information search result
if (isset($_GET['pub_search']) or $_SESSION['table_type'] == "publication"){
include 'pub_table.php';
}
// research area information search result
if (isset($_GET['area_search']) or $_SESSION['table_type'] == "research"){
include 'area_table.php';
}
// add page number
echo '<form action="users_page.php" method="get">';
echo '<div align="right">';
$prev = $startrow - 5;
//only print a "Previous" link if a "Next" was clicked
if ($prev >= 0)
echo '<a class="w3-btn w3-blue" href="'.$_SERVER['PHP_SELF'].'?startrow='.$prev.'">Previous</a>';
else
echo '<a class="w3-btn w3-disabled">Previous</a>';
if ($nrows == 5)
echo '<a class="w3-btn w3-blue" href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+5).'">Next</a>';
else
echo '<a class="w3-btn w3-disabled">Next</a>';
echo '</form>';
echo '</div>';
?>
</div>
</body>
</html>