/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc/AddCourse.php (1996B)
query($querys);
$rows = $results->fetch_assoc();
$Admin_ID = $rows['Admin_ID'];
$Master_ID = $rows['Master_ID'];
$Manager_ID = $rows['Manager_ID'];
$Manager_ID_Profile = $rows['Manager_ID'];
$User_Type_ID = $row['User_Type_ID'];
$query = "SELECT * FROM Courses Where Program_ID ='". $Program_ID ."' and Course_Name ='". $Course_Name ."' and Course_Code ='". $Course_Code ."'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
$Course_ID = $Managers['Course_ID'];
if ($Course_ID != ""){
header('Location: addcourse.php?error=Course Name already exist.!');
exit();
}else{
$Register_Time = date("Y/m/d") . ' ' . date('H:i:s');
if ($insert_stmt = $mysqli->prepare("INSERT INTO Courses (Program_ID, Course_Name, Course_Code, Course_Time, Date_Time) VALUES (?, ?, ?, ?, ?)")) {
$insert_stmt->bind_param('sssss',$Program_ID,$Course_Name,$Course_Code,$Course_Time,$Register_Time);
if (! $insert_stmt->execute()) {
header('Location: addcourse.php?error=Registration failure to add Course Name!'.$insert_stmt->error);
exit();
}else
{
header('Location: addcourse.php?error=Course informations added successfully!');
exit();
}
}else{
header('Location: addcourse.php?error=Registration failure to add Course Name!'.$insert_stmt->error);
exit();
}
}
}else{
header('Location: addcourse.php?error=Registration failure please insert Group !');
exit();
}
}