Sql Insert Help

[eluser]draconus[/eluser]
I am in need of a little assistance with an sql insert. I start with processing a validated form and call the model and function I set up for this insert. So far so good, I even echoed out the post array to ensure that the model is getting the data it needs. From there I do the insert, which does create a new row in my table, but does not pass the form data in. here is my model code that I created for this:

Code:

function insert_user(){
        $this->input->post('firstName');
        $this->input->post('lastName');
        $this->input->post('username');
        $this->input->post('password');
        $this->input->post('email');
        

        $this->db->insert('users', $this);
    }

And to test that the model has the information it needs, I used the following line of code at the beginning of the insert_user function:

Code:

echo $this->input->post('firstName');

Which displays the data on screen correctly.

What could I be doing wrong that it is inserting an empty record into the table and not filling in the form fields? I thought originally that the trim on the form_validation may be the likely culprit, but if i can echo out the post data correctly from the model, then this couldn't be the case, correct?

[eluser]draconus[/eluser]
A little help guys? Please?

[eluser]ray73864[/eluser]
how would that work anyway?

now, if you did this:

Code:

$data = array(
               'firstName'=>$this->input->post('firstName'),
               'lastName'=>$this->input->post('lastName'),
               'username'=>$this->input->post('username'),
               'password'=>$this->input->post('password'),
               'email'=>$this->input->post('email')
        );

$this->db->insert('users', $data);

Another way that would work if i recall correctly:

Code:

$this->db->insert('users',$_POST);

The way you are doing it though, is to insert $this into the DB, unfortunately that is an object not an array.

[eluser]draconus[/eluser]
Oh, crap, your right... lol, thanks That did the trick... I don't know how I didn't see that until you pointed it out... Seriously... thanks...