MongoDB+laravel 查询mongodb集合中数组个数

最新推荐文章于 2024-07-14 03:49:13 发布

原创最新推荐文章于 2024-07-14 03:49:13 发布 · 6.6k 阅读

1 ·

CC 4.0 BY-SA版权

php+mysql 专栏收录该内容

26 篇文章

订阅专栏

本文介绍了如何在MongoDB数据库中结合Laravel框架，通过聚合操作来计算集合内文档数组字段的元素个数，具体方法是使用$group和$count聚合函数。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

{$match: {'process.0': {$exists: true}}},
{$unwind: '$process'},
{$match: {'process.correct': 1}},

{$group: {_id: null, count: {$sum: 1}}}

$db = DB::getMongoDB();
	$collection = $db->exams;

	/*var_dump($collection);
	$document = $collection->findOne();
	var_dump( $document );*/

	$pipeline = array(
		array(
			'$match' => array('process.0' => array('$exists' => true)),
			),
		array(
			'$unwind' => '$process'
			),
		array(
			'$match' => array('process.correct' => 1),
			),
		array(
			'$group' => array(
				"_id" => null,
				"count" => array('$sum' => 1),
				),
			),

	);
	/*{$match: {'process.0': {$exists: true}}},
	{$unwind: '$process'},
	{$match: {'process.correct': 1}},
	{$group: {_id: null, count: {$sum: 1}}}*/
	$result = $collection->aggregate($pipeline);
	var_dump(array_values($result));

参考 http://php.net/manual/en/mongocollection.aggregate.php