php修改mysql数据库

<?php
try {
    // 数据库连接配置
    $host = 'localhost';
    $db   = 'test_db';
    $user = 'root';
    $pass = '';
    $charset = 'utf8mb4';

    // 创建PDO实例
    $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
    $options = [
        PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_EMULATE_PREPARES   => false,
    ];
    $pdo = new PDO($dsn, $user, $pass, $options);

    // 更新数据
    $stmt = $pdo->prepare("UPDATE users SET email = :email WHERE id = :id");
    $stmt->execute([
        'email' => 'newemail@example.com',
        'id'    => 1,
    ]);

    echo "数据更新成功";
} catch (\PDOException $e) {
    throw new \PDOException($e->getMessage(), (int)$e->getCode());
}
?>