PHP CI Framework inserts one or more SQL Records sample

This section mainly introduces how the PHP CI framework inserts one or more SQL records, the example code is as follows, don't know friends don't miss

1. Insert a record

$data = Array (

' title ' => ' My title ',

' Name ' => ' My Name ',

' Date ' => ' My Date '

);

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

Produces:insert into MyTable (title, name, date) VALUES (' I title ', ' My Name ', ' My Date ')

2, insert more than one record

$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 (' I title ', ' My Name ', ' My Date '), ("My Title1", ' My name1 ', ' My Date1 ')