how to fetch data from database and store into variables!!

[Eagle.Avik]

hi, in the mysql we can fetch data and store them into variables, like the code below:

    if (mysql_num_rows($userquery) != 1) {
    die ("that member could not be found!");
    while($row = mysql_fetch_array ($userquery, MYSQL_ASSOC)){
        $first_name = $row['first_name'];
        $last_name = $row['last_name'];
        $email = $row['email'];
        $password = $row['password'];
        $sex = $row['sex'];
        $dbusername = $row['username'];
    }

but how can i do the same with pdo??

http://php.net/manual/en/pdostatement.fetchall.php

You'll notice that you return a multidimensional array instead of a resource. You can iterate with a foreach loop.