verifyNumber

$memberID = isset($_POST['memberid']) ? $_POST['memberid'] : '';

$lastName = isset($_POST['lastname']) ? strtoupper($_POST['lastname']) : '';


$verifyQuery = "SELECT
    person.PersonID,
    person.LastName,
    person.FirstName,
    users.IsApproved,
    users.Username
FROM
    users
INNER JOIN person ON users.PersonID = person.PersonID";

//quote the variables to prevent SQL injection

$cleanMember = $db->quote($memberID);
$cleanUser = $db->quote($lastName);
$verifyQuery .= " WHERE users.Username = $cleanMember AND UPPER(person.LastName) = $cleanUser";

//now lets query the database
$memberData = $db->query($verifyQuery)->fetchAll();

//return the data as json encoded data
$resp = json_encode($memberData);
print_r($resp);