Untitled

<?php
session_start();
require ('connect.php');
?>

<!doctype html>
<html lang="en">
  <head>
    <!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">

    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
    <link rel="stylesheet" type="text/css" href="css/style.css">
    <link rel="stylesheet" href="css/slider.css">
    <link rel="stylesheet" href="css/buttons.css" />
    <style type="text/css">
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" />
    <style>
      [class*="sticker"] {
       position: relative;
       margin: 15px 0;
       padding: 33px 15px 15px;
       background: #fff;
       border-radius: 6px;
       box-shadow: 1px 1px 5px 2px rgba(0, 0, 0, .64)
      }
      [class*="sticker"]:after {
       content: attr(data-sticker);
       position: absolute;
       top: 0;
       padding: 3px 7px;
       font-size: 12px;
       font-weight: bold;
       background: #999;
       color: #fff
      }
      .sticker-left {
       border-top-left-radius: 6px
      }
      .sticker-right {
       border-top-right-radius: 6px
      }
      .sticker-left:after {
       left: 0;
       border-radius: 6px 0 6px 0
      }
      .sticker-right:after {
       right: 0;
       border-radius: 0 6px 0 6px
      }
      .sticker-danger:after {
       background: #d9534f
      }
      .sticker-warning:after {
       background: #f0ad4e
      }
      .sticker-success:after {
       background: #5cb85c
      }
      .sticker-info:after {
       background: #5bc0de
      }
      .sticker-inverse:after {
       background: #222
      }
    </style>


   <style type="text/css">
   body { background: rgb(52, 58, 64) !important; } /* Adding !important forces the browser to overwrite the default style applied by Bootstrap */
</style>
    <title>ShieldsUp!</title>
  </head>
  <header>

      <!-- <nav class="navbar fixed-top navbar-expand-lg navbar-dark pink scrolling-navbar">
        <button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
            <span class="navbar-toggler-icon"></span>
        </button>
        <div class="collapse navbar-collapse" id="navbarSupportedContent">
          <li class="nav-item dropdown">
            <a class="nav-link dropdown-toggle btn btn-danger btn-sm dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
          Вход
        </a>
        <form class="form-control dropdown-menu" aria-labelledby="navbarDropdown" method="POST">
            <input type="text" name="username" class="form-control" placeholder="Username" required>
            <input type="password" name="password" class="form-control" placeholder="Password" required>
            <div class="dropdown-divider"></div>
            <button class="btn-lg btn-dark btn-block">Войти</button>

        </form>
          </li>
          <a href="reg.php"><button type="button" class="btn btn-danger btn-sm">Регистрация</button></a>

    </nav> -->
    <?php

        require ('connect.php');

        if (isset($_POST['username']) && isset($_POST['password'])) {
          $username = $_POST['username'];
          $password = $_POST['password'];

          $query = "SELECT * FROM shields WHERE username='$username' and password='$password'";
          $result = mysqli_query($connection, $query) or die(mysql_error($connection));
          $count = mysqli_num_rows($result);

          if ($count == 1){
              $_SESSION['username'] = $username;
          } else {
              $fsmsg = "Ошибка";
          }
          if (isset($_SESSION['username'])) {
              $username = $_SESSION['username'];
              echo "<a href='logout.php' class='btn btn-lg btn-primary btn-sm'> Logout </a>";
          }

        } ?>

  </header>
  <body>


    <?php
        if (isset($_POST['login'])) {
        $username = mysql_real_escape_string($_POST['username']);
        $password = md5(mysql_real_escape_string($_POST['password']));

        $checklogin = mysql_query("SELECT * FROM users WHERE Username = '".$username."' AND Password = '".$password."'");

        if(mysql_num_rows($checklogin) == 1)
        {
            $row = mysql_fetch_array($checklogin);
            $email = $row['EmailAddress'];

            $_SESSION['Username'] = $username;
            $_SESSION['EmailAddress'] = $email;
            $_SESSION['LoggedIn'] = 1;


            header('Refresh: 0; url=/index.php');

        }
        else
        {
            echo "<h1>Ошибка</h1>";
            echo "<p>Мы не нашли такого аккаунта. Можешь <a href=\"index.php\">попробовать ещё раз</a>.</p>";
        }

    }

    ?>