PHP 8.5.0 Beta 3 available for testing

Collection::remove

(No version information available, might only be in Git)

Collection::remove โ€” ใ‚ณใƒฌใ‚ฏใ‚ทใƒงใƒณใ‚’ๅ‰Š้™คใ™ใ‚‹

่ชฌๆ˜Ž

public mysql_xdevapi\Collection::remove(string $search_condition): mysql_xdevapi\CollectionRemove

็‰นๅฎšใฎๆคœ็ดขๆกไปถใซๅˆ่‡ดใ™ใ‚‹ใƒ‰ใ‚ญใƒฅใƒกใƒณใƒˆใฎใ‚ณใƒฌใ‚ฏใ‚ทใƒงใƒณใ‚’ๅ‰Š้™คใ—ใพใ™ใ€‚ ่ค‡ๆ•ฐใฎๆ“ไฝœใŒๅฏ่ƒฝใงใ€ใƒ‘ใƒฉใƒกใƒผใ‚ฟใฎใƒใ‚คใƒณใƒ‰ใ‚‚ใ‚ตใƒใƒผใƒˆใ—ใฆใ„ใพใ™ใ€‚

ใƒ‘ใƒฉใƒกใƒผใ‚ฟ

search_condition

ๅ‰Š้™คใ™ใ‚‹ใƒ‰ใ‚ญใƒฅใƒกใƒณใƒˆใซ ใƒžใƒƒใƒใ•ใ›ใ‚‹ใŸใ‚ใซไฝฟใ†ใ€ๆœ‰ๅŠนใช MySQL ใฎๅผใงใชใ‘ใ‚Œใฐใชใ‚Šใพใ›ใ‚“ใ€‚ ใ“ใฎๅผใฏใ€true ใจ่ฉ•ไพกใ•ใ‚Œใ‚‹ๅ˜็ด”ใชใ‚‚ใฎใงใ‚ใ‚Œใฐๅฏ่ƒฝใงใ™ใ€‚ true ใจ่ฉ•ไพกใ•ใ‚ŒใŸๅ…จใฆใฎใƒ‰ใ‚ญใƒฅใƒกใƒณใƒˆใซใƒžใƒƒใƒใ—ใพใ™ใ€‚ ใ‚‚ใ—ใใฏใ€้–ขๆ•ฐใจๆŒ‡ๆฎใ‚’ๆฌกใฎใ‚ˆใ†ใซไฝฟใ†ใ“ใจใ‚‚ใงใใพใ™ใ€‚ 'CAST(_id AS SIGNED) >= 10', 'age MOD 2 = 0 OR age MOD 3 = 0', '_id IN ["2","5","7","10"]'.

ๆˆปใ‚Šๅ€ค

ๆ“ไฝœใŒๅฎŸ่กŒใ•ใ‚Œใชใ„ๅ ดๅˆใ€ใ“ใฎ้–ขๆ•ฐใฏ่ฟฝๅŠ ใฎๅ‰Š้™คๆ“ไฝœใ‚’่ฟฝๅŠ ใงใใ‚‹ Remove ใ‚ชใƒ–ใ‚ธใ‚งใ‚ฏใƒˆใ‚’่ฟ”ใ—ใพใ™ใ€‚

ๅ‰Š้™คๆ“ไฝœใŒๅฎŸ่กŒใ•ใ‚ŒใŸๅ ดๅˆใ€่ฟ”ใ•ใ‚Œใ‚‹ใ‚ชใƒ–ใ‚ธใ‚งใ‚ฏใƒˆใซใฏๆ“ไฝœ็ตๆžœใŒๅซใพใ‚Œใพใ™ใ€‚

ไพ‹

ไพ‹1 mysql_xdevapi\Collection::remove() 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");

$collection->add('{"name": "Alfred", "age": 18, "job": "Butler"}')->execute();
$collection->add('{"name": "Bob", "age": 19, "job": "Painter"}')->execute();

// ๅ…จใฆใฎ Painter ใ‚’ๅ‰Š้™ค
$collection
->remove("job in ('Painter')")
->
execute();

// ใ‚‚ใฃใจใ‚‚ๅคใ„ Bulter ใ‚’ๅ‰Š้™ค
$collection
->remove("job in ('Butler')")
->
sort('age desc')
->
limit(1)
->
execute();

// age ใŒไธ€็•ช้ซ˜ใ„ใƒฌใ‚ณใƒผใƒ‰ใ‚’ๅ‰Š้™ค
$collection
->remove('true')
->
sort('age desc')
->
limit(1)
->
execute();
?>
๏ผ‹add a note

User Contributed Notes

There are no user contributed notes for this page.
To Top