array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'zh', ), 'this' => array ( 0 => 'mysql-xdevapi-collection.removeone.php', 1 => 'Collection::removeOne', ), 'up' => array ( 0 => 'class.mysql-xdevapi-collection.php', 1 => 'mysql_xdevapi\\Collection', ), 'prev' => array ( 0 => 'mysql-xdevapi-collection.remove.php', 1 => 'Collection::remove', ), 'next' => array ( 0 => 'mysql-xdevapi-collection.replaceone.php', 1 => 'Collection::replaceOne', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/mysql_xdevapi/mysql_xdevapi/collection/removeone.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(No version information available, might only be in Git)
Collection::removeOne — Remove one collection document
Remove one document from the collection with the correspending ID.
This is a shortcut for Collection.remove("_id = :id").bind("id", id).execute()
.
id
The ID of the collection document to remove. Typically this is the _id that was generated by MySQL Server when the record was added.
A Result object that can be used to query the number of affected items or the number warnings generated by the operation.
示例 #1 mysql_xdevapi\Collection::removeOne() 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");
$collection = $schema->createCollection("people");
$result = $collection->add('{"name": "Alfred", "age": 18, "job": "Butler"}')->execute();
// Normally the _id is known by other means,
// but for this example let's fetch the generated id and use it
$ids = $result->getGeneratedIds();
$alfred_id = $ids[0];
$result = $collection->removeOne($alfred_id);
if(!$result->getAffectedItemsCount()) {
echo "Alfred with id $alfred_id was not removed.";
} else {
echo "Goodbye, Alfred, you can take _id $alfred_id with you.";
}
?>
以上示例的输出类似于:
Goodbye, Alfred, you can take _id 00005b6b536100000000000000cb with you.