function modify_mentor($mentor_id, $mentor_last_name, $mentor_first_name, $mentor_suffix, $mentor_field, $mentor_position, $mentor_company, $mentor_profile, $mentor_keywords, $pres_room, $pres_host_teacher, $pres_max_capacity, $mentor_sessions)
{
global $db;
$query = 'update mentor set
mentor_last_name = :mentor_last_name, mentor_first_name = :mentor_first_name,
mentor_suffix = :mentor_suffix,
mentor_field = :mentor_field, mentor_position = :mentor_position,
mentor_company = :mentor_company,
mentor_profile = :mentor_profile, mentor_keywords = :mentor_keywords
, pres_room = :pres_room,
pres_host_teacher = :pres_host_teacher,
pres_max_capacity = :pres_max_capacity WHERE mentor_id = :mentor_id';
try {
$statement = $db->prepare($query);
$statement->bindValue(':mentor_last_name', $mentor_last_name);
$statement->bindValue(':mentor_id', $mentor_id);
$statement->bindValue(':mentor_first_name', $mentor_first_name);
$statement->bindValue(':mentor_suffix', $mentor_suffix);
$statement->bindValue(':mentor_field', $mentor_field);
$statement->bindValue(':mentor_position', $mentor_position);
$statement->bindValue(':mentor_company', $mentor_company);
$statement->bindValue(':mentor_profile', $mentor_profile);
$statement->bindValue(':mentor_keywords', $mentor_keywords);
$statement->bindValue(':pres_room', $pres_room);
$statement->bindValue(':pres_host_teacher', $pres_host_teacher);
$statement->bindValue(':pres_max_capacity', $pres_max_capacity);
$statement->execute();
$statement->closeCursor();
$db->beginTransaction();
for ($i = 0; $i < 4; $i++) {
$presentation = get_presentation_by_mentor_session($mentor_id, $i + 1);
if (!empty($presentation) && empty($mentor_sessions[$i])) {
$query = 'select pres_id from presentation where mentor_id = :mentor_id
and ses_id = :ses_id';
$statement = $db->prepare($query);
$statement->bindValue(':mentor_id', $mentor_id);
$statement->bindValue(':ses_id', $i + 1);
$statement->execute();
$result = $statement->fetch();
$statement->closeCursor();
$pres_id = $result['pres_id'];
$query = 'delete from pres_user_xref where pres_id = :pres_id';
$statement = $db->prepare($query);
$statement->bindValue(':pres_id', $pres_id);
$statement->execute();
$statement->closeCursor();
$query = 'delete from presentation where mentor_id = :mentor_id
and ses_id = :ses_id';
$statement = $db->prepare($query);
$statement->bindValue(':mentor_id', $mentor_id);
$statement->bindValue(':ses_id', $i + 1);
$statement->execute();
$statement->closeCursor();
} elseif (empty($presentation) && !empty($mentor_sessions[$i])) {
$query = 'insert into presentation values (NULL, :ses_id, :mentor_id, 0, NULL)';
$statement = $db->prepare($query);
$statement->bindValue(':mentor_id', $mentor_id);
$statement->bindValue(':ses_id', $i + 1);
$statement->execute();
$statement->closeCursor();
}
}
$db->commit();
} catch (PDOException $e) {
display_db_exception($e);
$db->rollBack();
exit;
}
}
$mentor_id = filter_input(INPUT_GET, 'mentor_id');
$mentor = get_mentor($mentor_id);
$mentor_first_name = $mentor['mentor_first_name'];
$mentor_last_name = $mentor['mentor_last_name'];
$mentor_suffix = $mentor['mentor_suffix'];
$mentor_field = $mentor['mentor_field'];
$mentor_position = $mentor['mentor_position'];
$mentor_company = $mentor['mentor_company'];
$mentor_profile = $mentor['mentor_profile'];
$mentor_keywords = $mentor['mentor_keywords'];
$pres_room = $mentor['pres_room'];
$pres_host_teacher = $mentor['pres_host_teacher'];
$pres_max_capacity = $mentor['pres_max_capacity'];
$mentor_sessions_check = [false, false, false, false];
for ($i = 1; $i <= 4; $i++) {
if (!empty(get_presentation_by_mentor_session($mentor_id, $i))) {
$mentor_sessions_check[$i - 1] = true;
}
}
include 'mentor_modify.php';
exit;
break;
case 'modify_mentor':
$choice = filter_input(INPUT_POST, 'choice');
$mentor_id = filter_input(INPUT_POST, 'mentor_id');
if (filter_input(INPUT_POST, 'choice') == "Modify") {
$mentor_first_name = filter_input(INPUT_POST, 'mentor_first_name');
$mentor_last_name = filter_input(INPUT_POST, 'mentor_last_name');
$mentor_suffix = filter_input(INPUT_POST, 'mentor_suffix');
$mentor_position = filter_input(INPUT_POST, 'mentor_position');
$mentor_company = filter_input(INPUT_POST, 'mentor_company');
