PHP Pdo：显示数据库中的记录[重复]

Question

This question already has an answer here:

• My PDO Statement doesn't work 1 answer

I want to show all the records from the DB on my website, it's a PDO built website. I want it to show all the records so you can see what's in the DB.

This is how my DB looks like

The connection is set up in a different document called config.php

<?php

date_default_timezone_set('Europe/Amsterdam');

error_reporting(E_ALL & ~ E_DEPRECATED);
ini_set('display_errors', 'ON');

$CONFIG = array();
$CONFIG['root'] = '/home/tom/public_html';
$CONFIG['rootwebsite'] = '/home/tom/public_html';
$CONFIG['website'] = 'https://###';

$CONFIG['dbhost'] = 'localhost';
$CONFIG['dbuser'] = '####';
$CONFIG['dbpass'] = '####';
$CONFIG['dbdatabase'] = 'tom';
?>

This is the code I have in a php document and tried using. The problem is it won't show anything on my website (this is a different file than the file my website is):

<?php

class Forum {

    private $dbh; //dbh = database handler.

    public function __construct($database) {
        $this->dbh = $database;
    }

    public function getForum() {
        $getTopic = $dbh->prepare("SELECT * FROM topics ORDER BY id DESC");
        $getTopic->execute();
        $topics = $getUTopic->fetchAll();
        foreach ($topics as $topic) {
            echo $topic['onderwerp'] . '<br />';
        }
    }

}

</div>

Answer 1

You are not calling the right $connection variable. It should be $this->dbh

$getTopic = $this->dbh->prepare("SELECT * FROM topics ORDER BY id DESC");

Also you are mixing the variables after execute(). You should use easy to remember variables.

public function getForum() {
    try {
        $getTopic = $this->dbh->prepare("SELECT * FROM topics ORDER BY id DESC");
        $getTopic->execute();
        $topics = $getTopic->fetchAll();
        foreach ($topics as $topic) {
            echo $topic['onderwerp'] . '<br />';
        }
    } catch (PDOException $pdoEx) {
        echo $pdoEx->getMessage();
        exit;
    } catch (Exception $ex) {
        echo $ex->getMessage();
        exit;
    }
}

Also since you are not passing any variable to your query, there is no point of using prepare(). Just call query() instead.

For error reporting add,

error_reporting(E_ALL); #place at the top of the script

Also you should consider using a proper IDE like PHPstorm or Netbeans, as they would easily point out unsed variables

As suggested by @adpro, here is a link, to help with debugging