Advertisement
Guest User

Untitled

a guest
Dec 18th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.81 KB | None | 0 0
  1. <?php
  2.     $host = 'localhost';
  3.     $db   = 'hftest';
  4.     $user = 'hftestzone';
  5.     $pass = 'NLXSAii5N9Ukaujk';
  6.     $charset = 'utf8mb4';
  7.  
  8.     $dsn = "mysql:host=$host;dbname=$db;charset=$charset";
  9.     $opt = [
  10.         PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
  11.         PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
  12.         PDO::ATTR_EMULATE_PREPARES   => false,
  13.     ];
  14.     $pdo = new PDO($dsn, $user, $pass, $opt);
  15.  
  16.     $message = "Hello";
  17.     $stmt = $pdo->prepare('SELECT * FROM tkeys WHERE tkey = :tkey');
  18.     $stmt->execute(['tkey' => $tkey]);
  19.     $user = $stmt->fetch();
  20.  
  21.     if($user){
  22.         $sql = "UPDATE tkeys SET tkey = NULL WHERE tkey = ?";
  23.         $pdo->prepare($sql)->execute([$user["message"]]);
  24.         echo "Complete.";
  25.     }else{
  26.         echo "No message.";
  27.     }
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement