Codeigniter中的多个查询 [英] Multiple Queries in Codeigniter
问题描述
可能重复:
MYSQL在代码插入器中多次插入
我想执行在PHP中使用codeignitor框架同时进行多个插入查询。没有编写多个插入查询的简单方法,已经尝试过
$ this-> db-> query('INSERT INTO students(first_name,last_name)值
('teejay','obazee')'
('maev','shadowsong')'
('jaina','proudmore')',FALSE)
诸如此类。有什么方法是行不通的。如果有人知道,请帮帮我。
I would like to execute multiple insert queries simultaneously using codeignitor framework in PHP.There is any simple ways to do this without writing multiple insert queries.Already tried something like $this->db->query('INSERT INTO students (first_name, last_name) VALUES ('teejay', 'obazee')' ('maev', 'shadowsong')' ('jaina', 'proudmore')', FALSE) .There is any ways like this.Which is not working.If anybody knows;please help me.
推荐答案
不幸的是,您需要做类似的事情:
Unfortunately, you need to do something like:
$this->db->query("INSERT INTO `students` (`first_name`,`last_name`) VALUES ('teejay', 'obazee'),('maev', 'shadowsong'),('jaina', 'proudmore')");
或使用其他人的类来构建查询:
> http://codefury.net/2009/12/insert-multiple-将行插入具有codeigniter的数据库/
Or use someone else's class to build the query: http://codefury.net/2009/12/insert-multiple-rows-into-a-database-with-codeigniter/
这篇关于Codeigniter中的多个查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!