CI2: data validation before inserting it in DB

[eluser]pickupman[/eluser]
What if you change:

Code:

$this->load->view('news_inserted', $this->data);
$this->db->insert('news', $_POST);

To

Code:

$this->db->insert('news', $_POST);
$this->load->view('news_inserted', $this->data);

You may find it useful to do a

Code:

foreach($_POST as $key => $value){
  $this->db->set($key, $value);
}
$this->db->insert('news');

As a bonus add this to your controller constructor

Code:

$this->output->enable_profiler(TRUE); // get all the CI goodness