Forms and Databases (Best Practice)

[eluser]Vicente Russo[/eluser]
Hi,

Thats what I do:

Code:

// Form sent        
$excluded = array('submit','i_agree_radio_button'); // Fields excluded from insert sql
$fieldnames = array( // Just example:
    'field_name_on_form' => 'field_name_on_table',
    'name' => 'name',
    'address_txt' => 'address'
);

$post_temp = array();
foreach($_POST as $index => $value) {
    if(!in_array($index,$excluded)) {
        $post_temp[$fieldnames[$index]] = $this->input->post($index);                    
    }
}

$this->db->insert('table_name', $post_temp);

But its possible to fill the $fieldnames array automatically, and if you put this on a model, ou just have to mess in one place