<?php

$database = "dbirkemalm_com";
$usertable = "members";

$db = sqlite_open("dbirkemalm_com", 0666, $error);

$user = $_POST['user'];
$password = $_POST['pass'];


$query = "SELECT * FROM $usertable WHERE username='$user' AND password='$password'";

$result = sqlite_query($query);

$count = sqlite_num_rows($result);

if($count == 1){

    session_register("user");
    session_register("pass");

    header("location:admin.html");
}

else {
    header("location:index.html");
}


?>