PHP Tutorial: Developing a Login – Part 1 - Data structure

 
CREATE TABLE users (
  userID int(11) NOT NULL AUTO_INCREMENT,
  email varchar(255) NOT NULL,
  pass char(32) NOT NULL,
  PRIMARY KEY (userID),
  UNIQUE KEY email (email)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 ;
 

 
INSERT INTO users(email, pass)
VALUES('admin@yourdomain.com', MD5('123456'))
 

 
interface Iuser
{
 	public function valid($email, $password);
}
 

 
class user implements Iuser
{
	private function connect()
	{
		$mysqli = @new mysqli(HOST, USERNAME, PASSWORD, DATABASE);
		if (mysqli_connect_errno())	{
			throw new Exception(mysqli_connect_error());
		}
		return $mysqli;
	}	
	public function valid($email, $password)
	{
		$db = $this->connect();	
		$email = $db->real_escape_string($email);
		$password = $db->real_escape_string($password);
		$result = $db->query("SELECT userID, email											FROM users
					WHERE email = lower('$email')
					AND pass = md5('$password')");	
		$row = $result->fetch_assoc();
		$result->close();
		$db->close();
		return $row;
	}
}
 

 
class Authenticate
{
	public function __construct(Iuser $datasource)
	{
		$this->datasource = $datasource;
	}