(No version information available, might only be in Git)
CollectionModify::arrayInsert โ ้ ๅใฎใใฃใผใซใใซ่ฆ็ด ใๆฟๅ ฅใใ
$collection_field, string $expression_or_literal): mysql_xdevapi\CollectionModifyใใญใฅใกใณใใฎใใฃใผใซใใซ่ฆ็ด ใ่ฟฝๅ ใใพใใ ใใฃใผใซใใฎ่คๆฐใฎ่ฆ็ด ใฏ้ ๅใจใใฆ่กจ็พใใใพใใ mysql_xdevapi\CollectionModify::arrayAppend() ใจ็ฐใชใใใใฎใกใฝใใใฏๆฐใใ่ฆ็ด ใใฉใใซๆฟๅ ฅใใใใๆๅฎใงใใพใใๅธธใซๆฐใใ่ฆ็ด ใ้ ๅใฎๆๅพใซ่ฟฝๅ ใใพใใ ไธๆนใงใmysql_xdevapi\CollectionModify::arrayAppend() ใฏๆฐใใ่ฆ็ด ใๅธธใซ้ ๅใฎๆๅพใซ่ฟฝๅ ใใพใใ
collection_field
ๆฐใใ่ฆ็ด ใๆฟๅ
ฅใใใ้
ๅไธญใฎ่ฆ็ด ใ่ญๅฅใใพใใ
ใใฎใใฉใกใผใฟใฎใใฉใผใใใใฏ FIELD_NAME[ INDEX ] ใงใใ
FIELD_NAME ใฏใ่ฆ็ด ใๅ้คใใใใญใฅใกใณใใใฃใผใซใใฎๅๅใงใ
INDEX ใฏใใฃใผใซใๅ
ใฎ่ฆ็ด ใฎใคใณใใใฏในใงใใ
INDEX ใใฃใผใซใใฏ0ใใๅงใพใใพใใ ใใฃใฆใ้ ๅใฎๆๅใฎใคใณใใใฏในใฏ0ใงใใ
expression_or_literalFIELD_NAME[ INDEX ] ใฎๅพใซๆฟๅ ฅใใๆฐใใ่ฆ็ด
ใณใใณใใๅฎ่กใใใใ่ฟฝๅ ใฎๆไฝใ่ฟฝๅ ใงใใ CollectionModify ใชใใธใงใฏใใ่ฟใใพใใ
ไพ1 mysql_xdevapi\CollectionModify::arrayInsert() ใฎไพ
<?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 in ('Bernie', 'Jane')")
->arrayInsert('traits[1]', 'Happy')
->execute();
$result = $collection
->find()
->execute();
print_r($result->fetchAll());
?>ไธใฎไพใฎๅบๅใฏใ ใใจใใฐไปฅไธใฎใใใซใชใใพใใ
Array
(
[0] => Array
(
[_id] => 00005b6b5361000000000000010d
[name] => Bernie
[traits] => Array
(
[0] => Friend
[1] => Happy
[2] => Brother
[3] => Human
)
)
)