<?php


$username = $_POST['username'];
$password = $_POST['password'];

if ($username&&$password)
{
    $connect = mysql_connect("mysql17.000webhost.com","a4579150_abteen","magic1") or die("Could not Connect!");
    mysql_select_db("a4579150_db") or die("Couldn't find DB");

    $query = mysql_query("SELECT * FROM users WHERE usernames='$username'");
    $numrows = mysql_num_rows($query);
    if ($numrows!=0)
    {
      while ($row = mysql_fetch_assoc($query))
      {
         $dbusername = $row['username'];
             $dbpassword = $row['password'];
      }

       if ($username==$dbusername&&$password==$dbpassword)
       {
      echo ("You are in!");
       }
    }
    else
        echo ("User does not exist");
}
else
    die("Please enter a username or password");

?>