Code has been added to clipboard!
PHP MySQL Update for PDO Users
Example
<?php
$server = 'host';
$user = 'user';
$pass = 'pass';
$db = 'db';
try {
$conn = new PDO("mysql:host=$server;dbname=$db",$user, $pass);Â
  // set the PDO error mode to exception
   $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);Â
  $sql = "UPDATE users SET uesrname='john.doe' WHERE user_id=2";
   // Prepare statement
   $stmt = $conn->prepare($sql);
   // execute the query  Â
$stmt->execute();
   // echo a message to say the
UPDATE succeeded
   echo $stmt->rowCount() . "Update successful";
  } catch (PDOException $e) {
echo $sql . "</br>" . $e->getMessage();
  }
$conn = null;
?>