function is_admin()

in workshop/99_Miscellaneous/Refactoring/includes/session.php [45:54]

• 10 lines of code
• 1 McCabe index (conditional complexity)

function is_admin($session)
{
    global $databaseConnection;
    $query = "SELECT user_id FROM users_in_roles UIR INNER JOIN roles R on UIR.role_id = R.id WHERE R.name = 'admin' AND UIR.user_id = ? LIMIT 1";
    $statement = $databaseConnection->prepare($query);
    $statement->bind_param('d', $session->get('userid'));
    $statement->execute();
    $statement->store_result();
    return $statement->num_rows == 1;
}