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());

发表回复

您的电子邮箱地址不会被公开。 必填项已用 * 标注

相关文章

开始在上面输入您的搜索词,然后按回车进行搜索。按ESC取消。

返回顶部