DBProject/selectIt.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
<?php
session_start();
include "link.php";

$idNumber = $_SESSION["idNumber"];
$courseID = $_GET['courseID'];
$courseYear = $_GET['courseYear'];
$courseTime = $_GET['courseTime'];


//get time
$time = explode("-", $courseTime);

//check time is conflict or not
$conflict = false;
foreach ($time as $value) {
	echo $value;
	$query = "SELECT *
	FROM enroll E, course C
	WHERE E.courseID = C.courseID
	AND C.courseTime LIKE '%$value%'
	AND E.stdID='$idNumber'
	AND C.courseYear='$courseYear'";
	$result = $mysqli->query($query);
	if($result->num_rows){
		$conflict = true;
		break;
	}
}


if($conflict){
	echo "<script type='text/javascript'>";
	echo "alert('Time conflicted!');";
	echo "window.location.href='course.php?webNo=1';";
	echo "</script>";
}
else{
	//check has selected or not
	$query = "SELECT *
	FROM  enroll
	WHERE stdID='$idNumber'
	AND courseID='$courseID'";
	$result = $mysqli->query($query);

	if($result->num_rows){

		echo "<script type='text/javascript'>";
		echo "alert('You have been enrolled!');";
		echo "window.location.href='course.php?webNo=1';";
		echo "</script>";

	}
	else{

		$query = "INSERT INTO enroll (stdID, courseID)
		VALUES ('$idNumber', '$courseID')";
		$result = $mysqli->query($query);
		echo "<script type='text/javascript'>";
		echo "alert('Success!');";
		echo "window.location.href='course.php?webNo=1';";
		echo "</script>";
	}
}

?>