-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathadmin_update.php
81 lines (65 loc) · 2.72 KB
/
admin_update.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
<?php
$con = mysql_connect("","schoolhunter_admin","admin123");
/* check connection */
if (!$con) {
die('Could not connect: ' .mysql_error());
}
$db_selected = mysql_select_db("schoolhunter_DataBase", $con);
if(!$db_selected){
die('Can\'t use schoolhunter_DataBase: ' .mysql_error());
}
$query = "SELECT * FROM University";
$result = mysql_query($query);
echo "<table style = 'width:100%'>";
echo "<tr>";
echo "<th>Rank</th>";
echo "<th>University</th>";
echo "<th>City</th>";
echo "<th>State</th>";
echo "<th>Total_Enroll</th>";
echo "<th>Tuition</th>";
echo "</tr>";
while($row = mysql_fetch_array($result)){
echo "</td><td>" . $row['rank'] . "</td><td>" . $row['uname'] . "</td><td>" . $row['city'] ."</td><td>" . $row['state'] . "</td><td>" . $row['population'] . "</td><td>" . $row['tuition'] . "</td></tr>";
}
echo "</table>";
?>
<html>
<head>
<title>Admin_Update Page</title>
<meta charset= 'utf-8'>
<title> Welcome to schoolHunter</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
<link href="user.css" rel="stylesheet">
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js" integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa" crossorigin="anonymous"></script>
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="main.php">School Hunter</a>
</div>
<div id="navbar" class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="main.php">Home</a></li>
<li class="active"><a href="/Admin.php">Admin</a></li>
</ul>
</div><!--/.nav-collapse -->
</nav>
<form action="admin_update_lol.php", method='POST'>
<?php $query = "SELECT * FROM University";?>
<?php $result = mysql_query($query);?>
<select name="uid" style="width:220pt;">
<?php while($row = mysql_fetch_array($result)):; ?>
<option value="<?php echo $row['uid'];?>"><?php echo $row['uname'];?></option>
<?php endwhile; ?>
</select>
<button type="submit"> update </button>
</form>
</body>
</html>