PHP selectUsers Examples

Example #1

File: manageusers.php Project: semira27/Spotters

                    <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">

Example #2

File: user.php Project: efdalustaoglu/secure-coding

function getUsers()
{
    getDBCredentials(getAuthUser()->usertype);
    return selectUsers();
}

Example #3

File: loginsubmit.php Project: Olney-James/cs313-php

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