class-ified/classviewpeople.php at main · sreecharan-m/class-ified · 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
130
131
132
133
134
135
136
<?php

session_start();
$usr= $_SESSION['username'];
$conn=mysqli_connect('localhost','shaun','test1234','dproject');

if(isset($_GET['id']))
{

	$id=$_GET['id'];
	$sql="SELECT * FROM class WHERE id='$id'";
	$result = mysqli_query($conn, $sql); //result set of rows
    $data= mysqli_fetch_all($result, MYSQLI_ASSOC);

    $sqla="SELECT username FROM attendee_classes WHERE class_id='$id'";
    $resulta = mysqli_query($conn, $sqla); //result set of rows
    $dataa= mysqli_fetch_all($resulta, MYSQLI_ASSOC);
}


?>

<!DOCTYPE html>
<html>
<head>
	<title>Class Away From Class</title>

<style type="text/css">

   #ins {

   	margin-top: 5vh;
   	font: 25px Open Sans;
    font-weight: 900;
    margin-left: 10vw;
   }

   #atds {

   	margin-top: 3vh;
   	font: 20px Open Sans;
   	margin-left: 10vw;

   }

   #names {

   	margin-top: 10px;
   	margin-left: 10vw;
   }

   hr {

   	border: 0;
   	clear: both;
   	display: block;
   	width: 90%;
   	height: 3px;
    background-color: #000;
    margin-top: 5vh;
    margin-right: 0px;
   }

   a {

     text-decoration: none;
     color: #000;
   }

</style>

</head>

<?php include('classviewtop.php'); ?>


<div id="ins">

   Instructor :

  <?php echo $data[0]['instructor_name'];?>

</div>

<hr>

<?php if($data[0]['meeting_id'] != ''){ ?>

<div id="ins" style="font-size: 18px;">

   Members of this class can join online meet directly using this link. This link is unique of a particular class, so use the same link to start a meet Whenever needed.
  <br>
  <br>
  <a href="http://localhost:3000/<?php echo $data[0]['meeting_id'];?>" target='_blank'>Click Here</a>

</div>

<hr>

<?php } ?>


<div id="atds">

   <p style="font-weight: 900; font-size: 22px;">Attendees:</p>

   <?php foreach($dataa as $key) { ?>


    <?php

    $xy= $key['username'];

    $sqlb= "SELECT name,id FROM users WHERE username='$xy'";
    $resultb = mysqli_query($conn, $sqlb); //result set of rows
    $datab= mysqli_fetch_all($resultb, MYSQLI_ASSOC);

    ?>

    <div id="names">

       <a href="chat/individualchat.php?id=<?php echo $datab[0]['id'] ?>"><?php echo $datab[0]['name']; ?><a>

    </div>


   <?php } ?>

</div>


</div>

<body>

</html>