array ( 0 => 'index.php', 1 => 'PHP Manual', ), 'head' => array ( 0 => 'UTF-8', 1 => 'zh', ), 'this' => array ( 0 => 'mysql-xdevapi-collectionmodify.bind.php', 1 => 'CollectionModify::bind', ), 'up' => array ( 0 => 'class.mysql-xdevapi-collectionmodify.php', 1 => 'mysql_xdevapi\\CollectionModify', ), 'prev' => array ( 0 => 'mysql-xdevapi-collectionmodify.arrayinsert.php', 1 => 'CollectionModify::arrayInsert', ), 'next' => array ( 0 => 'mysql-xdevapi-collectionmodify.construct.php', 1 => 'CollectionModify::__construct', ), 'alternatives' => array ( ), 'source' => array ( 'lang' => 'en', 'path' => 'reference/mysql_xdevapi/mysql_xdevapi/collectionmodify/bind.xml', ), ); $setup["toc"] = $TOC; $setup["toc_deprecated"] = $TOC_DEPRECATED; $setup["parents"] = $PARENTS; manual_setup($setup); ?>
(No version information available, might only be in Git)
CollectionModify::bind — Bind value to query placeholder
$placeholder_values
): mysql_xdevapi\CollectionModifyBind a parameter to the placeholder in the search condition of the modify operation.
The placeholder has the form of :NAME where ':' is a common prefix that must always exists before any NAME where NAME is the name of the placeholder. The bind method accepts a list of placeholders if multiple entities have to be substituted in the search condition of the modify operation.
placeholder_values
Placeholder values to substitute in the search condition. Multiple values are allowed and have to be passed as an array of mappings PLACEHOLDER_NAME->PLACEHOLDER_VALUE.
A CollectionModify object that can be used to execute the command, or to add additional operations.
示例 #1 mysql_xdevapi\CollectionModify::bind() 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": "Bernie",
"traits": ["Friend", "Brother", "Human"]}')
->execute();
$collection
->modify("name = :name")
->bind(['name' => 'Bernie'])
->arrayAppend('traits', 'Happy')
->execute();
$result = $collection
->find()
->execute();
print_r($result->fetchAll());
?>
以上示例的输出类似于:
Array ( [0] => Array ( [_id] => 00005b6b53610000000000000110 [name] => Bernie [traits] => Array ( [0] => Friend [1] => Brother [2] => Human [3] => Happy ) ) )