Advertisement
Guest User

Untitled

a guest
Jun 30th, 2017
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.35 KB | None | 0 0
  1. <!DOCTYPE html>
  2. <html lang="ru">
  3. <head>
  4. <meta charset="UTF-8"/>
  5. <title>Администраторы</title>
  6. </head>
  7. </html>
  8.  
  9.  
  10. <center><h2>Администраторы</h2></center>
  11. <?php
  12. $user = "H28770"; // пользователь
  13. $password = ""; // пароль
  14. $host = "217.106.107.72"; // хост
  15. $database = "EVE28770"
  16.  
  17.  
  18. try {
  19. $dbh = new PDO('mysql:host=' . $host . ';dbname=' . $database, $user, $password);
  20. $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_SILENT);
  21. $dbh->query("SET NAMES utf8");
  22. } catch (PDOException $e) {
  23. print "Error!: " . $e->getMessage() . "<br/>";
  24. die();
  25. }
  26.  
  27.  
  28. $admins = $dbh->prepare("SELECT * FROM grp_log"); // тут таблица.
  29. $admins->execute();
  30.  
  31. $admins = $admins->fetchAll(PDO::FETCH_ASSOC); //получили массив
  32.  
  33. $text = '<center><table class="table table-hovered" border="1"><tr><th>Ник</th><th>Уровень администратора</th><th>Дата регистрации</th><th>Номер телефона</th><th>Выговоров</th><th>Выговоров(Вконтакте)</th><th>Денег</th><th>Уровень в игре</th></tr><tr></center>';
  34.  
  35.  
  36.  
  37. foreach ($admins as $row){
  38. $text .= '<tr></tr><tr><td>'.$row['admin_name'].'</td><td>'.$row['type'].'</td><td>'.$row['name'].'</td><td>'.$row['date'].';
  39. }
  40. $text .= '';
  41. echo $text;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement