Mysql query not assigning/returning variables?

Question

Here's my Function/Class

class user
{
    public function get_data($username)
    {
        global $pdo;
        $query = $pdo->prepare("SELECT * WHERE user_name = ?"); //display oldest to newest
        $query->bindValue(1, $username);
        $query->execute();
        return $query->fetch();
    }
}

Here's how I do my Call.

$users = new user;
$user = $users->get_data($_POST['username']);
$_SESSION['username'] = $user['user_name'];
$_SESSION['id'] = $user['user_id'];
$_SESSION['credits'] = $user['user_credits'];

Here's my HTML

<li class="right"><a href="#">Hello, <?php echo $_SESSION['username']; ?>.</a></li>
<li class="right"><?php echo $_SESSION['credits']; ?></li>
<li class="right"><?php echo $_SESSION['id']; ?></li>

So for some reason, only the $_SESSION['username']; print's out in the html, the credit/id doesn't have a value so it doesn't display anything, is my query right? I think it should work if the username is being displayed.

Thanks for pointing that out everyone, but it still doesn't give me the values when I run the script, it just gives me the username. — Zera42
– Zera42, Commented Jun 19, 2013 at 7:47

Hanky Panky · Accepted Answer · 2013-06-19 07:51:24Z

3

execute before bindValue?

    $query->execute();
    $query->bindValue(1, $username);

Should be

    $query->bindValue(1, $username);
    $query->execute();

Also, Your Query is wrong

"SELECT * WHERE user_name = ?"   // SELECT from where?

Should be something like

"SELECT * FROM myTable WHERE user_name = ?"

edited Jun 19, 2013 at 7:51

answered Jun 19, 2013 at 7:42

Hanky Panky

46.9k9 gold badges76 silver badges95 bronze badges

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

1 Comment

Zera42 Over a year ago

I forgot the FROM, I didn't even see that! Thank you so much for pointing that out!

som · Accepted Answer · 2013-06-19 07:45:42Z

0

Execute function should be call after bind value

$query->execute();
$query->bindValue(1, $username);

answered Jun 19, 2013 at 7:45

som

4,6542 gold badges23 silver badges36 bronze badges

Collectives™ on Stack Overflow

Mysql query not assigning/returning variables?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related