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, Sep 05 '16 at 21:07
you're also missing some code to iterate over the query. You can't just "check if it's equal to something" like that. — Funk Forty Niner, Sep 05 '16 at 21:08
Session was started, values quoted now. @Fred-ii- What do you mean code to iterate over the query — Blake Connally, Sep 05 '16 at 21:10
@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, Sep 05 '16 at 21:21
@BlakeConnally Done. Sorry, I was away for a bit since I was getting supper ready. Cheers — Funk Forty Niner, Sep 05 '16 at 21:23
Instead of a pile of `if` statements, why not either a `switch` or an [`in_array`](http://php.net/manual/en/function.in-array.php) test? — tadman, Sep 05 '16 at 21:24
@tadman I apologize, I am still learning to be more effective. I will research switch and in_array thank you. — Blake Connally, Sep 05 '16 at 21:25
@BlakeConnally Nothing wrong with learning. Just giving you a few things to look into so you can broaden your tool set. — tadman, Sep 05 '16 at 21:25
@tadman Wow! That's amazing, just rearranged it using switch. So much more effective. Thank you. — Blake Connally, Sep 05 '16 at 21:30

score 3 · Accepted Answer · edited May 23 '17 at 11:46

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 '17 at 11:46

Community

1
1

answered Sep 05 '16 at 21:23

Funk Forty Niner

74,450
15
68
141

Correct, thank you. I did a while loop and it worked perfect. Thank you. – Blake Connally Sep 05 '16 at 21:23
@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). – Funk Forty Niner Sep 05 '16 at 21:31

PHP and MySQL query set to session

1 Answers1