<?php
		$username=$_POST['username'];
		$password=$_POST['password'];
		$db = new PDO('mysql:host=localhost;dbname=blog;charset=UTF-8', 'root', 'spunky1');
		$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
		$db->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
		$stmt = $db->prepare('SELECT * FROM users WHERE username=? AND password=?');
		$stmt->execute(array($username, $password));
		$row_count = $stmt->rowCount();
		if ($row_count = "1") {
			$_SESSION['loggedin']=true;
		} else {
			echo "Invalid username or password.";
		}
		?>