从 MySQL 数据生成可编辑 HTML 表格：单行数据传递教程

<?php
// 假设你已经建立了数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database_name";

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

    $sql = "SELECT id, first_name, last_name, email FROM users";
    $stmt = $conn->prepare($sql);
    $stmt->execute();

    // 开始构建 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();
}

$conn = null;
?>

.css-button {
  background-color: #4CAF50; /* Green */
  border: none;
  color: white;
  padding: 5px 10px;
  text-align: center;
  text-decoration: none;
  display: inline-block;
  font-size: 14px;
  cursor: pointer;
}

<?php
// edit.php

// 验证是否传递了 ID
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
    $id = intval($_GET['id']); // 确保 ID 是整数

    // 连接到数据库
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "database_name";

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

        // 查询数据库，获取指定 ID 的用户数据
        $sql = "SELECT id, first_name, last_name, email FROM users WHERE id = :id";
        $stmt = $conn->prepare($sql);
        $stmt->execute(['id' => $id]);

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

        // 检查是否找到了用户
        if ($user) {
            // 显示编辑表单
            ?>
            <h1>Edit User</h1>
            <form action="update.php" method="POST">
                <input type="hidden" name="id" value="<?php echo htmlspecialchars($user['id']); ?>">
                <label for="first_name">First Name:</label><br>
                <input type="text" id="first_name" name="first_name" value="<?php echo htmlspecialchars($user['first_name']); ?>"><br><br>
                <label for="last_name">Last Name:</label><br>
                <input type="text" id="last_name" name="last_name" value="<?php echo htmlspecialchars($user['last_name']); ?>"><br><br>
                <label for="email">Email:</label><br>
                <input type="email" id="email" name="email" value="<?php echo htmlspecialchars($user['email']); ?>"><br><br>
                <input type="submit" value="Update">
            </form>
            <?php
        } else {
            echo "User not found.";
        }

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

    $conn = null;

} else {
    echo "Invalid ID.";
}
?>

<?php
// update.php

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // 验证和清理输入
    $id = isset($_POST['id']) && is_numeric($_POST['id']) ? intval($_POST['id']) : 0;
    $firstName = isset($_POST['first_name']) ? htmlspecialchars($_POST['first_name']) : '';
    $lastName = isset($_POST['last_name']) ? htmlspecialchars($_POST['last_name']) : '';
    $email = isset($_POST['email']) ? htmlspecialchars($_POST['email']) : '';

    // 连接到数据库
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "database_name";

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

        // 更新数据库
        $sql = "UPDATE users SET first_name = :first_name, last_name = :last_name, email = :email WHERE id = :id";
        $stmt = $conn->prepare($sql);
        $stmt->execute(['first_name' => $firstName, 'last_name' => $lastName, 'email' => $email, 'id' => $id]);

        // 重定向到列表页面或显示成功消息
        header("Location: index.php"); // 假设 index.php 是显示用户列表的页面
        exit();

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

    $conn = null;
} else {
    echo "Invalid request.";
}
?>