PHP操作MySQL进行数据更新的方法及实例演示

<?php
$servername = "localhost";
$username = "your_username"; // 替换为你的用户名
$password = "your_password"; // 替換为你的密码
$dbname = "database_name"; // 替换成你要使用的数据库名

// 创建一个新的PDO对象来建立和处理数据库连接
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// 设置错误模式为异常以便捕获任何错误（可选）
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
?>

$sql = "UPDATE your_table SET column1=:value WHERE condition_column=:condition_value";

$stmt = $conn->prepare($sql);
$data = array(
'value' => 'new_data',
'condition_value' => 'unique_identifier'
);

$stmt->execute($data);

<?php
try {
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "test_db";

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

// 假设我们有一个用户表(user)，想把id为1用户的email地址改为新的邮件
$updateQuery = "
UPDATE users
SET email = :newEmail
WHERE id = :userId
";

$stmt = $conn->prepare($updateQuery);

$userData = [
':newEmail' => 'example@example.com',
':userId' => 1,
];

if ($stmt->execute($userData)) {
echo "Record updated successfully.";
} else {
echo "Error updating record: ".implode(",", $stmt->errorInfo());
}

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

$conn = null;
?>