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