MVC structural advice - separation of code

[eluser]Lyon[/eluser]
Sorry, I had to abandon the project for a while while I got another project sorted.
I could have sworn I replied to this :-S my bad :red:

I think what you were meaning was something like :

Code:

$user = new User();
$user->username = "my_username";
$user->password = "my_password";
$user->Save();

I'm not really sure how that would work though.
Would it be something like :

Code:

class User
{
    private $db = null;
    private $CI = null;

    public $username = '';
    public $password = '';
    public $id = -1;

    public function __construct()
    {
        $this->CI &= get_instance();
        $this->db = $this->CI->load->database('user', true);
    }

    public function save()
    {
        $this->db->insert('users', array("username" => $username, "password" => $password));
        $this->id = $this->CI->insert_id();
    }

    public function get_from_username($username)
    {
        $this->db->from('users');
        $this->db->where("username", $username);
        $query = $this->db->get();

        if($query->num_rows() !== 1) return false;

        $row = $query->row();
        $this->username = $row->username;
        $this->password = $row->password;
        $this->id = $row->id;
    }
}

Or would it be different, there seem to be a lot of CRUD tutorials on the internet, but apart from using Doctrine I cannot find any using objects, just arrays of information passed to a model.

Or should I just use Doctrine for CRUD?

Thanks.