/home/techb158/workloadmatch.com/Manager/Inc
Edit: /home/techb158/workloadmatch.com/Manager/Inc/AddCourse.php (2556B)
query($querys);
$rows = $results->fetch_assoc();
$Admin_ID = $rows['Admin_ID'];
$Master_ID = $rows['Master_ID'];
$Manager_ID = 0;
$Manager_ID_Profile = 0;
} else {
$querys = "SELECT * FROM manager_profile Where Manager_ID='".$user_n."'";
$results = $mysqli->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 != ""){
set_flash_msg('Course Name already exist.!', 'warning');
header('Location: addcourse.php');
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()) {
set_flash_msg('Registration failure to add Course Name!'.$insert_stmt->error, 'warning');
header('Location: addcourse.php');
exit();
}else
{
set_flash_msg('Course informations added successfully!', 'success');
header('Location: addcourse.php');
exit();
}
}else{
set_flash_msg('Registration failure to add Course Name!'.$insert_stmt->error, 'warning');
header('Location: addcourse.php');
exit();
}
}
}else{
set_flash_msg('Registration failure please insert Group !', 'warning');
header('Location: addcourse.php');
exit();
}
}