StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POwhy is my update query creating new row?
text
Body
copied!<p>I'm using codeigniter and trying to do an UPDATE query, but it keeps creating a new row like an INSERT query. I'm baffled and searching the web didn't yield much for me. (I'm a bit of a n00b). Any help would be greatly appreciated. </p> <p>Here is the form:</p> <pre><code><form action="<?=base_url();?>blog/new_post" method="post" name="write_new"> <input type="hidden" name="user" value="<?=$user?>"> <label>Title:</label><br> <input type="text" name="title" value="<?php if(isset($query->title)) { echo $query->title; }?>" size="50"><br> <label>Date:</label><br> <input type="text" name="date" size="46" value="<?php if(isset($query->date)) { echo $query->date; }?>" /> <script language="JavaScript"> new tcal ({ // javascript calender thingy // form name 'formname': 'write_new', // input name 'controlname': 'date' }); </script> <br><br> <label>Article:</label><br> <textarea name="content" style="width:100%;height:300px;"><?php if(isset($query->article)) { echo $query->article; }?></textarea><br> <select name="category"> <option value="news">Dreamsy News</option> <option value="web">From the Interwebs</option> </select> <input type="submit"/> </form> <div class="clearboth"></div> </code></pre> <p>Here's the model:</p> <pre><code>function edit_post($title, $date, $author, $article, $category, $id) { $this->load->helper('form'); //loads the CI form helper $this->load->library('form_validation'); //loads the form validation class $this->form_validation->set_rules('title', 'title', 'required|min_length[3]|max_length[40]|xss_clean'); $this->form_validation->set_rules('date', 'date', 'required|min_length[5]|max_length[15]|xss_clean'); $this->form_validation->set_rules('category', 'category', 'required|xss_clean'); $this->form_validation->set_rules('content', 'article', 'required|xss_clean'); $this->form_validation->set_rules('user', 'you are not logged in', 'required'); if ($this->form_validation->run() == FALSE) //If the form does not validate { $this->load->vars(array('title' => 'Error')); $this->template->write_view('content', 'error/new_post_fail'); $this->template->render(); } else { $article = htmlentities($article, ENT_QUOTES); /*$data = array( 'title' => $title, 'date' => $date, 'author' => $author, 'article' => $article, 'category' => $category );*/ //$this->db->where('id', $id); //$this->db->update('blog', $data); $query = 'UPDATE blog SET title = '.$title.' date = '.$date.', author = '.$author.', article = '.$article.', category = '.$category; $this->db->query($query); redirect(base_url().'blog'); } </code></pre> <p>And here's the controller:</p> <pre><code>public function write() { $id = $this->uri->segment(3); $query = 'SELECT * FROM blog WHERE id = '.$id; $query = $this->db->query($query); $query = $query->row(); $title = $query->title; $user = $this->session->userdata('user_id'); if(isset($id)){ $title = 'Edit: '.$title; } else { $title = 'Write new post'; } $vars['title'] = $title; $vars['page'] = 'blog'; $vars['user'] = $user; $vars['id'] = $id; $vars['query'] = $query; $this->load->helper('form'); //loads the CI form helper $this->load->library('form_validation'); //loads the form validation class $this->load->vars($vars); $this->template->write_view('content', 'blog/write'); $this->template->render(); } </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload