ีuser-login.php

<?php

//Thank SQL:    https://www.w3schools.com/sql/sql_where.asp

$servername = "localhost"; //ใช้ localhost กรณี server อยู่บน online 
$username = "พิมพ์ที่นี่"; //username ของ DirectAdmin/phpMyAdmin 
$password = "พิมพ์ที่นี่"; //password ของ DirectAdmin/phpMyAdmin 
$dbname = "test"; //ชื่อ database

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

//Get data from user
$name = $_POST['name'];
$pass = $_POST['password'];
//Filter on DB
$sql = "SELECT name, password FROM user_login_test WHERE (name='$name' && password='$pass')";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "Login successfully";
}else{
    echo "name or password invalid!";
}

$conn->close();
?>