Advertisement
Guest User

Untitled

a guest
Mar 9th, 2017
158
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.67 KB | None | 0 0
  1. <?php
  2.  
  3.  
  4. $servername = "localhost";
  5. $username = "Molgan1337";
  6. $password = "rekt";
  7. $dbname = "Molgan1337";
  8. $tablename = "Tabell";
  9.  
  10. //create connection :)
  11. $db = new mysqli($servername, $username, $password, $dbname);
  12.  
  13.  
  14.  
  15. //check connection
  16.  
  17. if($db->connect_error)
  18. {
  19.  
  20. die("cunt" . $db->connect_error);
  21. }
  22. else
  23. echo "Connection succesful! \n";
  24.  
  25. //query the database
  26. $sql = "SELECT * FROM " . $tablename;
  27. $result = $db->query($sql);
  28.  
  29.  
  30.  
  31.  
  32. if($result->num_rows > 0) {
  33.  
  34. $numRow = 0;
  35. while($row = $result->fetch_assoc()){
  36.  
  37. $numRow++;
  38.  
  39. echo $numRow . "name, " . $row['Name'] . "score," . $row['Score'];
  40.  
  41. }
  42. }
  43. else echo "tom";
  44.  
  45. $db->close();
  46.  
  47.  
  48. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement