<?php

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


$host = 'localhost';
$dbname = 'guestlist';

$DBH = new PDO("mysql:host=$host;dbname=$dbname", "root", "");
$STH = $DBH -> prepare("SELECT * FROM users WHERE username=':user' and password=':pass';");
$STH -> bindParam(':user', $username);
$STH -> bindParam(':pass', $password);
$rowCount = $STH -> execute();

if($rowCount == 1)
{
    start_session();
    $_SESSION['username'] = $username;
    return 1;
}
else
{
    return 0;
}



?>