Advertisement
Guest User

Untitled

a guest
Jul 14th, 2012
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.53 KB | None | 0 0
  1. <?php
  2.  
  3. $srv = localhost;
  4. $usr = username;
  5. $pw = password;
  6. $db = databas;
  7.  
  8. try {
  9.         $dbh = new PDO("mysql:host=$srv;dbname=$db", $usr, $pw);
  10.  
  11.         $sql = "SELECT wins, gameplayed FROM score;";
  12.  
  13.         foreach ($dbh->query($sql) as $data)
  14.         {
  15.                 $wins = $data['wins'];
  16.                 $gamesplayed = $data['gamesplayed'];
  17.                 $loses = $wins - $gamesplayed;
  18.  
  19.                 echo $loses;
  20.         }
  21.         $dbh = null;
  22. }
  23. catch(PDOException $e)
  24. {
  25.         echo $e->getMessage();
  26. }
  27.  
  28. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement