在CodeIgniter中插入重复数据 [英] duplicate data insert in CodeIgniter
问题描述
我只是在codebin控制器部分中在pastebin中插入数据 http://pastebin.com/KBtqrAkZ
public function add_product()
{
$ this-> lang-> load('log_in' , '英语');
log_in_check($ this-> lang-> line('log_in_authentication_error'),'admin / log_in');
$ this-> lang-> load('common','english');
$ data ['title'] = $ this-> lang->行('admin_index_title');
$ this-> load-> view('admin_template / header',$ data);
$ this-> load-> view('admin_template / left_menu');
$ data ['error_msg'] ='';
if($ this-> form_validation-> run('add_product')=== TRUE)
{
$ this-> admin_model-> add_product($ this-> ; input-> post());
$ this-> session-> set_flashdata('status_msg',$ this-> lang-> line('add_product_success'));
redirect(uri_string(),'refresh');
exit;
$ data ['error_msg'] = $ this-> lang-> line('add_product_invalid_data');
}
$ this-> load-> view('admin / add_product');
// $ this-> load-> view('admin_template / notification');
$ this-> load-> view('admin_template / footer');
}
比我的模型部分简单在pastebin添加 http://pastebin.com/WiLHV2sr
public function add_product($ data = array())
{
$ this-> db-> insert('ishop_product',$ data);
return $ this-> db-> insert_id();
}
我的问题是重定向后,如果我按ctrl + F5或F5比数据正在插入。我是一个新的codeigniter。请帮帮我。
这是双提交问题。
有几种处理方式:
-
帖子/重定向/获取模式 :中断后退按钮,它不会保留您的用户从回去足够再提交。
-
禁用提交按钮:在某些时候处理多次点击,
-
在会话中存储令牌 :如果在浏览器中打开了多个选项卡,会话中存储的令牌可能会混淆。 (注意:您可以使用创建特定于浏览器标签的Cookie )
-
更改数据库不允许重复:最好的解决方案,最努力。
-
在会话中:选项3上的变体。如果将所有生成的令牌存储在会话中,则不需要涉及数据库。重复的概率要低得多,因为令牌在会话中是唯一的。可能的问题包括令牌生长失控。也许可以修复有限大小的堆栈,你添加到堆栈的顶部,额外的令牌从底部掉下来。未测试。
-
strong>唯一事务ID 方法。它的工作原理如下:
-
生成随机
transaction_id
在您的网络表单。 -
当您收到添加产品的请求时, 检查用于事务表中的
transaction_id
。 -
如果表中的不存在,请执行事务,并将transaction_id插入表中。
-
如果表格中存在 ,表示交易已完成。
您还应搜索 [双提交-prevention] ,看看是否可以找到更好的解决方案。
I am just inserting data in codeigniter controller part at pastebin http://pastebin.com/KBtqrAkZ
public function add_product()
{
$this->lang->load('log_in', 'english');
log_in_check($this->lang->line('log_in_authentication_error'), 'admin/log_in');
$this->lang->load('common', 'english');
$data['title'] = $this->lang->line('admin_index_title');
$this->load->view('admin_template/header', $data);
$this->load->view('admin_template/left_menu');
$data['error_msg'] = '';
if ($this->form_validation->run('add_product') === TRUE)
{
$this->admin_model->add_product($this->input->post());
$this->session->set_flashdata('status_msg', $this->lang->line('add_product_success'));
redirect(uri_string(), 'refresh');
exit ;
$data['error_msg'] = $this->lang->line('add_product_invalid_data');
}
$this->load->view('admin/add_product');
//$this->load->view('admin_template/notification');
$this->load->view('admin_template/footer');
}
Than my model part is simple add at pastebin http://pastebin.com/WiLHV2sr
public function add_product($data = array())
{
$this->db->insert('ishop_product', $data);
return $this->db->insert_id();
}
my problem is after redirecting if I press ctrl + F5 or F5 than the data is inserting. I am a new in codeigniter. Help me please. Any help will be greatly appreciated.
This is the Double Submit Problem.
There are several ways of dealing with it:
The Post / Redirect / Get pattern: Breaks the back button, and it does not keep your user from going back far enough to submit again. Does not handle multiple clicks.
Disable the submit button: Handles multiple clicks some of the time, but does not fix the user going back and submitting again.
Store a token in the session: If you have multiple tabs open in the browser, the token stored in the session may get mixed up. (Note: It may be possible to create browser tab specific cookies using javascript, but I have not tried it myself.)
Change the database to not allow duplicates: The best solution, but also the most effort. If it detects a set of duplicate data, ignore the second request.
Unique transaction id: Described on this PHP hacks page, and on this answer.
Multiple tokens in the session: A variation on option 3. If you store all generated tokens in the session, you don't need to involve the database. The probability of a duplicate is much lower, given that tokens are unique inside a session. Possible problems include the set of tokens growing out of control. Maybe fixable with a limited size stack where you add to the top of the stack, and extra tokens fall off the bottom. Untested.
--
I like the unique transaction id method. It works like this:
Generate a random
transaction_id
and put it in your web form. It goes along when the user clickssubmit
.When you receive the request to add a product, check for the
transaction_id
in the transaction table.If the id does not exist in the table, do the transaction, and insert the transaction_id into the table.
If the id does exist in the table, the transaction is already done.
You should also search for [double-submit-prevention] in to see if you can find an even better solution.
这篇关于在CodeIgniter中插入重复数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!