Online-Quiz-Test-Management-System/student_remove.php at master · msaifulcsse/Online-Quiz-Test-Management-System · 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
<?php
session_start();
	if (!isset($_SESSION["admin"])) {
		header('Location: index.php');
		exit;
	}
	include "mysql_conn.php";


?>

<html>
<head>
	<title>Admin Panel || Online Quiz Test</title>
</head>
<body>
<center>
	<h1> Student Remove </h1>
	<hr/>
	<table border='1'>

		<?php

			$sql = "SELECT t2.* FROM `users` as t1 INNER JOIN `user_info` as t2 on t1.user_id = t2.user_id WHERE `role`= 'Student'";
			$result = mysql_query($sql);
			if ($result) {
				while($row = mysql_fetch_assoc($result)) {
					$uid=$row["user_id"];
					echo "<tr> <td>". $row["full_name"]."</td> <td>" . $row["edu"]. "</td> <td>". $row["email"]. "</td> <td>" . $row["phone"]."</td> <td>" . $row["address"]."</td> <td>" . $uid."</td> <td>".
						"</td><td><a href='student_remove.php?user_id_de=".$uid."'>Remove</a></td>".
						"</tr><br>";
				}
			}else {
				echo "Theacher not found..!!";
			}
		?>
	</table>
</center>
<hr/><br>
<a href="admin.php">Go To Your Dashboard</a>
<br>
<a href="logout.php">Logout</a>
</body>
</html>

<?php
	if(isset($_GET["user_id_de"]))
	{
		$uid = $_GET["user_id_de"];
		$sql2 = "DELETE FROM `user_info` WHERE user_id='$uid'";
			if(!mysql_query($sql2))
			{
				echo "Error in user_info: " . $sql . "<br>" . mysql_error($conn);
			}
			$sql3 = "DELETE FROM `users` WHERE user_id='$uid'";
			if(!mysql_query($sql3))
			{
				echo "Error in user_info: " . $sql . "<br>" . mysql_error($conn);
			}

			else
				echo $msg= 'Declined';

		header("Location: student_remove.php");
	}

	?>