PDO fetch / fetchAll

Question

Not new to PHP, but only a day old to PDO. Surely I am doing something wrong here.

    $query = $conn->prepare("SELECT * FROM admins WHERE username = :username AND password = :password");
    $query->execute(array('username' => $username,'password' => sha1($password)));
    $result = $query->fetchAll(PDO::FETCH_ASSOC);
    if (count($result) > 0)
    {
        $_SESSION['user']['who']        = $result[0]['who'];
        $_SESSION['user']['email']  = $result[0]['email'];
        $_SESSION['user']['username']   = $result[0]['username'];
        echo REFRESH;
    }
    else
    {
        $message = "Invalid username / password.";  
    }

the only way I can declare those $_SESSIONS properly is if I use $result[0]['fieldName']; How can I just access it via $result['fieldName']; ?

Explosion Pills · Accepted Answer · 2012-12-28 21:25:07Z

9

fetchAll, as the documentation says, retrieves an array of all fetch data simultaneously. Since you are using FETCH_ASSOC, an array of associative arrays is fetched. If you know for certain that only one column is being returned or are only interested in the first column returned, just use fetch. Otherwise you have to iterate over the fetchAll results or do what you've done.

answered Dec 28, 2012 at 21:25

Explosion Pills

192k56 gold badges341 silver badges417 bronze badges

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

2 Comments

Ronnie Over a year ago

Alright, so what would the proper test case be for it not returning anything if I use just fetch? First thought would be (!empty($result)) ? //log in : //invalid

Explosion Pills Over a year ago

fetch will return a falsy value if there are no rows. You could also check rowCount. Either if ($query->rowCount) or if (!$row = $result->fetch()) will do.

ethrbunny · Accepted Answer · 2012-12-28 21:23:39Z

-1

use:

foreach( $result as $row )  
{  
    $_SESSION['user']['who']  = $row['who'];
    .... and so on
}

answered Dec 28, 2012 at 21:23

ethrbunny

10.5k9 gold badges77 silver badges145 bronze badges

2 Comments

Barmar Over a year ago

Seems silly to use foreach when it overwrites the same variable each time, and when you know there's only one element in the array to begin with.

ethrbunny Over a year ago

True - go with @explosion pills approach.

Collectives™ on Stack Overflow

PDO fetch / fetchAll

2 Answers 2

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related