"SELECT * FROM users";

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

$login = "SELECT * FROM users WHERE name= ".$username." AND password= ".$password."";

function login($username,$password){
global $db_conn;
$conn = new mysqli($db_conn['servername'], $db_conn['username'], $db_conn['password'], $db_conn['dbname']);
$username = $_POST['username'];
$password = $_POST['password'];

$login = "SELECT * FROM users WHERE name= ".$username." AND password= ".$password."";
    $login_result = $conn->query($login);

    if ($login_result->num_rows > 0) {

        $output = array();
        while($row = $login_result->fetch_assoc()) {
            $output[] = $row;
            echo "".$row['name']."-".$row['password']."<br>";
        }
        } else {
            echo "Invaild Login Details!"."<br>" ;
            $conn->close();
            return false;
        }
}

$login = "SELECT * FROM users WHERE name= '$username' AND password= '$password'";

"SELECT * FROM users WHERE name= '".$username."' AND password= '".$password."'";

$login = "SELECT * FROM users WHERE name = '{$username}' AND password =
'{$password}' ";

Query = "SELECT * FROM `users` where username = '$username' AND  password = '$password' " ;

$login = "SELECT * FROM users WHERE name= '".$username."' AND password= '".$password."'";