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")