php更新mysql数据库字段

<?php
// 数据库配置
$host = 'localhost';
$dbname = 'your_database';
$username = 'your_username';
$password = 'your_password';

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

    // 要更新的数据
    $userId = 1;
    $newEmail = 'newemail@example.com';

    // 预处理语句
    $stmt = $pdo->prepare("UPDATE users SET email = :email WHERE id = :id");
    $stmt->bindParam(':email', $newEmail);
    $stmt->bindParam(':id', $userId);

    // 执行更新
    if ($stmt->execute()) {
        echo "用户信息更新成功！";
    } else {
        echo "更新失败，请检查SQL语句或数据库连接。";
    }
} catch (PDOException $e) {
    // 错误处理
    echo "数据库连接失败：" . $e->getMessage();
}
?>