login.php

<?php

if(isset($_POST["login"]))
{
    $username = $_POST["username1"];
    $password = $_POST["password1"];
}
function OpenCon()
 {
	$conn = pg_connect($_ENV['DATABASE_URL']);
 	return $conn;
 }
 
 function CloseCon($conn)
 {
    pg_close($conn);
 	// $conn -> close();
 }
 $conn = OpenCon();
 if($conn === false){
    die("ERROR: Could not connect.<br>" . $conn->connect_error);
}

$sql= "SELECT * FROM persons WHERE username='$username' AND password='$password'";
$result = pg_query($conn, $sql);

if(pg_num_rows($result)>0){
	$cookie_name = "username"; 
	$cookie_value = $username;
	setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day
	CloseCon($conn);
	header('Location: home.php');
}else{
    $error = "Your Login Name or Password is invalid";
    echo "$error";
    CloseCon($conn);
}

?>