CODEWITHSUNDEEP
phpmysql
Blake Connally
Blake Connally

Reputation: 689

PHP and MySQL query set to session

I cannot figure out why this isn't working. Every time I run it, it automatically assigns to verified. Any ideas?

$verify = "SELECT verification_status 
    FROM users 
    WHERE username = '$username' ";
$result2 = $conn->query($verify);

if ($result2 == 'verified') {
    $_SESSION['verifiedstatus'] = 'verified';
} elseif ($result2 == 'pending') {
    $_SESSION['verifiedstatus'] = 'pending';
} elseif ($result2 == 'unverified') {
    $_SESSION['verifiedstatus'] = 'unverified';
}

Upvotes: 0

Views: 56

Answers (1)

Funk Forty Niner
Funk Forty Niner

Reputation: 74216

@Fred-ii- Please post your responses a an answer, they helped me get it fixed. It is working properly now after making some adjustments to iterate the query. Thank you. – Blake Connally

As OP's request.

You haven't iterated over the query.

A loop is required to do this, such as a while loop and checking if a row equals something.

You also seem to be learning (MySQL), therefore I suggest that you read up on SQL injection:

Since you may be querying from possible user input.

Upvotes: 3

Related Questions