public function insert() { include PATH_INCLUDES . 'Password.class.php'; $hashedPassword = Password::password_encrypt($this->password); $var = $this->Db->prepare("INSERT INTO " . self::$table_name . "(username, email, password, first_name, last_name) \n\t\t\tVALUES(:username, :email, :password, :first_name, :last_name)"); $aBinding = array(':username' => $this->username, ':email' => $this->email, ':password' => $hashedPassword, ':first_name' => $this->first_name, ':last_name' => $this->last_name); $var->execute($aBinding); }
public function authenticate($username, $password) { // first make the password to the hashed version as it is in the database $hashedPassword = Password::password_encrypt($password); $sWhereClause = " WHERE username=:username AND password=:password"; // prepare binding $aBinding = array(':username' => $username, ':password' => $hashedPassword); // get an array limited to one user by username and password $this->getRow($sWhereClause, $aBinding); // if the result is array and not empty if (is_array($this->collection) && count($this->collection) > 0) { return true; } }