Untitled

<?php
    include 'include/connection.php';
    session_start();

    if ($_SERVER["REQUEST_METHOD"] == "POST") {
        $myusername = mysqli_real_escape_string($conn, $_POST['username']);
        $mypassword = mysqli_real_escape_string($conn, $_POST['password']);

        $sql = "SELECT id FROM userdata WHERE username = '$myusername' and password = '$mypassword'";
        $result = mysqli_query($conn, $sql);
        $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
        $active = $row['active'];

        $count = mysqli_num_rows($result);

        if ($count == 1) {
            session_register("myusername");
            $_SESSION['login_user'] = $myusername;

            header ("location: index.php");
        } else {
            $error = "Your login name or password is invalid.";
        }
    }
?>

<!DOCTYPE html>
<head>
    <title>Fast Food Guru - Login</title>
    <link rel="stylesheet" type"text/css" href="settings.css">
</head>

<html>
<body>

    <form action="" method="POST">
    <label for ="username">Username: </label><input type="text" name="username" id="username" required/><br />
    <label for ="password">Password: </label><input type="password" name="password" id="password" required/><br />
    <input type="submit" name="login" id="login" value="Login" />
  </form>

</body>
</html>

<?php
  $dbhost = "localhost";
  $dbuser = "admin";
  $dbpass = "password";
  $dbname = "fastfoodguru";

  $conn = new mysqli($dbhost, $dbuser, $dbpass, $dbname);

  if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
  }
 ?>