PHP CI framework inserts one or more sql records example_PHP tutorial

Example of inserting one or more sql records in the php CI framework

This section mainly introduces how to insert one or more sql records in the php CI framework. The sample code is as follows. Friends who know it should not miss 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' )