Help required with update and insert

[eluser]LuckyFella73[/eluser]
You could do it like in the code provided. It's code from
an older project but basically it works like that. I deleted as many
rows as possible to make it easier to read for you. Hope it
helps you to set up your controller:

Code:

// method 'edit' in your controller:
function edit()
{
    $this->load->helper('form');
    $this->load->library('form_validation');

    
    if ( isset($_POST['form']) AND $_POST['form'] == 'edit' ) // hidden input field with name='form' and value='edit'
    {
        # Form was send:
        $this->id = $this->input->post('row_id');

        $this->load->helper('form');
        $this->load->library('form_validation');

        # Rules:
        $this->form_validation->set_rules('title', 'Title', 'trim|required');
        $this->form_validation->set_rules('text', 'Text', 'trim|required');



        if ($this->form_validation->run() == FALSE)
        {
        
            $data['row_id'] = $this->input->post('row_id');

            $data['title'] = $this->input->post('title');
            $data['text'] = $this->input->post('text');

            $this->load->view('view_edit', $data);
        }
        else
        {                
            $data_db = array(
                'title' => $this->input->post('title'),
                'text' => $this->input->post('text')
            );
            
            $query = $this->YOUR_model->update($data_db, $this->id);

            if ( $query === FALSE)
            {
                $data['msg'] .= 'failed'; // echo in view file
            }
            redirect('list_entries', 'refresh');
        }
    }
    else
    {
        $this->id = $this->uri->segment(3);
        $data['row_id'] = $this->id;
        
        # Get DB data
        $query = $this->YOUR_model->get_row($this->id);

        if ($query === FALSE)
        {
            echo ("query failed");
            exit();
        }
        if ($query->num_rows() > 0)
        {
            foreach ($query->result() as $row)
            {
                $data['row_id'] = $this->id;
                $data['title'] = $row->title;
                $data['text'] = $row->text;
            }
        }
        else
        {
            echo("Fehler beim Abrufen der zu editierenden Daten aus der Datenbank (DE)");
            exit();
        }
        // send db data to the form
        $this->load->view('view_edit', $data);
    }
}

// view file components:
<input type="hidden" id="row_id" name="row_id" value="<?php echo set_value('row_id', $row_id); ?>" />
<input type="text" name="title" id="title" value="<?php echo set_value('title', $title); ?>"/>
<textarea name="text" id="textarea"><?php echo set_value('text', $text); ?></textarea>