Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function getUserID () {
- return $_SESSION['steamid'];
- }
- /* Connect to a MySQL database using driver invocation */
- $dsn = 'mysql:dbname=name;host=csgo-skinz.lima-db.de';
- $user = 'user';
- $password = 'pw';
- try {
- $pdo = new PDO($dsn, $user, $password);
- } catch (PDOException $e) {
- echo 'Connection failed: ' . $e->getMessage();
- }
- function getUserCredits() {
- global $pdo;
- $steamid = getUserID();
- $statement = $pdo->prepare("SELECT user_credits FROM users WHERE steamid='".$_SESSION['steamid']."'");
- $result = $statement->execute(array('steamid' => $steamid));
- $user = $statement->fetch();
- return $user['user_credits'];
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement