問題描述

嘿伙計們，我在使用 php 中的 PDO 時遇到了一些麻煩，因為它返回的錯誤是未定義的索引.函數和查詢返回結果的代碼是這樣的:

Hey guys im having a little trouble with the PDO in php as the error it is returning is an undefined index. The code for the function and query and return of result is this:

function getUserDetails($user) {
   $db = connect();
try {
    $stmt = $db->prepare('SELECT name,addr AS address,team
FROM TreasureHunt.Player LEFT OUTER JOIN TreasureHunt.MemberOf ON (name=player) 
LEFT OUTER JOIN TreasureHunt.PlayerStats USING (player)
WHERE name=:user');

    $stmt->bindValue(':user', $user, PDO::PARAM_STR);

    $stmt->execute();
    $results = $stmt->fetchAll();
    $stmt->closeCursor();

} catch (PDOException $e) { 
    print "Error : " . $e->getMessage(); 
    die();
}
return $results;  
}

但是，當運行索引頁面的代碼時，我收到一條錯誤消息:注意:未定義索引:名稱

However when running the code for the index page i get an error that says Notice: Undefined index: name

索引代碼如下:

try {
$details = getUserDetails($_SESSION['player']);
echo '<h2>Name</h2> ',$details['name'];
echo '<h2>Address</h2>',$details['address'];
echo '<h2>Current team</h2>',$details['team'];
echo '<h2>Hunts played</h2> ',$details['nhunts'];
echo '<h2>Badges</h2>';
foreach($details['badges'] as $badge) {
    echo '<span class="badge" title="',$badge['desc'],'">',$badge['name'],'</span><br />';
}
} catch (Exception $e) {
echo 'Cannot get user details';
}

我的問題是為什么它會發出通知，我該如何解決這個問題?

my question is why is it throwing a notice and how do i go around this problem?

推薦答案

fetchAll 返回多維數組中的所有結果(可能是多行)>:

fetchAll returns all results (potentially multiple rows) in a multidimensional array:

array(
    0 => array(/* first row */),
    1 => array(/* second row */),
    ...
)

這就是為什么數組沒有直接索引'name'，它需要是[0]['name'].
或者你不應該fetchAll，而是fetch.

That's why the array doesn't have a direct index 'name', it needs to be [0]['name'].
Or you shouldn't fetchAll, just fetch.

這篇關于PHP 數據庫 PDO 連接的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！