User

Complexity

Total Complexity

14

Size/Duplication

Total Lines	142
Duplicated Lines	0 %

Importance

Changes	3
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
B	create()	0	42	9
A	emailExists()	0	32	2

<?php

//error_reporting(0);

class User {

    private $conn;
    private $db_table = "users";

    public $id;
    public $language;
    public $firstname;
    public $lastname;
    public $email;
    public $password;
    public $isFemale;
    public $height;
    public $birthdate;
    public $aims;

    public function __construct($db) {
        $this->conn = $db;
    }

    public function create() {

        $query = "
        INSERT INTO " . $this->db_table . " SET
        Firstname = :firstname,
        Lastname = :lastname,
        Email = :email,
        Password = :password";

        $stmt = $this->conn->prepare($query);

        if (strlen($this->firstname)>0 && strlen($this->lastname)>0) {
            $this->firstname = htmlspecialchars(strip_tags($this->firstname));
            $this->lastname = htmlspecialchars(strip_tags($this->lastname));
        } else {
            throw new InvalidArgumentException('Invalid Firstname or Lastname');
        }

        if ($this->emailExists() || !filter_var($this->email, FILTER_VALIDATE_EMAIL)) {
            throw new InvalidArgumentException('E-Mail problematic');
        } else {
            $this->email = htmlspecialchars(strip_tags($this->email));
        }

        if (strlen($this->password)<8 && !preg_match("#[0-9]+#", $this->password) && !preg_match("#[a-zA-Z]+#", $this->password)) {
            throw new InvalidArgumentException('Invalid Password');
        } else {
            $this->password = htmlspecialchars(strip_tags($this->password));
        }

        $stmt->bindParam(':firstname', $this->firstname);
        $stmt->bindParam(':lastname', $this->lastname);
        $stmt->bindParam(':email', $this->email);

        $password_hash = password_hash($this->password, PASSWORD_BCRYPT);
        $stmt->bindParam(':password', $password_hash);

        if ($stmt->execute()) {
            return true;
        }

        return false;

    }

    public function emailExists() {

        $query = "
        SELECT ID, Firstname, Lastname, Email, Password, Language, IsFemale, Birthdate, Height, Aim_Weight, Aim_Date
        FROM " . $this->db_table . "
        WHERE Email = ?
        LIMIT 0,1
        ";

        $this->email = htmlspecialchars(strip_tags($this->email));

        $stmt = $this->conn->prepare($query);
        $stmt->bindParam(1, $this->email);
        $stmt->execute();
        if ($stmt->rowCount()>0) {

            $row = $stmt->fetch(PDO::FETCH_ASSOC);
            $this->id = $row['ID'];
            $this->language = $row['Language'];
            $this->firstname = $row['Firstname'];
            $this->lastname = $row['Lastname'];
            $this->email = $row['Email'];
            $this->birthdate = $row['Birthdate'];
            $this->isFemale = $row['IsFemale'];
            $this->height = $row['Height'];
            $this->password = $row['Password'];
            $this->aims = array(
            "weight" => $row['Aim_Weight'],
            "date" => $row['Aim_Date']
            );

            return true;

        }

    }

    public function update() {

        $query = "
        UPDATE " . $this->db_table . " SET
        Firstname = :firstname,
        Lastname = :lastname,
        Language = :language,
        IsFemale = :isFemale,
        Birthdate = :birthdate,
        Height = :height,
        Aim_Weight = :aim_weight,
        Aim_Date = :aim_date
        WHERE ID = :id
        ";

        $stmt = $this->conn->prepare($query);
        $this->firstname = htmlspecialchars(strip_tags($this->firstname));
        $this->lastname = htmlspecialchars(strip_tags($this->lastname));
        $this->language = htmlspecialchars(strip_tags($this->language));
        $this->isFemale = htmlspecialchars(strip_tags($this->isFemale));
        $this->birthdate = htmlspecialchars(strip_tags($this->birthdate));
        $this->height = htmlspecialchars(strip_tags($this->height));
        $this->aims->weight = htmlspecialchars(strip_tags($this->aims->weight));
        $this->aims->date = htmlspecialchars(strip_tags($this->aims->date));

        $stmt->bindParam(':firstname', $this->firstname);
        $stmt->bindParam(':lastname', $this->lastname);
        $stmt->bindParam(':language', $this->language);
        $stmt->bindParam(':isFemale', $this->isFemale);
        $stmt->bindParam(':height', $this->height);
        $stmt->bindParam(':birthdate', $this->birthdate);
        $stmt->bindParam(':aim_weight', $this->aims->weight);
        $stmt->bindParam(':aim_date', $this->aims->date);
        $stmt->bindParam(':id', $this->id);

        if ($stmt->execute()) {
            return true;
        }

        return false;

    }

}