<?php

include("login_connect.php");
session_start();

if($_SERVER["REQUEST_METHOD"]=="POST"){

    // sent user name and password
    $loginusername=mysqli_real_escape_string($conn,$_POST['userName']);
    $loginuserpassword=mysqli_real_escape_string($conn,$_POST['userPassword']);

    $sql = "SELECT id FROM userdetails WHERE UserName = '$loginusername' and UserPassword = '$loginuserpassword'";
    $result = mysqli_query($conn, $sql);

    // show result error_get_last
    if (!$result) {
        printf("Error: %sn", mysqli_error($conn));
        exit();
    }

    $row = mysqli_fetch_array($result,MYSQLI_ASSOC);
    $active = $row['active'];

    $count = mysqli_num_rows($result);

    // If result matched $loginusername and $loginuserpassword, table row must be 1 row
    if($count == 1) {
        $_SESSION['name'] = $loginusername;
        header("location: userwelcome.php");
    }else {
        echo "Your Login Name or Password is invalid";

    }
}

?>