将 MySQL 数据展示为 HTML 表格并实现单行数据选择及传递

<?php
// 数据库连接信息
$host = 'localhost';
$dbname = 'your_database';
$username = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // SQL 查询语句
    $sql = "SELECT id, first_name, last_name, email FROM users";
    $stmt = $pdo->query($sql);

    // 生成 HTML 表格
    echo '<table class="s-table"><thead><tr><th>id</th><th>first name</th><th>last name</th><th>email</th><th>edit</th></tr></thead><tbody>';

    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
        echo '<tr>';
        echo '<td>' . htmlspecialchars($row['id']) . '</td>';
        echo '<td>' . htmlspecialchars($row['first_name']) . '</td>';
        echo '<td>' . htmlspecialchars($row['last_name']) . '</td>';
        echo '<td>' . htmlspecialchars($row['email']) . '</td>';
        echo '<td><a href="edit.php?id=' . htmlspecialchars($row['id']) . '" class="css-button">Edit</a></td>';
        echo '</tr>';
    }

    echo '</tbody></table>';

} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>

<?php
// 数据库连接信息
$host = 'localhost';
$dbname = 'your_database';
$username = 'your_username';
$password = 'your_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 获取 ID 参数
    $id = isset($_GET['id']) ? intval($_GET['id']) : 0;

    // 验证 ID 是否有效
    if ($id <= 0) {
        echo "Invalid ID.";
        exit;
    }

    // SQL 查询语句
    $sql = "SELECT id, first_name, last_name, email FROM users WHERE id = :id";
    $stmt = $pdo->prepare($sql);
    $stmt->execute(['id' => $id]);

    $row = $stmt->fetch(PDO::FETCH_ASSOC);

    // 检查是否找到数据
    if (!$row) {
        echo "No data found for ID: " . $id;
        exit;
    }

    // 显示编辑表单，并填充数据
    echo '<form action="update.php" method="post">';
    echo '<input type="hidden" name="id" value="' . htmlspecialchars($row['id']) . '">';
    echo 'First Name: <input type="text" name="first_name" value="' . htmlspecialchars($row['first_name']) . '"><br>';
    echo 'Last Name: <input type="text" name="last_name" value="' . htmlspecialchars($row['last_name']) . '"><br>';
    echo 'Email: <input type="email" name="email" value="' . htmlspecialchars($row['email']) . '"><br>';
    echo '<input type="submit" value="Update">';
    echo '</form>';

} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}
?>