在布尔值中调用成员函数 fetch() 时出错

Question

我不得不将 PHP 请求放在我的网站上，但我收到了这个错误。

我的错误：

致命错误：未捕获的错误：在 C:\wamp64\www\monsite\index.php 的第 71 行
调用布尔值上的成员函数 fetch() 错误：调用 C:\wamp64\ 中布尔值上的成员函数 fetch() www\monsite\index.php 第 71 行

我的代码：

<?php

    //Connexion PDO

    try //afficher les erreurs de connection

    {

        $bdd = new PDO('mysql:host=localhost;bdname=bdd_site;charset=utf8','root','');

    } catch (Exception $e)

    {

      die('Erreur : '.$e->getMessage());

    }

    $contenu=$bdd->query('SELECT * FROM commentaire');

    //on affiche chaque entrée

    while($donnees=$contenu->fetch())

    {

        ?>

        <p> commentare de : <strong><?php  echo $donnees['Pseudo'];?></strong></p>

        <p> Note donnée par <strong> <?php echo $donnees['Pseudo'];?></strong> : <?php echo $donnees['Note']; ?></p>

        <p> comment :</p>

        <p style="color:red;"><?php echo $donnees['Comment'];?> </p>

    <?php

    }

    $contenu->closeCursor(); //termine traitemennt requête

?>

Answer 1

尝试这个&nbsp; &nbsp; &nbsp; <?php&nbsp; &nbsp; &nbsp; &nbsp; //Connexion PDO&nbsp; &nbsp; &nbsp; &nbsp; $dsn = 'mysql:dbname=bdd_site;localhost';&nbsp; &nbsp; &nbsp; &nbsp; $user = 'root';&nbsp; &nbsp; &nbsp; &nbsp; $password = '';&nbsp; &nbsp; &nbsp; &nbsp; //afficher les erreurs de connection&nbsp; &nbsp; &nbsp; &nbsp; try{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $bdd = new PDO($dsn, $user, $password);&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; catch(Exception $e)&nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; die('Erreur : ' . $e->getMessage());&nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $contenu = $bdd->query('SELECT * FROM commentaire');&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; //on affiche chaque entrée&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; while ($donnees = $contenu->fetch()){&nbsp; &nbsp; ?>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <p> commentare de :&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <strong><?php echo $donnees['Pseudo']; ?></strong></p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <p> Note donnée par&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <strong> <?php echo $donnees['Pseudo']; ?></strong> : <?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; echo $donnees['Note']; ?></p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <p> comment :</p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <p style="color:red;"><?php echo $donnees['Comment']; ?> </p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <?php&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $contenu->closeCursor(); //termine traitemennt requête&nbsp; &nbsp; ?>