PHP get_group_has_user Examples

Example #1

File: delete-group.php Project: xeewi/xwBugTracker

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

Example #2

File: edit-group.php Project: xeewi/xwBugTracker

}
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&notif=edit');
            } else {
                header('Location: ?module=group&notif=notedit');
            }
        }
    } else {
        header('Location: ?module=home');
    }
} else {
    header('Location: ?module=auth');
}