} } 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"); }