更新数据库[codeIgniter]

Question

I'm new to codeIgniter, I have followed the main tutorial and now I'm trying to create the update funtion, but it gives to me an error that I don't know why.

Here is my model

public function update_news($id=0)
    {
        $this->load->helper('url');
        $slug = url_title($this->input->post('title'),'dash',TRUE);

        $data = array(
            'title' => $this->input->post('title'),
            'text' => $this->input->post('text')
        );

        $this->db->where('id', $id);

        return $this->db->update('news', $data);
    }

Controller:

public function update($id)
    {
        $this->load->helper('form');
        $this->load->library('form_validation');

        $data['title'] = 'Editar noticia';

        $this->form_validation->set_rules('title', 'Title', 'required');
        $this->form_validation->set_rules('text', 'Text', 'required');

        if ($this->form_validation->run() === FALSE)
        {
            $this->load->view('templates/header', $data);
            $this->load->view('news/update');
            $this->load->view('templates/footer');

        }
        else
        {

            $this->news_model->update_news($id);
            $this->load->view('news/success');
        }
    }

View

<?php
  function showComplete()
  {
    echo site_url('news/'.$news_item['slug']);
  }

?>
<?php foreach ($news as $news_item): ?>

<h3><?php echo $news_item['title']; ?></h3>
<div class="main">
  <?php echo $news_item['text']; ?>
</div>

 <p>
    <a href="<?php echo site_url('news/'.$news_item['slug']); ?>" class="btn btn-primary">Ver Noticia</a>
    <a href="<?php echo site_url('news/update/'.$news_item['id']); ?>" class="btn btn-warning">Actualizar</a>
    <a href="<?php echo site_url('news/delete/'.$news_item['id']); ?>" class="btn btn-danger">Borrar</a>
 </p> 

<?php endforeach; ?>

    <a href="<?php echo site_url('news/create'); ?>" class="btn btn-default"> Nueva noticia</a>

------edit-------

Now I do not have errors, thanks guys, but now I think that my form_open from my update page is missing the variable passing, how can I make that the form pass the ID to my model?

update view

<h2><?php echo $title; ?></h2>

<?php echo validation_errors(); ?>

<?php echo form_open('news/update/'); ?>

    <div class="col-md-8">
        <label for="title">Title</label>
        <input type="input" name="title" class="form-control"> <br>

        <label for="text">Text</label>
        <textarea  class="form-control" name="text" id="" cols="30" rows="10"></textarea> <br>

        <input class="btn btn-primary" type="submit" name="submit" value="Create new item">
    </div>

</form>

Answer 1

you have to pass the data of your input to update news model , Always follow the MVC structure . because code igniter is MVC Framework.

public function update($id)
{
    $this->load->helper('form');
    $this->load->library('form_validation');
    $this->load->helper('url');

    $data['title'] = 'Editar noticia';

    $this->form_validation->set_rules('title', 'Title', 'required');
    $this->form_validation->set_rules('text', 'Text', 'required');

    if ($this->form_validation->run() === FALSE)
    {
        $this->load->view('templates/header', $data);
        $this->load->view('news/update');
        $this->load->view('templates/footer');

    }
    else
    {
        $slug = url_title($this->input->post('title'),'dash',TRUE); // i dont know about this slug. that you were using for what?
        $data = array(
           'title' => $this->input->post('title'),
           'text' => $this->input->post('text')
        );
        $this->news_model->update_news($id,$data);
        $this->load->view('news/success');
    }
}

and your model function will look like this

public function update_news($id,$data)
{
    $this->db->where('id', $id);
    return $this->db->update('news', $data);
}