database/selectedpage.php at main · shuan1026/database · 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
<a href = "homepage.php"> 回上頁(Homepage) </a>
<?php
include_once('db.php');
include_once('html.php');
include_once('html_utility.php');

@header("Content-type:text/html;charset=utf-8");

session_start();

if(isset($_SESSION["student_id"])) {

	$student_id =$_SESSION["student_id"];

	//Student selected courses
	$sql = "select course_id, course_name, department, grade, credits, category
			from course
			where course_id in (select course_id from selected_course
				where student_id = \"$student_id\")";
	$result = mysqli_query($conn, $sql) or die('MySQL query error');

	//印出我的已選課程列表
	html_start_box('*****  我的已選課程列表 ******  ', '50%', '   ', '5', 'left', '   ');
	$display_text = array(
		array('display' => 'course_id',     'align' => 'left'),
		array('display' => 'Course Name',   'align' => 'left'),
		array('display' => 'Department',    'align' => 'left'),
		array('display' => 'Grade',     	'align' => 'right'),
		array('display' => 'Credits', 		'align' => 'right'),
		array('display' => 'Category', 		'align' => 'right'),
	);
	echo '<table style="border-collapse: collapse; border: 1px solid black;">';
 	echo '<tr>';
 	foreach ($display_text as $column) {
  		echo '<th style="border: 1px solid black; padding: 5px;">' . $column['display'] . '</th>';
 	}
 	echo '</tr>';
	//html_header($display_text, 2, false);

	while($row = mysqli_fetch_array($result)){
		echo '<tr>';
   		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['course_id'] . '</td>';
   		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['course_name'] . '</td>';
   		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['department'] . '</td>';
   		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['grade'] . '</td>';
   		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['credits'] . '</td>';
		$row['category'] == 'Required' ? "必修" : "選修";
		echo '<td style="border: 1px solid black; padding: 5px;">' . $row['category'] . '</td>';
   		echo '</tr>';
	}
	echo '</table>';
	html_end_box(false);


	//Student Could Withdraw Courses

	//select total_credits from student
	$sql = "select total_credits from student where student_id = \"$student_id\"";
	$result = mysqli_query($conn, $sql) or die('MySQL query error : select total_creedits ');
	$row = mysqli_fetch_array($result);
	$total_credits = $row['total_credits'];

	$under_selected = 0;

	//處理退選時的boundary問題
	if ( ($total_credits - 9) >= 3) {
		$sql = "select course_id, course_name, department, grade, credits
				from course
				where course_id in (select course_id from selected_course
					where student_id = \"$student_id\") and category = \"Elective\"";
	} elseif (($total_credits - 9) == 2) {
		$sql = "select course_id, course_name, department, grade, credits
				from course
				where course_id in (select course_id from selected_course
					where student_id = \"$student_id\") and category = \"Elective\" and credits = 2";
	} else { //(total_credits - 9) = 0 or 1
		$under_selected = 1;
	}


	//印出我的可退選課程列表
	$result = mysqli_query($conn, $sql) or die('MySQL query error');
	html_start_box('******  我的可退選課程列表 ******  ', '50%', '   ', '5', 'left', '   ');
	$display_text = array(
		array('display' => 'course_id',             'align' => 'left'),
		array('display' => 'Course Name',         'align' => 'left'),
		array('display' => 'Department',       'align' => 'left'),
		array('display' => 'Grade',     'align' => 'right'),
		array('display' => 'Credits', 'align' => 'right'),
		array('display' => 'Action', 'align' => 'right'),
	);

	if ($under_selected == 1) {
		echo "已達到學分下限，不能再退選囉 !!";
	} else {

		echo '<table style="border-collapse: collapse; border: 1px solid black;">';
  		echo '<tr>';

  		foreach ($display_text as $column) {
   			echo '<th style="border: 1px solid black; padding: 5px;">' . $column['display'] . '</th>';
  		}
  		echo '</tr>';
		//html_header($display_text, 2, false);
		while($row = mysqli_fetch_array($result)){

			echo '<tr>';
   			echo '<td style="border: 1px solid black; padding: 5px;">' . $row['course_id'] . '</td>';
   			echo '<td style="border: 1px solid black; padding: 5px;">' . $row['course_name'] . '</td>';
   			echo '<td style="border: 1px solid black; padding: 5px;">' . $row['department'] . '</td>';
   			echo '<td style="border: 1px solid black; padding: 5px;">' . $row['grade'] . '</td>';
   			echo '<td style="border: 1px solid black; padding: 5px;">' . $row['credits'] . '</td>';
   			form_selectable_cell(filter_value("Delete", "", 'delete.php?action=delete&id=' . $row['course_id'] . '&student_id=' . $student_id), "Delete");
   			echo '</tr>';
		}
		echo '</table>';
		html_end_box(false);
	}

}


?>


<?php
$conn->close();
?>