php - 不从 vps 上的数据库输出数据

Question

一切都在本地服务器上运行。传输到vps服务器，没有错误，但没有数据输出。在 MYSQL 中，创建并导出了数据库。也许我没有正确填写这个文件？

数据库.php

<?php

$dbhost = "127.0.0.1";
$dbname = "translatedb";
$username = "root";
$userpass = "(password that was specified when installing mysql on the server)";
$charset = "utf8";
$options = [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION];

$data = [
    "engVal" => trim($_POST["engVal"]),
    "rusVal" => trim($_POST["rusVal"]),
];

$db = new PDO("mysql:host=$dbhost;dbname = $dbname;charset=$charset", $username, $userpass, $options);

if (!empty(trim($_POST["engVal"])) && !empty(trim($_POST["rusVal"]))) {
    $query = "INSERT `translatedb`.`words` (engword,rusword) VALUES (:engVal, :rusVal)";
    $statement = $db->prepare($query);
    $result = $statement->execute($data);
};

资源库

<?php
    require_once("db.php");

    $query = $db->query('SELECT * FROM  `translatedb`.`words`');
    while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
        echo "<tr class='translater-table_item'>
             <td>" . $row['engword'] . "</td>
             <td>" . $row['rusword'] . "</td>
    </tr>";

}

    ?>

标签： phpmysql