Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
<?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();
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment