class User {

    public $id;
    public $username;
    public $password;
    public $first_name;
    public $last_name;

    public static function find_this_query($sql){
        global $database;
        return $database->query($sql);
    }

    public static function find_all_users(){
        return self::find_this_query("SELECT * FROM users");
    }

    public static function find_user_by_id($user_id){
        $result = self::find_this_query("SELECT * FROM users WHERE id=$user_id LIMIT 1");
        return $result->fetch(PDO::FETCH_OBJ);
    }

    public static function verify_user($username,$password){
        global $database;
        $query = self::find_this_query("SELECT * FROM users WHERE username='$username' and password='$password' LIMIT 1");
        if($query->rowCount() == 1) {
            return $query->fetch(PDO::FETCH_OBJ) ;
        }
    }

    public function create(){
            $query = self::find_this_query("INSERT INTO users (username,password,first_name,last_name) VALUES (
            '$this->username','$this->password','$this->first_name','$this->last_name') ");

            if($query->rowCount() === 1 ) {
                global $database;
                $this->id = $database->the_insert_id();
                return true;
            } else {
                return false;
            }
    }

    public function update(){

        global $database;

        $query = self::find_this_query("UPDATE users SET
        username = '$this->username',
        password = '$this->password',
        first_name = '$this->first_name',
        last_name = '$this->last_name'
        WHERE id='$this->id' ");

        return ($database->connection->affected_rows == 1 ) ? true : false ;

    }



}// End of the user class



$user = new User();