<?php
class DO_User {
    public $userId;
    public $firstName;
    public $lastName;
    public $email;

    // This function will perform a select on the table looking for a specific userId.
    public function get($userId)
    {
        $sql = 'SELECT * FROM User WHERE userId=' . mysql_escape_string($userId);
        $rs = mysql_query($sql);
        $row = mysql_fetch_array($rs);

        $this->userId    = $row['userId'];
        $this->firstName = $row['firstName'];
        $this->lastName  = $row['lastName'];
        $this->email     = $row['email']
    }
    
    public function insert()
    {
        $sql = "INSERT INTO
                    User
                SET
                    firstName='" . mysql_escape_string($this->firstName) . "',
                    lastName='" . mysql_escape_string($this->lastName) . "',
                    email='" . mysql_escape_string($this->email) . "'";
        
        mysql_query($sql);
        $this->userId = mysql_insert_id();
    }
    
    public function update()
    {
        $sql = "UPDATE
                    User
                SET
                    firstName='" . mysql_escape_string($this->firstName) . "',
                    lastName='" . mysql_escape_string($this->lastName) . "',
                    email='" . mysql_escape_string($this->email) . "'
                WHERE
                    userId=" . mysql_escape_string($this->userId);
        
        mysql_query($sql);
    }
    
    public function delete()
    {
        $sql = "DELETE FROM
                    User
                WHERE
                    userId=" . mysql_escape_string($this->userId);
        
        mysql_query($sql);
    }
}
?>