-
Notifications
You must be signed in to change notification settings - Fork 0
/
display_team.php
122 lines (100 loc) · 2.89 KB
/
display_team.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
<?php
// Purpose : Display team of a candidate for an event
// Input :Tathva ID , Event ID as get
?>
<?php require_once('connectDatabase.php');
function string_prepare($string){
global $mysql_conn;
return trim(mysqli_real_escape_string($mysql_conn,$string));
}?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>
<body>
<?php
//$TathvaID="TID10001";
//$EventID="CS003";
$TathvaID=$_GET['TathvaID'];
$EventID=$_GET['EventID'];
$query ="Select * from Registration ";
$query.="WHERE ";
$query.="TathvaID ='$TathvaID' AND ";
$query.="EventCode ='$EventID'";
//echo $query."<br>";
$query_run = mysqli_query($mysql_conn,$query);
if(mysqli_num_rows($query_run)<0){die("Not Found");}
$row=mysqli_fetch_assoc($query_run);
$CaptainID=$row["CaptainID"];
//echo $CaptainID."<br>";
$query ="Select ";
$query.="Participants.TathvaID as TathvaID ,";
$query.="Participants.Name as Name ,";
$query.="Participants.PhoneNumber as PhoneNumber ,";
$query.="Participants.College as College ,";
$query.="Registration.Participating as Participating ,";
$query.="Events.EventName as EventName ";
$query.="from Registration,Participants,Events ";
$query.="WHERE ";
$query.="Participants.TathvaID=Registration.TathvaID and ";
$query.="Registration.CaptainID='$CaptainID' and ";
$query.="Registration.EventCode='$EventID' and ";
$query.="Events.EventCode='$EventID'";
//echo $query."<br>";
$query_run = mysqli_query($mysql_conn,$query);
$query1_row=mysqli_fetch_assoc($query_run);
?>
<h1>Team of <?php echo $TathvaID; ?> for <?php echo $query1_row['EventName'];?></h1>
<?php
$query_run = mysqli_query($mysql_conn,$query);
if(mysqli_num_rows($query_run)<0){die($query);}
?>
<table>
<tr class="title">
<td>TathvaID</td>
<td>Name</td>
<td>Contact</td>
<td>College</td>
<td>Event Confirmation</td>
</tr>
<?php
while($row=mysqli_fetch_assoc($query_run)){
?>
<tr <?php if($row['TathvaID']==$CaptainID){echo "class=\"captain\"";} ?>>
<td><?php echo $row['TathvaID']; ?></td>
<td><?php echo $row['Name']; ?></td>
<td><?php echo $row['PhoneNumber']; ?></td>
<td><?php echo $row['College']; ?></td>
<td><?php if($row['Participating']){echo "Confirmed";}else{echo 'Not confirmed';} ?></td>
</tr>
<?php }?>
</table>
<?
?>
<style>
body{
background:#f4f4f4;
}
table{
width:100%;
border:2px solid #ccc;
}
tr{ height:40px;
}
td{ border:1px solid #ccc;
font-size:18px;
}
.title td{
font-size:30px;
color:#333;
font-weight:bold;
color:#F30;
}
.captain{
color:#F00;
}
</style>
</body>
</html>