CODEWITHSUNDEEP
phpmysqlpdo
user5441400
user5441400

Reputation: 95

Fetch a single column by a multi select

I would save the id of each user in a session for get later name ... in my login system. I would do that on each login.
But the problem: If i Select more columns with the sql i cant fetch a single column.
How i can fetch one column even tough i selected more columns in the sql.

I tried something like that:


    $sth->fetch(PDO::FETCH_ASSOC)['password']

But it isn´t working on my code:


    $sth = $X['dbh']->prepare("SELECT `password` `id` FROM `users` WHERE `uid` = :uid; ");
          if (! $sth->execute(array(
            ':uid' => $X['param']['uid'],
          ))) {
          //check for right name, passwort ... 
          }

Upvotes: 0

Views: 132

Answers (1)

Your Common Sense
Your Common Sense

Reputation: 157981

How i can fetch one column even tough i selected more columns in the sql.

Nohow.

Either select only one column, or fetch all that you have selected. Otherwise it would make no sense to select.

And after fetching an array, you can access its members all right.

$user = $sth->fetch(PDO::FETCH_ASSOC);
$pass = $user['password'];

then later in the code you can use $user['id'] as well.

Upvotes: 1

Related Questions