php pdo mssql编写的声明

Question

I'm having trouble on using a pdo based function

my GetCurrentLanguage() function returns an int of 0 or 1

public function GetCurrentLangName()
{
    $stmt = $GLOBALS['website']->prepare("SELECT * FROM available_languages WHERE id = :id");
    $stmt->bindParam(':id', $this->GetCurrentLanguage(), PDO::PARAM_INT);

    $stmt->execute();
    $fetch = $stmt->fetchAll();
    return $fetch['name'];
}

and is not working, it returns

Notice: Undefined index: name

Answer 1

If you're expecting many rows, you could have just loop it.

public function GetCurrentLangName()
{
    $data = array():
    $stmt = $GLOBALS['website']->prepare("SELECT * FROM available_languages WHERE id = :id");
    $stmt->bindParam(':id', $this->GetCurrentLanguage(), PDO::PARAM_INT);

    $stmt->execute();
    $fetch = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach($fetch as $row) {
        $data[] = $row['name'];
    }
    return $data;
}

This function (->fetchAll()) returns a multi-dimentional array. May look like this:

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => lang
        )

    [1] => Array
        (
            [id] => 2
            [name] => lang
        )
)

Could have used print_r()/var_dump() on $fetch and you'll see what it yielded.