Retrieve value from column in table using PDO and MySQL

Question

Im using the following to log my users in,

/*** select the users name from the database ***/
    $dbh = new PDO("mysql:host=$mysql_hostname;dbname=$mysql_dbname", $mysql_username, $mysql_password);

    $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $dbh->prepare("SELECT * FROM access_users 
    WHERE id = :phpro_user_id");

    $stmt->bindParam(':phpro_user_id', $_SESSION['user_id'], PDO::PARAM_INT);

    $stmt->execute();

    $username = $stmt->fetchColumn();

    if($username == false)
    {
    $message = 'Access Error';
    }
    else
    {
        // done
    }

I want to retrieve the users level value, which is a column in my table only im unsure how to do this with PDO?

I've tried...

print $result->level;

Did you tried $username['level']? Cuz you save the result into $username. — Jurik
– Jurik, Commented Aug 19, 2013 at 11:05
Your code is extremely inconsistent. where did you get that $result? Why do you want level in a $username variable? — Your Common Sense
– Your Common Sense, Commented Aug 19, 2013 at 11:05

Your Common Sense · Accepted Answer · 2013-08-19 11:06:39Z

2

As it's impossible to get from your question, what column you ant to retrieve, assuming it is called "username":

$stmt = $dbh->prepare("SELECT username FROM access_users WHERE id = ?");
$stmt->execute(array($_SESSION['user_id']));
$username = $stmt->fetchColumn();

This is how fetchColumn() works.

But if you want to get all the user info, and among it, level and username, you have to retrieve usual way, a whole row.

$stmt = $dbh->prepare("SELECT * FROM access_users WHERE id = ?");
$stmt->execute(array($_SESSION['user_id']));
$row = $stmt->fetch();
if(!$row['level'])
{
    $message = 'Access Error';
}
echo "Hello ".$row['username'];

answered Aug 19, 2013 at 11:06

Your Common Sense

158k42 gold badges226 silver badges374 bronze badges

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

Comments

Conrad Lotz · Accepted Answer · 2013-08-19 11:06:36Z

0

Try the following:

$stmt = $dbh->prepare("SELECT user_id,level FROM access_users 
    WHERE id = :phpro_user_id");

//rest of the code up until here

$result = $stmt->fetchColumn(1);

print("level= $result\n");

answered Aug 19, 2013 at 11:06

Conrad Lotz

8,9513 gold badges25 silver badges28 bronze badges

Collectives™ on Stack Overflow

Retrieve value from column in table using PDO and MySQL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related