How to map upload.php and my table information

[eluser]iainco[/eluser]
The way I would think about this is, try to make the controller do most of the work - leave the model to pretty much only call DB queries.

Your first idea - "Should I create an array with same index as column names, give it values and then pass it to model" seems to work for me".

If I'm reading it right you could do this:

Controllor:

Code:

function saveUpload()
{
   $d = array(
     file_name      => '',
     file_type      => '',
     file_path      => '',
     full_path      => '',
     raw_name       => '',
     orig_name      => '',
     file_ext       => '',
     file_size      => '',
     is_image       => '',
     image_width    => '',
     image_height   => '',
     image_type     => '',
     image_size_str => ''
   );

   $this->load->model('upload/save_model');
   $this->save_model->saveUpload($d);
}

Model:

Code:

function saveUpload($d)
{
   $this->db->insert('uploads', $d);
}

Obviously this is a very simple example, but if you get an array with the indexes as the table columns you can use the ActiveRecord insert method.

You could have the method that uploads the file return an array of the information, which you then pass into another method to secure/santize, then finally call the saveUpload method.

That's my take on it, but please understand I'm a CI newb!

Everyone feel free to tell me I'm talking rubbish!

Cheers