<h5 id="users-table-access">Access level</h5> <br/> <div id="users-table"> <?php selectUsers(); ?> <div class="halffull document document-min"> </div> <div class="halffull download document-min">
function getUsers() { getDBCredentials(getAuthUser()->usertype); return selectUsers(); }
session_start(); require_once "databaseconnection.php"; function selectUsers() { global $test; $user = filter_input(INPUT_POST, "username", FILTER_SANITIZE_STRING); $query = "SELECT user_name FROM user_name\n\t\t\tWHERE user_name='{$user}'"; $statement = $test->prepare($query); $statement->execute(); if ($statement->rowCount()) { return TRUE; } else { return FALSE; } } $user_name = selectUsers(); function selectPassword() { global $test; $user = filter_input(INPUT_POST, "username", FILTER_SANITIZE_STRING); $password = filter_input(INPUT_POST, "password", FILTER_SANITIZE_STRING); $query = "SELECT user_name FROM user_name\n\t\t\tWHERE user_name='{$user}'\n\t\t\tAND password=AES_ENCRYPT('{$password}', 'test')"; $statement = $test->prepare($query); $statement->execute(); if ($statement->rowCount()) { return TRUE; echo "password is correct"; } else { return FALSE; echo "password is incorrect"; }