PHP and MySQL query set to session

Question

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

there are many syntax errors here. Not quoting values and assigning rather than comparing. It's also unknown if the session was started. — Funk Forty Niner
– Funk Forty Niner, Commented Sep 5, 2016 at 21:07
Instead of a pile of if statements, why not either a switch or an in_array test? — tadman
– tadman, Commented Sep 5, 2016 at 21:24
@BlakeConnally Nothing wrong with learning. Just giving you a few things to look into so you can broaden your tool set. — tadman
– tadman, Commented Sep 5, 2016 at 21:25
@tadman Wow! That's amazing, just rearranged it using switch. So much more effective. Thank you. — Blake Connally
– Blake Connally, Commented Sep 5, 2016 at 21:30

Community · Accepted Answer · 2017-05-23 11:46:08Z

3

@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.

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Sep 5, 2016 at 21:23

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Blake Connally Over a year ago

Correct, thank you. I did a while loop and it worked perfect. Thank you.

Funk Forty Niner Over a year ago

@BlakeConnally I made a slight edit to my answer about SQL injection. You may want to read up on that, cheers (You will need to reload it in order to see the addition).

Collectives™ on Stack Overflow

PHP and MySQL query set to session

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related