Student-Management-System-Mini-Project/marks.php at master · roy-a2yush/Student-Management-System-Mini-Project · 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

<?php

	session_start();
	$ID = $_SESSION['ID'];
	$_SESSION['ID']=$ID;
	$class = $_SESSION['class'];

	$host="localhost";
	$user="root";
	$password="";
	$db="Hogwarts";

	$con=mysqli_connect("localhost","root","");
	mysqli_select_db($con,$db);


	$ID = $_SESSION['ID'];
	$sql="SELECT `Sid`, `History`, `Transfiguration`, `DADA`, `Potions`, `Percentage` FROM `Marks` WHERE class = $class";
	$result = mysqli_query($con,$sql);
 ?>

<!DOCTYPE html>
<html>
<head>
	<title>Enter marks</title>
	<link rel="stylesheet" type="text/css" href="login.css">
</head>
<body>
	<div class="Menu">
		<ul>
	 		<li><a class="active" href="teacherAccount.php">Home</a></li>
		</ul>
	</div>
	<div class="loginbox">
		<img src="p2.png" class="avatar">
		<p style="padding-left: 210px; font-weight: bold; font-size: 7;"><h1>Staff details</h1></p>
		<table align="center">
			<tr>
				<th>Sid</th>
				<th>History</th>
				<th>Transfiguration</th>
				<th>DADA</th>
				<th>Potions</th>
				<th>Percentage</th>
			</tr>
			<?php while($row1 = mysqli_fetch_array($result)):; ?>
				<tr>
					<td><?php echo$row1[0]; ?></td>
					<td><?php echo$row1[1]; ?></td>
					<td><?php echo$row1[2]; ?></td>
					<td><?php echo$row1[3]; ?></td>
					<td><?php echo$row1[4]; ?></td>
					<td><?php echo$row1[5]; ?></td>
				</tr>
			<?php endwhile; ?>
		</table>
	</div>
	<a href="login.php">
  		<img src="p3.png" alt="Logout" style="width:50px;height:42px;border:0;position: fixed;top: 8px;right: 16px;font-size: 18px;">
	</a>
</body>
</html>