function delete_group($group_ID) { global $bdd; try { $users = get_group_has_user($group_ID); foreach ($users as $key => $value) { $query = $bdd->prepare("DELETE FROM bt_group_has_user \n\t\t\t\t\tWHERE group_ID = :group_ID AND user_ID = :user_ID"); $query->bindValue(':user_ID', $value['user_ID'], PDO::PARAM_INT); $query->bindValue(':group_ID', $group_ID, PDO::PARAM_INT); $query->execute(); } $query = $bdd->prepare("DELETE FROM bt_group \n\t\t\t\tWHERE ID = :group_ID "); $query->bindValue(':group_ID', $group_ID, PDO::PARAM_INT); $query->execute(); return true; } catch (Exception $e) { $query->closeCursor(); return false; } }
} if (!empty($_SESSION['user_ID']) && !empty($_SESSION['team_ID'])) { if (!empty($_GET['group_ID'])) { if (!isset($_POST['group_name'])) { require_once 'model/user/get-users.php'; require_once 'model/user/get-simple-group.php'; require_once 'model/user/get-group-has-user.php'; $users = get_users($_SESSION['team_ID']); $group = get_simple_group($_GET['group_ID']); $groupHasUser = get_group_has_user($_GET['group_ID']); include_once 'view/group/edit-group.php'; } else { require_once 'model/user/edit-group.php'; require_once 'model/user/get-group-has-user.php'; $form = $_POST; $form['group_ID'] = $_GET['group_ID']; $group = get_group_has_user($form['group_ID']); $form['group'] = $group; $edit = edit_group($form); if ($edit) { header('Location: ?module=group¬if=edit'); } else { header('Location: ?module=group¬if=notedit'); } } } else { header('Location: ?module=home'); } } else { header('Location: ?module=auth'); }