MongoDB - 帮我创建一个PHP查询

I have the following db entry:

{
   "_id": ObjectId("4d2339f9772c4bae5403dd47"),
   "uname": "Eamorr",
   "posts": {
     "0": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1294154233,
       "UTC": "2011-01-04T15: 17: 13+00: 00",
       "ip": "134.226.1.229",
       "id": "974vi95ljn5aa22ykd21"
    },
     "1": {
       "comment": "wddddd",
       "fromUname": "Anonymous",
       "time": 1294154360,
       "UTC": "2011-01-04T15: 19: 20+00: 00",
       "ip": "134.226.1.229",
       "id": "519fy1sj6f8mc4ws8v1y"
    },
     "2": {
       "comment": "asdf2",
       "fromUname": "Anonymous",
       "time": 1294162680,
       "UTC": "2011-01-04T17: 38: 00+00: 00",
       "ip": "86.40.63.120",
       "id": "ho27be183q3kqxi2w618"
    },
     "3": {
       "comment": "asdf3",
       "fromUname": "Anonymous",
       "time": 1294162759,
       "UTC": "2011-01-04T17: 39: 19+00: 00",
       "ip": "86.44.19.49",
       "id": "bib1184hb8e90f67zhac"
    },
     "4": {
       "comment": "Eamonn",
       "fromUname": "Anonymous",
       "time": 1294162884,
       "UTC": "2011-01-04T17: 41: 24+00: 00",
       "ip": "86.44.19.49",
       "id": "rbq18o0r73mdfc8a023n"
    },
     "5": {
       "comment": "Eamonn2",
       "fromUname": "Anonymous",
       "time": 1294162967,
       "UTC": "2011-01-04T17: 42: 47+00: 00",
       "ip": "86.44.19.49",
       "id": "p1210t688d0g5c0t97jx"
    },
     "6": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1294235472,
       "UTC": "2011-01-05T13: 51: 12+00: 00",
       "ip": "134.226.1.229",
       "id": "y128u1m57bw1n711gr8o"
    },
     "7": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1294235557,
       "UTC": "2011-01-05T13: 52: 37+00: 00",
       "ip": "134.226.1.229",
       "id": "5g1xc51mm057p39c5l1p"
    },
     "8": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1294235617,
       "UTC": "2011-01-05T13: 53: 37+00: 00",
       "ip": "134.226.1.229",
       "id": "m35g1ug0220g82lq8z31"
    },
     "9": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1294240505,
       "UTC": "2011-01-05T15: 15: 05+00: 00",
       "ip": "134.226.1.229",
       "id": "i9ngh02d8ifg464088x2"
    },
     "10": {
       "comment": "boards.ie",
       "fromUname": "Anonymous",
       "time": 1294240542,
       "UTC": "2011-01-05T15: 15: 42+00: 00",
       "ip": "134.226.1.229",
       "id": "vcu1ks7ev1swaeu6z2r4"
    },
     "11": {
       "comment": "Hello",
       "fromUname": "Eamorr",
       "time": 1295618860,
       "UTC": "2011-01-21T14: 07: 40+00: 00",
       "ip": "134.226.252.160",
       "id": "00kk05gp258clzk15mxs"
    },
     "12": {
       "comment": "asdf",
       "fromUname": "Eamorr",
       "time": 1295624407,
       "UTC": "2011-01-21T15: 40: 07+00: 00",
       "ip": "212.129.64.223",
       "id": "6knwupaws7641a7fvsq2"
    },
     "13": {
       "comment": "asdf",
       "fromUname": "Eamorr",
       "time": 1295624465,
       "UTC": "2011-01-21T15: 41: 05+00: 00",
       "ip": "212.129.64.223",
       "id": "rl4k3i710xkwr5njq36l"
    },
     "14": {
       "comment": "Hi",
       "fromUname": "Eamorr",
       "time": 1295635332,
       "UTC": "2011-01-21T18: 42: 12+00: 00",
       "ip": "212.129.64.223",
       "id": "w2q11m6kaqdw9p8k44v4"
    },
     "15": {
       "comment": "Hello!!!",
       "fromUname": "Eamorr2",
       "time": 1296082365,
       "UTC": "2011-01-26T22: 52: 45+00: 00",
       "ip": "86.44.21.90",
       "id": "001cwy768eik620rka91"
    },
     "16": {
       "comment": "Hello",
       "fromUname": "Eamorr",
       "time": 1296280251,
       "UTC": "2011-01-29T05: 50: 51+00: 00",
       "ip": "86.44.20.113",
       "id": "0wfe8r9490lf5r1s11kv"
    },
     "17": {
       "comment": "Hello",
       "fromUname": "Eamorr",
       "time": 1298632583,
       "UTC": "2011-02-25T11: 16: 23+00: 00",
       "ip": "86.44.49.74",
       "id": "71k5cn8zrmsudy77513g"
    },
     "18": {
       "comment": "just wanted to say hi",
       "fromUname": "Anonymous",
       "time": 1299175499,
       "UTC": "2011-03-03T18: 04: 59+00: 00",
       "ip": "71.235.146.42",
       "id": "u2ejx9d812vk6147me6m"
    },
     "19": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299238987,
       "UTC": "2011-03-04T11: 43: 07+00: 00",
       "ip": "212.129.64.223",
       "id": "ibl84549kz220va052qm"
    },
     "20": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239150,
       "UTC": "2011-03-04T11: 45: 50+00: 00",
       "ip": "212.129.64.223",
       "id": "503hl41wmb73756h1oe0"
    },
     "21": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239230,
       "UTC": "2011-03-04T11: 47: 10+00: 00",
       "ip": "212.129.64.223",
       "id": "8894rpqow2i38b777cky"
    },
     "22": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239341,
       "UTC": "2011-03-04T11: 49: 01+00: 00",
       "ip": "212.129.64.223",
       "id": "37885igze3q81wcf8ko7"
    },
     "23": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239409,
       "UTC": "2011-03-04T11: 50: 09+00: 00",
       "ip": "212.129.64.223",
       "id": "3p2095098p96315u7632"
    },
     "24": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239561,
       "UTC": "2011-03-04T11: 52: 41+00: 00",
       "ip": "212.129.64.223",
       "id": "j8d79nwb65u4cl8808l8"
    },
     "25": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239727,
       "UTC": "2011-03-04T11: 55: 27+00: 00",
       "ip": "212.129.64.223",
       "id": "202ts1046jkuysd78509"
    },
     "26": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239793,
       "UTC": "2011-03-04T11: 56: 33+00: 00",
       "ip": "212.129.64.223",
       "id": "6ye47y3tr9syt20k5kgp"
    },
     "27": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299239830,
       "UTC": "2011-03-04T11: 57: 10+00: 00",
       "ip": "212.129.64.223",
       "id": "55g039yzp4013bk4aqtr"
    },
     "28": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299240076,
       "UTC": "2011-03-04T12: 01: 16+00: 00",
       "ip": "212.129.64.223",
       "id": "8w7sy170dku4y9o06d1g"
    },
     "29": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299240113,
       "UTC": "2011-03-04T12: 01: 53+00: 00",
       "ip": "212.129.64.223",
       "id": "1noki588r7796v5mti2f"
    },
     "30": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299240152,
       "UTC": "2011-03-04T12: 02: 32+00: 00",
       "ip": "212.129.64.223",
       "id": "l175d3aew064feaw9126"
    },
     "31": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299240245,
       "UTC": "2011-03-04T12: 04: 05+00: 00",
       "ip": "212.129.64.223",
       "id": "5rpz421351p7qrv5o7rk"
    },
     "32": {
       "comment": "Hello2",
       "fromUname": "Anonymous",
       "time": 1299240280,
       "UTC": "2011-03-04T12: 04: 40+00: 00",
       "ip": "212.129.64.223",
       "id": "n031287n17eo14v9tuda"
    },
     "33": {
       "comment": "Hello",
       "fromUname": "Anonymous",
       "time": 1299240365,
       "UTC": "2011-03-04T12: 06: 05+00: 00",
       "ip": "212.129.64.223",
       "id": "609773uq8rsv5vuw4s0k"
    },
     "34": {
       "comment": "Hello2",
       "fromUname": "Anonymous",
       "time": 1299240406,
       "UTC": "2011-03-04T12: 06: 46+00: 00",
       "ip": "212.129.64.223",
       "id": "57w4v64ekl76np304d9k"
    },
     "35": {
       "comment": "Hello3",
       "fromUname": "Anonymous",
       "time": 1299240441,
       "UTC": "2011-03-04T12: 07: 21+00: 00",
       "ip": "212.129.64.223",
       "id": "7v6agdd2xdgm2zyya5pb"
    },
     "36": {
       "comment": "Hello",
       "fromUname": "Eamorr",
       "time": 1299241138,
       "UTC": "2011-03-04T12: 18: 58+00: 00",
       "ip": "212.129.64.223",
       "id": "1qp2a2837x31791xxg0s"
    },
     "37": {
       "comment": "asdf",
       "fromUname": "Eamorr",
       "time": 1299241395,
       "UTC": "2011-03-04T12: 23: 15+00: 00",
       "ip": "212.129.64.223",
       "id": "x7app929kw9l4p1bk977"
    },
     "38": {
       "comment": "lkjh",
       "fromUname": "Anonymous",
       "time": 1299241477,
       "UTC": "2011-03-04T12: 24: 37+00: 00",
       "ip": "212.129.64.223",
       "id": "ea9ws389971pmt6waee8"
    },
     "39": {
       "comment": "Hello",
       "fromUname": "Eamorr",
       "time": 1299244791,
       "UTC": "2011-03-04T13: 19: 51+00: 00",
       "ip": "212.129.64.223",
       "id": "bfk9tm2gt6z254739z08"
    },
     "40": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1299249252,
       "UTC": "2011-03-04T14: 34: 12+00: 00",
       "ip": "212.129.64.223",
       "id": "ufaf48c1qd1e0n07s8m5"
    },
     "41": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1299250483,
       "UTC": "2011-03-04T14: 54: 43+00: 00",
       "ip": "212.129.64.223",
       "id": "3k65kne9h0pk410xzc0p"
    },
     "42": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1299251270,
       "UTC": "2011-03-04T15: 07: 50+00: 00",
       "ip": "212.129.64.223",
       "id": "t7740r0fcby6gowlw9xk"
    },
     "43": {
       "comment": "Hi, how's it going?",
       "fromUname": "Eamorr",
       "time": 1299683127,
       "UTC": "2011-03-09T15: 05: 27+00: 00",
       "ip": "212.129.64.223",
       "id": "9l864xc2agxsdjo4257y"
    },
     "44": {
       "comment": "3hvdn",
       "fromUname": "Anonymous",
       "time": 1299683730,
       "UTC": "2011-03-09T15: 15: 30+00: 00",
       "ip": "212.129.64.223",
       "id": "4frfsf12xwz1to9po0w3"
    },
     "45": {
       "comment": "Hi there",
       "fromUname": "Anonymous",
       "time": 1299684889,
       "UTC": "2011-03-09T15: 34: 49+00: 00",
       "ip": "212.129.64.223",
       "id": "hw4i9mk906n1qvg63o2d"
    },
     "46": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1313371240,
       "UTC": "2011-08-15T02: 20: 40+01: 00",
       "ip": "212.129.66.130",
       "id": "0f4o199394hzqyv6by89"
    },
     "47": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1313430246,
       "UTC": "2011-08-15T18: 44: 06+01: 00",
       "ip": "212.129.66.131",
       "id": "73xbuqwauhls17cb3dc3"
    },
     "48": {
       "comment": "vvvvvvvv",
       "fromUname": "Anonymous",
       "time": 1313430944,
       "UTC": "2011-08-15T18: 55: 44+01: 00",
       "ip": "212.129.66.131",
       "id": "44dw9427805j93g51u2h"
    },
     "49": {
       "comment": "vvvvvvvv",
       "fromUname": "Anonymous",
       "time": 1313431402,
       "UTC": "2011-08-15T19: 03: 22+01: 00",
       "ip": "212.129.66.131",
       "id": "lo1n5i2qpxa562o606hd"
    },
     "50": {
       "comment": "vvvvvvvv",
       "fromUname": "Anonymous",
       "time": 1313431865,
       "UTC": "2011-08-15T19: 11: 05+01: 00",
       "ip": "212.129.66.131",
       "id": "fu01r3z2vk12ar0avk65"
    },
     "51": {
       "comment": "xxxxccccc",
       "fromUname": "Anonymous",
       "time": 1313432538,
       "UTC": "2011-08-15T19: 22: 18+01: 00",
       "ip": "212.129.66.131",
       "id": "1fk5u60nkok8hyuzd0e6"
    },
     "52": {
       "comment": "xxxxccccc",
       "fromUname": "Anonymous",
       "time": 1313432587,
       "UTC": "2011-08-15T19: 23: 07+01: 00",
       "ip": "212.129.66.131",
       "id": "x20adl504ur7652r7x7b"
    },
     "53": {
       "comment": "'cccccccccccvvvvv",
       "fromUname": "Anonymous",
       "time": 1313432791,
       "UTC": "2011-08-15T19: 26: 31+01: 00",
       "ip": "212.129.66.131",
       "id": "nwk0m8lq7cc3s9748cve"
    },
     "54": {
       "comment": "aaaassss",
       "fromUname": "Anonymous",
       "time": 1313432849,
       "UTC": "2011-08-15T19: 27: 29+01: 00",
       "ip": "212.129.66.131",
       "id": "99fj5rl2ne7hzr78c691"
    },
     "55": {
       "comment": "asdffffffff",
       "fromUname": "Anonymous",
       "time": 1313477562,
       "UTC": "2011-08-16T07: 52: 42+01: 00",
       "ip": "212.129.66.131",
       "id": "y81iemo7t501dlwo3e52"
    },
     "56": {
       "comment": "Charlie",
       "fromUname": "Anonymous",
       "time": 1313525636,
       "UTC": "2011-08-16T21: 13: 56+01: 00",
       "ip": "212.129.66.130",
       "id": "k6bi9czy2g1941c7cid5"
    },
     "57": {
       "comment": "asdf",
       "fromUname": "Anonymous",
       "time": 1314036401,
       "UTC": "2011-08-22T19: 06: 41+01: 00",
       "ip": "212.129.66.131",
       "id": "zs4v1f7sr82f106p42gr"
    },
     "58": {
       "comment": "asdf2",
       "fromUname": "Anonymous",
       "time": 1314036666,
       "UTC": "2011-08-22T19: 11: 06+01: 00",
       "ip": "212.129.66.131",
       "id": "jg3y5xwilljq6hi7mpwd"
    },
     "59": {
       "comment": "qwerty",
       "fromUname": "Eamorr",
       "time": 1314550970,
       "UTC": "2011-08-28T18: 02: 50+01: 00",
       "ip": "212.129.66.131",
       "id": "uvoh7abs5u2kfogb28kr"
    },
     "60": {
       "comment": "qwerty",
       "fromUname": "Eamorr",
       "time": 1314551143,
       "UTC": "2011-08-28T18: 05: 43+01: 00",
       "ip": "212.129.66.131",
       "id": "u6eqi91y539mgv2ufxfw"
    },
     "61": {
       "comment": "qwerty2",
       "fromUname": "Eamorr",
       "time": 1314551158,
       "UTC": "2011-08-28T18: 05: 58+01: 00",
       "ip": "212.129.66.130",
       "id": "1dxz445s16qi17020y26"
    },
     "62": {
       "comment": "jacks",
       "fromUname": "Eamorr",
       "time": 1314633471,
       "UTC": "2011-08-29T16: 57: 51+01: 00",
       "ip": "212.129.66.131",
       "id": "3nkq2cxq2okb205z9ao6"
    }
  }
}

I'm trying to remove an entry according to 'id'.

So, given id "3nkq2cxq2okb205z9ao6" (which happens to be the last entry, #62), how can I update this mongo collection to remove element 62?

I'm really stuck. I saw similar stackoverflow questions, but I really need something specific to this problem.

Any insight greatly appreciated.

Many thanks in advance,

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

3条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
dongyuchen9276 2011-08-30 11:25
关注
If the ID we are talking about is a MongoId (auto-created) then you should use;

$collection->remove(array('id' => new MongoId('3nkq2cxq2okb205z9ao6')), true);

but if id field is something you randomly generated then following code is good to go;

$collection->remove(array('id' => '3nkq2cxq2okb205z9ao6'));

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(2条)

报告相同问题？

关注问题

yum mongodb 失败未找到匹配的参数: mongodb-org centos linux mongodb
2022-09-09 17:31

回答 1 已采纳推荐使用源码包安装，yum安装不利于维护可以参考文章：https://blog.csdn.net/chj_1224365967/article/details/106857626
PHP 7 MongoDB - 删除所有数据库 mongodb php
2017-10-30 10:15

回答 1 已采纳 The method to drop is actually on MongoClient, and of course there is getName() from the MongoDB\M
AuthenticationFailed：分片MongoDB上的用户文档中缺少MONGODB-CR凭据：无法连接到：queryrouter0.example.com:27017： laravel mongodb php
2017-09-05 14:11

回答 2 已采纳 I worked out my laravel-mongodb install was version 2 which doesn't support the SCRAM-SHA-1 authen
PHP操作MONGODB详细文档 WORD版
2022-05-26 12:28

MongoDB是一个高性能、开源、无模式的分布式文档型数据库，它以其灵活性和可扩展性受到青睐。而PHP作为服务器端脚本语言，因其易学易用性而广受欢迎，因此将PHP与MongoDB结合，可以构建高效的数据驱动应用。本文档...
在mongodb-go-driver中通过子字符串正则表达式查询查找条目 mongodb
2019-03-28 13:25

回答 1 已采纳 primitive.Regex struct accepts Pattern value without slashes, so it must be: filter := bson.D{{"t
无法使用Composer安装doctrine / mongodb-odm mongodb php
2013-03-19 17:38

回答 2 已采纳 Turns out this was the fault of the Sublime Text 2 Composer plugin. If I run Coomposer via Termina
PHP和MongoDB - 高级查询 mongodb php
2012-04-13 08:44

回答 1 已采纳 If you are using a standard, auto-generated default '_id' primary field, that is timestamp based.
Laravel开发-laravel-mongodb-session
2019-08-28 07:45

Laravel是一个流行的PHP框架，以其优雅的语法和强大的功能而受到开发者的喜爱。MongoDB则是一种非关系型数据库系统，因其灵活的数据模型和高性能而在大数据和实时应用中广泛应用。 ### 1. Laravel 会话机制 ...
编写一个php文件，将文档添加到mongoDB集合中 mongodb php
2019-02-27 12:40

回答 1 已采纳 Fixed. Got it to work with: try { $collection->insertOne($document); } catch (\Exce
PHP和MongoDB - 查询数组 mongodb php
2012-04-17 03:40

回答 1 已采纳 Your syntax is not correct, you should simply do: $cursor = $coll->find(array( 'loc' =>
浮点PHP - MongoDB mongodb php symfony
2016-05-31 09:32

回答 1 已采纳 It seems the app i'm using to show the contents of my database has issues with showing it correctl
php5.3.* memcache-mongodb-redis dll扩展
2013-10-16 14:46

标题中的“php5.3.* memcache-mongodb-redis dll扩展”表明了这是一个关于PHP5.3版本的扩展包，其中包含了对memcache、mongodb和redis数据库的支持。这些DLL文件是Windows平台上PHP运行时需要的动态链接库，用于增强...
Laravel开发-laravel-mongodb-queue
2019-08-27 18:48

Laravel是一个流行的PHP框架，它提供了强大的工具来简化Web应用的开发，而MongoDB是一种非关系型数据库，以其灵活性和高性能著称，尤其适合处理大数据和实时应用。首先，安装`jenssegers/laravel-mongodb`扩展库，...
php操作mongoDB实例分析
2020-10-24 23:52

MongoDB是一个面向文档的NoSQL数据库系统，它以类似JSON的BSON...对于需要高性能和高可用性的Web应用和大数据应用来说，MongoDB是一个非常不错的选择。通过PHP API对MongoDB进行操作，使得开发过程更为简单和直接。
mongodb和php的用法详解
2020-10-17 06:20

首先，需要在PHP代码中创建一个新的MongoDB实例。如果使用默认连接本机的27017端口，可以简单地创建实例而不带任何参数。如果要连接远程主机，可以指定主机地址和端口号。此外，还可以在连接字符串中包含用户名和...
没有解决我的问题, 去提问

悬赏问题

¥15 如何让企业微信机器人实现消息汇总整合
¥50 关于#ui#的问题：做yolov8的ui界面出现的问题
¥15 如何用Python爬取各高校教师公开的教育和工作经历
¥15 TLE9879QXA40 电机驱动
¥20 对于工程问题的非线性数学模型进行线性化
¥15 Mirare PLUS 进行密钥认证？（详解）
¥15 物体双站RCS和其组成阵列后的双站RCS关系验证
¥20 想用ollama做一个自己的AI数据库
¥15 关于qualoth编辑及缝合服装领子的问题解决方案探寻
¥15 请问怎么才能复现这样的图呀

MongoDB - 帮我创建一个PHP查询

3条回答 默认 最新

悬赏问题

3条回答默认最新