Advertisement
Rogerio_Oliveira

Alterando_Dados_No_Banco

Aug 30th, 2017
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.38 KB | None | 0 0
  1. <?php
  2.    
  3.     $dsn = "mysql:dbname=blog;host=localhost";
  4.     $dbuser = "root";
  5.     $dbpass = "";
  6.  
  7.     try {
  8.         $pdo = new PDO($dsn, $dbuser, $dbpass);
  9.         $sql = "UPDATE usuarios SET email = 'abc@hotmail.com' WHERE email = 'suporte@b7web.com.br'";
  10.         $sql = $pdo->query($sql);
  11.  
  12.         echo "Usuário alterado com sucesso!";
  13.  
  14.     } catch (PDOException $e) {
  15.         echo "Falhou: ".$e->getMessage();  
  16.     }
  17.    
  18. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement