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

session_start();

$array = array(1 => 'Mon', 2 => 'Tue', 3 => 'Wed', 4 => 'Thu', 5=>'Fri');

for ($i = 1; $i <= 11; $i++) {
      for($j=1; $j <=5; $j++){
             $table[$i][$j] = "";
      }
}

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

		$MyHead=$_SESSION["student_id"];

		// select student selected course
        $sql="select course_name, course_id, time_slot_id from course where course_id in (select course_id from selected_course where student_id = \"$MyHead\")";
 		$result = mysqli_query($conn, $sql) or die('MySQL query error : select course name , id ');
		//echo $sql;

		while($row = mysqli_fetch_array($result)){

			$slot_id = $row['time_slot_id'];

			// select day, time accoring to time_slot_id
	        $sql1="select time_slot_id, time_day, start_time, end_time  from time_slot where time_slot_id = \"$slot_id\"";
			$result1 = mysqli_query($conn, $sql1) or die('MySQL query error : query time_slot_id ');
			$row1 = mysqli_fetch_array($result1);

            $day = $row1['time_day'];
            $num1 = $row1['start_time'];
            $num3 = $row1['end_time'];

            if($num3 - $num1 ==2){
             	$num2 = $num1 + 1;
           	}

            $key = array_search($day, $array);
 			//echo  "  " . $slot_id . "  " . $num1 . "  " . $day . "  " .     $key . "  ";

            $table[$num1][$key] = $row['course_name'];
            $table[$num3][$key] = $row['course_name'];
            if($num3 - $num1 ==2){
	            $table[$num2][$key] = $row['course_name'];
        	}

        }

		//print_r($table);

		$result = mysqli_query($conn, $sql) or die('MySQL query error');
		html_start_box('******  我的課表  ******  ', '100%', '   ', '5', 'left', '   ');

		$display_text = array(
			array('display' => '        ', 'align' => 'left'),
			array('display' => 'Monday  ', 'align' => 'left'),
			array('display' => 'Tuesday ', 'align' => 'left'),
			array('display' => 'Wednsday', 'align' => 'left'),
			array('display' => 'Thursday', 'align' => 'left'),
			array('display' => 'Friday  ', 'align' => 'left'),
		);
		//html_header($display_text, 2, false);
		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>';


		for ($i = 1; $i <= 11; $i++) {

			echo '<td style="border: 1px solid black; padding: 5px; width: 20px; height: 50px; color: blue">' .$i. '</td>';
			echo '<td style="border: 1px solid black; padding: 5px; width: 120px; height: 50px">' .$table[$i][1]. '</td>';
			echo '<td style="border: 1px solid black; padding: 5px; width: 120px; height: 50px">' .$table[$i][2]. '</td>';
			echo '<td style="border: 1px solid black; padding: 5px; width: 120px; height: 50px">' .$table[$i][3]. '</td>';
			echo '<td style="border: 1px solid black; padding: 5px; width: 120px; height: 50px">' .$table[$i][4]. '</td>';
			echo '<td style="border: 1px solid black; padding: 5px; width: 120px; height: 50px">' .$table[$i][5]. '</td>';

			form_end_row();
		}
		html_end_box(false);

	}
?>