PHP CI Framework inserts one or more SQL Records Example _php tutorial

PHP CI Framework inserts one or more SQL record examples

This section is mainly about how the PHP CI framework inserts one or more SQL records, the sample code below, do not know friends do not 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 (' My 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 (' My title ', ' My Name ', ' My Date '), (' My title1 ', ' My name1 ', ' My date1 ')

http://www.bkjia.com/PHPjc/852828.html www.bkjia.com true http://www.bkjia.com/PHPjc/852828.html techarticle PHP CI Framework inserts one or more SQL record examples This section is mainly about how the PHP CI framework inserts one or more SQL records, the sample code below, do not know the friend do not miss ...

