Пример #1
0
function joinSchool($mysqli, $userId, $schoolId)
{
    if (doesUserExist($mysqli, $userId)) {
        if (doesSchoolExist($mysqli, $schoolId)) {
            if (!isUserInSchool($mysqli, $userId, $schoolId)) {
                if ($stmt = $mysqli->prepare("INSERT INTO members_schools SET member_id = ?, school_id = ?")) {
                    $stmt->bind_param("ii", $userId, $schoolId);
                    $stmt->execute();
                    return true;
                } else {
                    return "Faulty MYSQL Statement";
                }
            } else {
                return "User is already in school";
            }
        } else {
            return "School does not exist";
        }
    } else {
        return "User does not exist";
    }
}
Пример #2
0
    ?>
				<li><a href="group.php?id=<?php 
    echo $group["id"];
    ?>
"><?php 
    echo $group["name"];
    ?>
</a></li>
			<?php 
}
?>
		</ul>
		<button type="button" class="btn btn-primary btn-lg" data-toggle="modal" data-target="#group_popup">Create Group</button>
		
		<?php 
if (!isUserInSchool($mysqli, $_SESSION['user_id'], $id)) {
    ?>
			<button id="join_school" onclick="joinSchool(<?php 
    echo $id;
    ?>
);">Join School</button>
		<?php 
} else {
    ?>
 
			<button id="leave_school" onclick="leaveSchool(<?php 
    echo $id;
    ?>
);">Leave School</button>
		<?php 
}