DBProject/editCourseMember.php at master · lypan/DBProject · 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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
<?php
include "link.php";

$courseID = '';
$courseName = '';
$profID = $_SESSION["idNumber"];
$query = "SELECT *
FROM course C, professor P
WHERE P.idNumber = C.profID
AND C.profID = '$profID'
";
$result = $mysqli->query($query);

echo '<table class="table table-striped">
		<tr>
		<td>CourseName</td>
		<td>TeacherName</td>
		<td>Classroom</td>
		<td>Capacity</td>
		<td>Credit</td>
		<td>Department</td>
		<td>Obligatory</td>
		<td>CourseYear</td>
		<td>CourseTime</td>
		<td>CourseID</td>
		</tr>';

		while ($row = $result->fetch_assoc()){
				echo "<tr>";
				echo "<td>" . $row['courseName'] . "</td>";
				echo "<td>" . $row['name'] . "</td>";
				echo "<td>" . $row['classroom'] . "</td>";
				echo "<td>" . $row['capacity'] . "</td>";
				echo "<td>" . $row['credit'] . "</td>";
				echo "<td>" . $row['department'] . "</td>";
				if($row['obligatory'])echo "<td>obligatory</td>";
				else echo "<td>not obligatory</td>";
				echo "<td>" . $row['courseYear'] . "</td>";
				echo "<td>" . $row['courseTime'] . "</td>";
				echo "<td>" . $row['courseID'] . "</td>";
				echo "</tr>";
		}

echo '</table>';


?>


<form method="post" action="courseEdit.php?webNo=5">
	<label>Select Course</label>
	<select name="courseID">
	<?php
		$query = "SELECT *
		FROM course C, professor P
		WHERE P.idNumber = C.profID
		AND C.profID = '$profID'
		";
		$result = $mysqli->query($query);
		while ($row = $result->fetch_assoc()){
			echo"<option>";
			echo $row['courseID']. '-' . $row['courseName'];
			echo"</option>";
		}
	?>
	</select>
	<span class="" id=""></span>
	<label>Remain/Delete Course</label>
	<select name="choose">
		<option name="add">Remain</option>
		<option name="delete">Delete</option>
	</select>
	<span class="" id=""></span>
	<div>
		<button class="btn btn-primary">Update Course</button>
	</div>
	<span class="help-block" id=""></span>
</form>


<?php
if(!empty($_POST['courseID']) && !empty($_POST['choose'])){

	$course = explode("-", $_POST['courseID']);
	$courseID	= $course[0];
	$courseName = $course[1];
	$choose	= $_POST['choose'];

	echo $courseID;
	echo $courseName;
	echo $choose;

	if($choose == 'Remain'){
?>

<form method="post" action=<?php echo 'remain.php?courseID=' . $courseID . '&courseName=' . $courseName ?> >
	<label>Select Student to delete</label>
	<select name="stdID">
	<?php
		$query = "SELECT *
		FROM enroll E, student S
		WHERE E.courseID = '$courseID'
		AND E.stdID = S.idNumber
		";
		$result = $mysqli->query($query);
		while ($row = $result->fetch_assoc()){
			echo"<option>";
			echo $row['idNumber']. '-' . $row['name'];
			echo"</option>";
		}
	?>
	</select>
	<div>
		<button class="btn btn-success">Delete Student</button>
	</div>
	<span class="help-block" id=""></span>
</form>
<?php
	}
	else if($choose == 'Delete'){

		$query = "SELECT *
		FROM enroll E
		WHERE E.courseID = '$courseID'
		";
		$result = $mysqli->query($query);
		while ($row = $result->fetch_assoc()){
			$stdID = $row['stdID'];
			echo $stdID;
			$notice = "$courseID-$courseName is deleted due to course!";
			$query1 = "INSERT INTO notice(stdID, notice)
			VALUES ('$stdID', '$notice')";
			$result1 = $mysqli->query($query1);
		}

		$query = "DELETE E.*
		FROM enroll E
		WHERE E.courseID = '$courseID'
		";
		$result = $mysqli->query($query);

		$query = "DELETE C.*
		FROM course C
		WHERE C.courseID = '$courseID'
		";
		$result = $mysqli->query($query);
	}


}
?>