How can I fix this warning "Illegal string offset" in PHP & PDO?

Question

I want to fix this error. I want to get the column that name in database is role and put it into session

    $username = $_POST['username'];
    $password = $_POST['password'];

    $statment = $con->prepare("select * from users where username = ? and password = ? limit 1");
    $statment->execute(array($username,$password));
    $count = $statment->rowCount();
    $row = $statment->fetchColumn();

    if($count > 0)
    {
        $_SESSION['username'] = $username;
        $_SESSION['password'] = $password;
        $_SESSION['role'] = $row['role'];

        echo 'User Name : '.$_SESSION['username'].' , Password : '.$_SESSION['password'].' , Role : '.$_SESSION['role'];
    }
    else
    {
        echo 'Failed To Login';
    }

You maybe want to post your full error message and on which line you got it. — Rizier123, Sep 16 '16 at 19:43
@Antono: don't need it. you can pass the bind values as an array to the execute call. — Marc B, Sep 16 '16 at 19:49
Besides, @Antono - that's a `mysqli_` function, it's incompatible with PDO (see the tags + the functions used on the statement). — Qirel, Sep 16 '16 at 19:51
Possible duplicate of [Reference - What does this error mean in PHP?](http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php) — Charlotte Dunois, Sep 16 '16 at 20:01

score 1 · Answer 1 · edited May 05 '17 at 19:05

1

RTM: http://php.net/manual/en/pdostatement.fetchcolumn.php

This function returns a VALUE, not an array:

$row = $statment->fetchColumn();
  ^---your column, a string

$_SESSION['role'] = $row['role'];
                       ^^^^^^^^^^---treating your string as an array, with invalid index

edited May 05 '17 at 19:05

Funk Forty Niner

74,450
15
68
141

answered Sep 16 '16 at 19:46

Marc B

356,200
43
426
500

The function he should be using is `fetch(PDO::FETCH_ASSOC)`. – Barmar Sep 16 '16 at 20:32

How can I fix this warning "Illegal string offset" in PHP & PDO?

1 Answers1