Advertisement
Guest User

Untitled

a guest
Feb 10th, 2017
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.68 KB | None | 0 0
  1. function getUserID () {
  2.     return $_SESSION['steamid'];
  3.  
  4. }
  5.     /* Connect to a MySQL database using driver invocation */
  6.     $dsn = 'mysql:dbname=name;host=csgo-skinz.lima-db.de';
  7.     $user = 'user';
  8.     $password = 'pw';
  9.  
  10.     try {
  11.         $pdo = new PDO($dsn, $user, $password);
  12.     } catch (PDOException $e) {
  13.         echo 'Connection failed: ' . $e->getMessage();
  14.     }
  15. function getUserCredits() {
  16.  
  17.     global $pdo;
  18.     $steamid = getUserID();
  19.     $statement = $pdo->prepare("SELECT user_credits FROM users WHERE steamid='".$_SESSION['steamid']."'");
  20.     $result = $statement->execute(array('steamid' => $steamid));
  21.     $user = $statement->fetch();
  22.     return $user['user_credits'];
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement