php - SQL表没有出现在页面上

Question

我在 html 页面上显示表格时遇到了一些问题。这是代码:

$resultaten = $conn->prepare("SELECT * FROM GastenBoek ORDER BY ID DESC");
$resultaten->execute();
while($rij = $resultaten->fetch(PDO::FETCH_ASSOC))
{
    $ID = $row['ID']; //Hier zeg ik : haal ID uit Row.
    $Email = $row['Email'];
    $Bericht  = $row['Bericht'];
    $Tijd = $row['Tijd'];
    $Datum = $row['Datum'];
    echo $Email;
}

我试过使用 PDOStatement 但根本没有解决问题。提前致谢。

Answer 1

你要不要试试这个

$conn = new \PDO('mysql:host='. DB_HOST .';dbname='. DB_NAME, DB_USER, DB_PASSWORD);

$conn->exec("SET NAMES utf8");
$conn->exec("SET character_set_connection = utf8");
$conn->exec("SET character_set_client = utf8");
$conn->exec("SET character_set_results = utf8");

$resultaten = $conn->prepare("SELECT * FROM GastenBoek ORDER BY ID DESC");
$resultaten->execute();
$result = $resultaten->fetchAll(\PDO::FETCH_ASSOC);
foreach($result as $value)
{
    $ID = $value['ID']; //Hier zeg ik : haal ID uit Row.
    $Email = $value['Email'];
    $Bericht  = $value['Bericht'];
    $Tijd = $value['Tijd'];
    $Datum = $value['Datum'];
    echo $Email;
}