Untitled

<?php
  session_start();

  $db = mysqli_connect('localhost', 'parrot', 'password', 'agenda');
  if(!$db)die("Falha a connectar a base de dados!");
  else echo "conectado com sucesso";

if(isset($_POST['logmein'])) {
   $username = $_POST['ouser'];
   $password = $_POST['opass'];

   $query = "SELECT * FROM users WHERE username = '{$username}' AND password = '{$password}'";
   $result = msqli_query($db,$query);
   if (mysqli_num_rows($result) > 0) {
      while($rows = mysqli_fetch_assoc($result)) {
         $_SESSION['username']=$ouser;

      }
    }
    else { echo "ERRO login inexistente ou password incorrecta"; return; }
}


?>


<!DOCTYPE html>
<head>
  <title>TEST</title>
</head>
<body>
  bnbvnvbnbvnvbn
<?php
   if($_SESSION['username']==""&&empty($_SESSION['username'])) { ?>
<form method=post>
<label>Username:</label><input type=text name=ouser><br>
<label>Password:</label><input type=password name=opass><br>
<input type=submit name=logmein value="Login">
<input type=reset value="Reset">
</form>
<?php }
else {
  echo "Já estás logado como {$_SESSION['username']}"
} ?>

kjfgkjgefkjdgaagf
</body>
</html>