phpCI框架插入一条或多条sql记录示例

1、插入一条记录

$data=array(
"title"=>"Mytitle",
"name"=>"MyName",
"date"=>"Mydate"
);

$this->db->insert("mytable",$data);

//Produces:INSERTINTOmytable(title,name,date)VALUES("Mytitle","Myname","Mydate")

2、插入多条记录

$data=array(
array(
"title"=>"Mytitle",
"name"=>"MyName",
"date"=>"Mydate"
),
array(
"title"=>"Mytitle1",
"name"=>"MyName1",
"date"=>"Mydate1"
)
);

$this->db->insert_batch("mytable",$data);

//Produces:INSERTINTOmytable(title,name,date)VALUES("Mytitle","Myname","Mydate")，("Mytitle1","Myname1","Mydate1")