My SQL Error in Session and query

Question

I have a class where I use to get the username, and inside I have the method:

public function getfName() {
        $Session = $_SESSION[$this->Prefix . 'username'];
        $sql = "SELECT * FROM " . DB_DBPREFIX . "$this->Table WHERE name = $Session";

        try {
            $stmt = Conn::dbPrepare($sql);
            $stmt->execute();
            while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {
                $data = $row[1];
                print $data;
            }
        } catch (PDOException $e) {
            echo $e->getMessage();
        }
    }

Only when I put the $Session variable in my query I get this error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'TheNight' in 'where clause'

I searched here on Stack and other sites and found a topic but did not help me, so I decided to open this!

Answer 1

Change the following line:

while ($row = $stmt->fetch(PDO::FETCH_NUM, PDO::FETCH_ORI_NEXT)) {

To:

while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {

See if it works.

Edited:

Dude, since I don’t know how your connection is, I’m going to post a full working example:

$name = 'nome';

try {
    $conn = new PDO('mysql:host=localhost;dbname=database', "user", "pass");
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $data = $conn->query('SELECT * FROM tabela WHERE name = ' . $conn->quote($name));

    $row = $data->fetch(PDO::FETCH_ASSOC);

    echo $row['name'];

} catch(PDOException $e) {
    echo 'ERROR: ' . $e->getMessage();
}

When he returns false is because an error has occurred.
Make the adaptation to your code and test.