Welcome Guest, Not a member yet? Register   Sign In
duplicates when using database update
#1

[eluser]Unknown[/eluser]
Hi.

I have a strange issue here.

can't find anything about it on google or the forum and first time i got this problem with CI.

When i update one of my post from my MySQL DB it makes a duplicate of it and add a new row, it does not take all the info because i don't need to change that.

my code is this

Code:
//model
function edit($options = array(), $site, $edit = FALSE)
    {
if(!$edit)
{
     $db = $this->__dataaseConnection($site);
     $db->select('*');
     $query = $db->get_where('news', array('id'=> $options['id']));
     return $query->result();
}
elseif($edit)
{
     $data = array(
    'headline' => $options['headline'],
    'text' => $options['text'],
    'status' => $options['status']
     );
     $db = $this->__dataaseConnection($site);
     $db->update('news', $data, array('id' => $id));
     redirect('/news/list_entries/' . $site);
}
    }

Code:
//Controller
function edit()
    {
$options = array(
   'headline' => $this->input->post('headline'),
   'text' => $this->input->post('text'),
   'status' => $this->input->post('status'),
   'id' => $this->uri->segment(4)
);

$data['current_view'] = 'news_view';
$this->load->model('news_model');
$data['news'] = $this->news_model->edit($options, $this->uri->segment(3), FALSE);

$this->form_validation->set_rules('headline', 'Headline', 'required');
$this->form_validation->set_rules('text', 'Text', 'required');


if($this->form_validation->run() == TRUE)
{
     $this->load->model('news_model');
     $data['news'] = $this->news_model->add($options, $this->uri->segment(3), TRUE);
}
$this->load->view('includes/template', $data);
    }

my form is looking like this.
http://cl.ly/3e2p0w1j1B1r083S3s38

don't ask about the language, its danish.

when i edit that 3 fields i get this output
http://cl.ly/2z011T0z0Z1p180v103I

i edit the post with ID 3, and it make a new row of that post..
why?

another database update is working just fine.




Theme © iAndrew 2016 - Forum software by © MyBB