php实现查询mongoDB数据库中NumberLong类型的字段

php版本:php8.0

PHP 8.0.12 (cli) (built: Oct 21 2021 16:26:22) ( NTS )
Copyright (c) The PHP Group
Zend Engine v4.0.12, Copyright (c) Zend Technologies

安装的mongodb扩展:mongodb 1.16.2

mongodb

MongoDB support => enabled
MongoDB extension version => 1.16.2
MongoDB extension stability => stable
libbson bundled version => 1.24.3
libmongoc bundled version => 1.24.3
libmongoc SSL => enabled
libmongoc SSL library => OpenSSL
libmongoc crypto => enabled
libmongoc crypto library => libcrypto
libmongoc crypto system profile => disabled
libmongoc SASL => disabled
libmongoc ICU => enabled
libmongoc compression => enabled
libmongoc compression snappy => disabled
libmongoc compression zlib => enabled
libmongoc compression zstd => disabled
libmongocrypt bundled version => 1.8.1
libmongocrypt crypto => enabled
libmongocrypt crypto library => libcrypto
crypt_shared library version => unknown

Directive => Local Value => Master Value
mongodb.debug => no value => no value

代码中安装的composer包:

"mongodb/mongodb": "1.8"

以上库中都没找到封装好的转换php数字类型为mongo中NumberLong类型的内置用法,就参考扩展包中的测试用例自己封装了一下。

if(!function_exists('mongo_int64')){
    function mongo_int64(string $numberLong)
    {
        $class = Int64::class;
        $array = serialize(["integer"=>$numberLong]);
        $int64 = sprintf('C:%d:"%s":%d:{%s}', strlen($class), $class, strlen($array), $array);
        return unserialize($int64);
    }
}

使用上述转换后的类型可以根据NumberLong类型的mongo字段查询了。

$id = '1273446851718635052';
$formatIdList = [mongo_int64($id)];
$client = ApplicationContext::getContainer()->get(MongoDbClient::class);
$result = $client->database()
    ->selectCollection('gm_goods_expand')
    ->deleteMany(["goods_id" => ['$in' => $formatIdList]]);
var_dump("删除的数据量",$result->getDeletedCount());
  • 2
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值