Insert Statement
Insert data in table
First parameter is the table name without table prefix.
$db::insert('querybuilder', [
[
'name' => 'Keramot UL Islam',
'email' => 'keramotul.@gmail.com',
]
])
->execute();Bulk insertion is also available.
$db::insert('querybuilder', [
[
'name' => 'Keramot UL Islam',
'email' => 'keramotul.@gmail.com',
],
[
'name' => 'CodesVault',
'email' => 'codesvault.@gmail.com',
]
])
->execute();Conditional insert with dynamic data
DB::insert('querybuilder', ['name', 'email', 'age', 'country'])
->ignoreDuplicates()
->select('name', 'email', 'age', 'country')
->from('qb_source')
->where('country', '=', 'USA')
->execute();DB::insert('querybuilder', ['name', 'email', 'age', 'country'])
->select('name', 'email', 'age', 'country')
->from('qb_source')
->whereIn('country', function ($subQuery) {
$subQuery->select('country')
->from('qb_countries');
})
->execute();