gistfile1.php

<?php
function game() {
    global $db;

    if ($_SERVER['REQUEST_METHOD'] == "POST") {

        $userID = isset( $_POST['userID'] ) ? $_POST['userID'] : false ;

        if ( !$userID ) {
            header('Content-type: application/json');
            echo json_encode(array(
                'userID'     => $userID,
                'message'    => 'Game data pull failed'
            ));
            return false;
        }

        // Gets the School ID based on the User ID
        $db->query("SELECT schoolID FROM schools WHERE `schoolAdmin` = ?")->bind(1, $userID)->execute();
        if ($db->getTotalRows()) {
            $result = $db->fetch();
            $schoolID = $result['schoolID'];
        }

        $db->query("SELECT * FROM games WHERE `homeSchoolID` = ?")->bind(1, $schoolID)->execute();
        if ($db->getTotalRows()) {
            $result = $db->fetchAll();
        }

        if (isset($result)) {
            header('Content-type: application/json');
            echo json_encode(array(
                'result'    => $result,
            ));
            return true;
        } else {
            header('Content-type: application/json');
            echo json_encode(array(
                'message'    => 'Failed'
            ));
            return false;
        }
    }
}