StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POMysql inserts blank row after inserting row with data (in Chrome)
text
Body
copied!<p><strong>Seems to be a browser issue, as in firefox it is working fine but not in chrome.</strong></p> <p>Why is it that when I submit my php form to insert data into a mysql db table, then check the table. I see my newly created row with the data in it and also an extra row with nothing in it?</p> <p><strong>My controller:</strong></p> <pre><code> function Admin() { parent::Controller(); $this->dx_auth->check_uri_permissions(); $this->load->model('alert_model'); $data['rows'] = $this->alert_model->check($num_results=4); $this->load->view('includes/header', $data); } function index() { $this->load->view('admin/notifications'); $this->load->view('includes/footer'); } function sendalert() { $info = array( 'msg_author' => $this->input->post('msg_author'), 'msg_date' => $this->input->post('msg_date'), 'msg_subject' => $this->input->post('msg_subject'), 'msg_content' => $this->input->post('msg_content') ); $this->send_notification->send($info); $this->index(); } </code></pre> <p><strong>My Model:</strong></p> <pre><code> function send($info) { $this->db->insert('msg', $info); return; } </code></pre> <p><strong>My View:</strong></p> <pre><code><?php echo form_open('admin/sendalert'); ?> <label for="msg_subject">Subject</label> <input type="text" name="msg_subject" id="msg_subject" /> <label for="msg_date">Date</label> <input type="text" name="msg_date" id="msg_date" /> <label for="msg_author">From</label> <input type="text" name="msg_author" id="msg_author" /> <label for="msg_content">Content</label> <input type="text" name="msg_content" id="msg_content" /> <input type="submit" value="submit" /> <?php echo form_close(); ?> </code></pre> <p>Thanks</p>

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