<form name="login_form" action="login.php" method="post">
    <table width="100%" border="0" cellpadding="0" cellspacing="2">
        <tr>
            <td width="40%">Username</td>
            <td><input type="text" name="login_username" id="login_username" /></td>
        </tr>
        <tr>
            <td>Parola</td>
            <td><input type="password" name="login_password" id="login_password" /></td>
        </tr>
        <tr>
            <td>&nbsp;</td>
            <td><input type="submit" name="login_btn" value="Login" /></td>
        </tr>
    </table>
</form>
<?php
session_start();
require_once("dbconnect.php");

//  verifica daca exista date transmise
if ($_POST['login_username'] != "" && $_POST['login_password'] != '') {

    // preia datele din formular
    $username = $_POST['login_username'];
    $password = $_POST['login_password'];

    // formeaza si executa query-ul de select din baza de date
    $sql = "SELECT * FROM users WHERE 'Username' = '".$username."' AND 'Password' = '".$password."'";
    $result = mysqli_query($connect,$sql);

    $count = mysqli_num_rows($result);

      // If result matched $myusername and $mypassword, table row must be 1 row
      if($count == 1) {
         session_register("username");
         $_SESSION['login_user'] = $username;

         header("location: connectafterlogin.php");
      }else {
         $error = "Your Login Name or Password is invalid";
      }
}
?>