Having problems with creating a CRUD..

[eluser]Pascal Kriete[/eluser]
For the remove function it's pretty straight forward. For each remove link you output, you also add a url segment with the id.

So your link would be: http://www.example.com/comment/delete/5

And your code:

Code:

function delete($id = -1)
{
    $this->db->delete('usercomment', array(’id’ => $id));
}

For the edit field you use the same concept. The slug defines the id and is passed into your function as an argument.

Code:

function edit($id)
{
    $this->load->helper('form');
    
    $query = $this->db->get_where('comments', array('id' => $id));
    $data['comment'] = $query->result();

    if ( count($_POST) > 0 )
    {
         $this->db->where('id', $id);
        $this->db->update('comment', $_POST);
        redirect('');
    }
    else
    {
        $this->load->view('edit_comment', $data);
    }
}

All of the keys in the data array are converted to variables in the view so $data['comment'] becomes $comment.

View:

Code:

<?= form_open('comment/edit/'.$comment->id); ?>

<input type="text" name="comment" maxlength="20" value="<?=$comment->text ?>">

// Etc.

Obviously, you will want form validation and such, but this should get the idea across.

Hope that helps.

ps. try wrapping the code you post in [ code ] tags, it makes it a lot easier to read