Untitled

<!DOCTYPE html>
<html lang="ru" dir="ltr">

<head>
  <meta charset="utf-8">
  <title>Rainbow`s Dashboard</title>
  <link rel="stylesheet" href="style.css">
  <link href="https://fonts.googleapis.com/css?family=Montserrat" rel="stylesheet">
</head>

<style>

  body{
  margin: 0;
  padding: 0;
  font-family: sans-serif;
  background: #34495e;
}
.box{
  width: 300px;
  padding: 40px;
  position: absolute;
  top: 50%;
  left: 50%;
  transform: translate(-50%,-50%);
  background: #191919;
  text-align: center;
}
.box h1{
  color: white;
  text-transform: uppercase;
  font-weight: 500;
}
.box input[type = "text"],.box input[type = "password"]{
  border:0;
  background: none;
  display: block;
  margin: 20px auto;
  text-align: center;
  border: 2px solid #3498db;
  padding: 14px 10px;
  width: 200px;
  outline: none;
  color: white;
  border-radius: 24px;
  transition: 0.25s;
}
.box input[type = "text"]:focus,.box input[type = "password"]:focus{
  width: 280px;
  border-color: #2ecc71;
}
.box input[type = "submit"]{
  border:0;
  background: none;
  display: block;
  margin: 20px auto;
  text-align: center;
  border: 2px solid #2ecc71;
  padding: 14px 40px;
  outline: none;
  color: white;
  border-radius: 24px;
  transition: 0.25s;
  cursor: pointer;
}
.box input[type = "submit"]:hover{
  background: #2ecc71;
}

</style>

<body>
  <form class="box" action="profile.php" method="post">
    <h2>Rainbow`s Dashboard</h2>
    <input type="password" name="key" placeholder="Ваш ключ">
    <input type="submit" name="" value="Вход">
    <div id="howto">Для получения ключа введите команду <em>rb!key</em></div>
  </form>
  <?php
  $servername = 'localhost'; // или же 'zonastro.com'
$username = 'root';
$password = 'rainbowdatabase2005';
$dbname = 'rainbowsdatabase';
$key = $_GET['privateKey'];
$conn = new mysqli($servername, 'root', 'rainbowdatabase2005', 'rainbowsdatabase');

  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  }
  $sql = "SELECT * FROM users WHERE `privateKey` = '" . $key . "' LIMIT 1;";
  $result = $conn->query($sql);

  if ($result->num_rows > 0) {
    while ($row = $result->fetch_assoc()) {

      echo '<h1 class="money">Balance:</h1><h2>' . $row['money'] . '</h2> <h1 class="money" style="float:right; padding-right: 30px;">Logined as: ' . $row['tag'] . '</h1>';
      echo '<h1 class="xp">XP:</h1><h2>' . $row['xp'] . '/' . $next . '</h2> <img style="float:right; height: 200px; width: 200px" src="' . $row['avatar'] . '">';
      echo '<h1 class="level">Level:</h1><h2>' . $row['lvl'] . '</h2>';
      echo '<h1 class="reputation">Rep:</h1><h2>' . $row['rep'] . '</h2>';
      echo '<h1 class="booster">booster:</h1><h2>' . $row['booster'] . '</h2>'; // тут крч надо booster заменить на то значение которое выводит у вас множитель буста
    }
  } else {
  }
  $conn->close();
  ?>

</body>

</html>