->insert()
Inserts one or multiple records in the database.
Method Syntax$db->insert(thing, data)
Arguments
| Arguments | Description | ||
|---|---|---|---|
thing | The table name or | ||
data | Either a single document/record or an array of documents/records to insert |
Example usage
// Insert a single record
[$person] = $db->insert('person', [
"name" => 'Tobie',
"settings" => [
"active" => true,
"marketing" => true,
],
]);
$person = $db->insert(new RecordId('person', 'tobie'), [
"name" => 'Tobie',
"settings" => [
"active" => true,
"marketing" => true,
],
]);
// Insert multiple records
$people = $db->insert('person', [
[
"name" => 'Tobie',
"settings" => [
"active" => true,
"marketing" => true,
],
],
[
"name" => 'Jaime',
"settings" => [
"active" => true,
"marketing" => true,
],
],
]);
// The content you are creating the record with might differ from the return type
$people = $db->insert('person', [
[ "name" => 'Tobie' ],
[ "name" => 'Jaime' ],
]);
Translated query
This function will run the following query in the database.
INSERT INTO $thing $data;