}
}
foreach ($semesterCourses[$currentSemester] as $key => $value) {
$m = checkPrerequisites($value['cid'], $array);
if ($m == "true") {
$semesterCourses[$currentSemester][$key]['available'] = "true";
$value['available'] = "true";
} else {
$semesterCourses[$currentSemester][$key]['available'] = "required:\n" . $m;
$value['available'] = "required:\n" . $m;
}
array_push($unselectedCourse, $value);
}
// $_SESSION['semesters']=$semesterCourses;
echo json_encode($unselectedCourse);
} else {
if ($method = "generate") {
session_start();
$sid = $_SESSION['sid'];
$plannerId = mysql_fetch_array(getMaxPlannerIdBySid($sid))[0];
$plannerId++;
for ($i = 0; $i < count($array); $i = $i + 2) {
$cid = $array[$i];
$term = $array[$i + 1];
saveOnePlannerCourse($cid, $sid, $term, $plannerId);
}
insertPlan($sid, $plannerId, "Planner" . $plannerId);
echo "Congratulations! Your plan has saved in the system";
}
}
}
$con = mysql_connect("localhost:3306", "root", "5656123ljx");
if (!$con) {
die('Could not connect: ' . mysql_error());
}
mysql_select_db("capstone", $con);
function insertPlan($sid, $plannerId, $nickName)
{
$sql = "insert into stu_plan(sid,plannerId,nickName) VALUES ('" . $sid . "','" . $plannerId . "','" . $nickName . "')";
mysql_query($sql);
}
function deletePlan($sid, $plannerId)
{
$sql = "delete from stu_plan where sid='" . $sid . "' and plannerId='" . $plannerId . "'";
echo $sql;
mysql_query($sql);
}
$deleteId = $_GET['deleteId'];
if ($deleteId == null) {
session_start();
$sid = $_SESSION['sid'];
$nickName = $_GET['nickName'];
$plannerId = mysql_fetch_array(getMaxPlannerIdBySid($sid))[0];
$plannerId++;
insertPlan($sid, $plannerId, $nickName);
header("location:../view/displayPlanner.php?plannerId=" . $plannerId);
} else {
session_start();
$sid = $_SESSION['sid'];
deletePlan($sid, $deleteId);
header("location:../view/selectTermToSetPlanner.php");
}
