CollectionAdd::execute
(No version information available, might only be in Git)
CollectionAdd::execute — Execute the statement
Description
The execute method is required to send the CRUD operation request to the MySQL server.
Liste de paramètres
Cette fonction ne contient aucun paramètre.
Valeurs de retour
A Result object that can be used to verify the status of the operation, such as the number of affected rows.
Exemples
Exemple #1 mysql_xdevapi\CollectionAdd::execute() example
<?php
$session = mysql_xdevapi\getSession("mysqlx://user:password@localhost");
$session->sql("DROP DATABASE IF EXISTS addressbook")->execute();
$session->sql("CREATE DATABASE addressbook")->execute();
$schema = $session->getSchema("addressbook");
$create = $schema->createCollection("people");
$collection = $schema->getCollection("people");
// Add two documents
$collection
->add('{"name": "Fred", "age": 21, "job": "Construction"}')
->execute();
$collection
->add('{"name": "Wilma", "age": 23, "job": "Teacher"}')
->execute();
// Add two documents using a single JSON object
$result = $collection
->add(
'{"name": "Bernie",
"jobs": [{"title":"Cat Herder","Salary":42000}, {"title":"Father","Salary":0}],
"hobbies": ["Sports","Making cupcakes"]}',
'{"name": "Jane",
"jobs": [{"title":"Scientist","Salary":18000}, {"title":"Mother","Salary":0}],
"hobbies": ["Walking","Making pies"]}')
->execute();
// Fetch a list of generated ID's from the last add()
$ids = $result->getGeneratedIds();
print_r($ids);
?>Résultat de l'exemple ci-dessus est similaire à :
Array
(
[0] => 00005b6b53610000000000000056
[1] => 00005b6b53610000000000000057
)
add a note
User Contributed Notes
There are no user contributed notes for this page.
