-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathadmin_college.php
executable file
·122 lines (96 loc) · 3.7 KB
/
admin_college.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
<?php
require_once('authorize.php') ;
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title>Gravitas - Admin College</title>
<link rel="stylesheet" type="text/css" href="style.css" />
</head>
<body>
<div id="allcontent">
<img src="images/gravitas.png" alt="Gravitas 2010 Logo" id="logo" />
<h3 id="page_title">Gravitas - Admin College</h3>
<?php
require_once('appvars.php');
$code = '' ;
$col_name = '' ;
?>
<form method="post" id="reg_form" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<fieldset>
<legend>Select College</legend>
<ol>
<li>
<label for="code">College Name</label>
<select name="code">
<option value=""></option>
<?php
$query = "SELECT name, code FROM college";
$data = mysqli_query($dbc, $query);
while ($row = mysqli_fetch_array($data))
{
echo '<option value="' . $row['code'] . '">' . $row['name'] . '</option>';
}
?>
</select>
</li>
</ol>
</fieldset>
<fieldset>
<input type="submit" name="submit" value="Get Details" />
</fieldset>
</form>
<?php
if (isset($_POST['submit'])) {
$code = $_POST['code'] ;
$query = "Select name from college where code = '$code'" ;
$result = mysqli_query($dbc, $query) ;
$row = mysqli_fetch_array($result) ;
$col_name = $row['name'] ;
$query = "Select count(t_id) AS count from team where code = '$code'" ;
$result = mysqli_query($dbc, $query) ;
$row = mysqli_fetch_array($result) ;
$total_t = $row['count'] ;
$query = "Select sum(p_male) AS sum from team where code = '$code'" ;
$result = mysqli_query($dbc, $query) ;
$row = mysqli_fetch_array($result) ;
$total_mp = $row['sum'] ;
$query = "Select sum(p_female) AS sum from team where code = '$code'" ;
$result = mysqli_query($dbc, $query) ;
$row = mysqli_fetch_array($result) ;
$total_fmp = $row['sum'] ;
$total_p = $total_mp + $total_fmp ;
echo '<h3>Name : ' . $col_name . '</h3>' ;
echo 'Code : ' . $code . '<br />' ;
echo 'Number of Contingents : ' . $total_t . '<br />' ;
echo 'Number of participants : ' . $total_p . '<br />' ;
echo 'Number of male participants : ' . $total_mp . '<br />' ;
echo 'Number of female participants : ' . $total_fmp . '</h4>' ;
echo '<p><table id="box-table-a"><thead> <tr><th>Event Name </th> <th>Teams</th><th>Participants</th> </tr></thead>' ;
echo '<tbody>' ;
for($i = 1; $i <= $max_events; $i++ )
{
/*$query = "Select e_num from events where subtype = 'appliedengg'" ;
$result = mysqli_query($dbc, $query) or die('Error fetching Applied Engg event numbers!!');
*/
$e_num = $i ;
$query1 = "Select e.e_name AS name, sum(r.num_teams) AS sumt, sum(r.num_par) AS sump from events e, reg r where e.e_num = r.e_num AND e.e_num = '$e_num' AND r.code = '$code'" ;
$result1 = mysqli_query($dbc, $query1) or die('Error fetching Applied Engg events!!');
$row1 = mysqli_fetch_array($result1);
$e_name = $row1['name'] ;
$sumt = $row1['sumt'] ;
$sump = $row1['sump'] ;
if (($sumt != '') || ($sump != ''))
echo '<tr><td>' . $e_name . '</td><td>' . $sumt . '</td><td>' . $sump . '</td></tr>' ;
}
echo '</tbody></table></p>' ;
}
echo '<p><a href="admin.php" class="links">Go to Admin Page</a></p>' ;
echo '<p><a href="index.php" class="links">Go to Registrations Page</a></p>' ;
require_once('footer.php') ;
?>
</div>
</body>
</html>