Welcome 微信登录

首页 / 网页编程 / PHP / php CI框架插入一条或多条sql记录示例

1、插入一条记录
$data = array("title" => "My title" ,"name" => "My Name" ,"date" => "My date");$this->db->insert("mytable", $data);// Produces: INSERT INTO mytable (title, name, date) VALUES ("My title", "My name", "My date")
2、插入多条记录
$data = array(array("title" => "My title" ,"name" => "My Name" ,"date" => "My date"),array("title" => "My title1" ,"name" => "My Name1" ,"date" => "My date1"));$this->db->insert_batch("mytable", $data);// Produces: INSERT INTO mytable (title, name, date) VALUES ("My title", "My name", "My date"),("My title1", "My name1", "My date1")