Example of inserting one or more SQL records in the php CI framework
This section describes how to insert one or more SQL records in the php CI framework. The sample code is as follows. Do not miss it if you are not familiar with it.
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 ('My title', 'My name', 'My date ')
2. Insert multiple records
$ 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 ')