Database: Insert

Simple Insert Clauses

The query builder also provides an insert method for inserting records into the database table. The insert method accepts an array of column names and values:

$this->db->table('users')->insert(
    ['email' => 'john@example.com', 'votes' => 0]
)->execute();

You may even insert several records into the table with a single call to insert by passing an array of arrays. Each array represents a row to be inserted into the table:

$this->db->table('users')->insert([
    ['email' => 'taylor@example.com', 'votes' => 0],
    ['email' => 'dayle@example.com', 'votes' => 0]
])->execute();

Auto-Incrementing IDs

If the table has an auto-incrementing id, pass true to the execute method to insert a record and then retrieve the ID:

$id = $this->db->table('users')->insert(
    ['email' => 'john@example.com', 'votes' => 0]
)->execute(true);