前面说到了mongodb安装,配置,集群,以及php的插入与更新等,请参考:mongodb。
下面说一下,mongodb select的常用操作
测试数据:
代码如下:
{ "_id" : 1, "title" : "红楼梦", "auther" : "曹雪芹", "typeColumn" : "test", "money" : 80, "code" : 10 }
{ "_id" : 2, "title" : "围城", "auther" : "钱钟书", "typeColumn" : "test", "money" : 56, "code" : 20 }
{ "_id" : 3, "title" : "朝发白帝城", "auther" : "李白", "typeColumn" : "test", "money" : 30, "code" : 30 }
{ "_id" : 4, "title" : "将近酒", "auther" : "李白", "money" : 90, "code" : 40 }
1、取表条数
代码如下:
> db.books.count();
4
> db.books.find().count();
4
> db.books.count({auther: "李白" });
2
> db.books.find({money:{$gt:40,$lte:60}}).count();
1
> db.books.count({money:{$gt:40,$lte:60}});
1
php代码如下,按顺序对应的:
代码如下:
$collection->count(); //结果:4
$collection->find()->count(); //结果:4
$collection->count(array("auther"=>"李白")); //结果:2
$collection->find(array("money"=>array('$gt'=>40,'$lte'=>60)))->count(); //结果:1
$collection->count(array("money"=>array('$gt'=>40,'$lte'=>60))); //结果:1
提示:$gt为大于、$gte为大于等于、$lt为小于、$lte为小于等于、$ne为不等于、$exists不存在、$in指定范围、$nin指定不在某范围
2、取单条数据
代码如下:
> db.books.findOne();
{
"_id" : 1,
"title" : "红楼梦",
"auther" : "曹雪芹",
"typeColumn" : "test",
"money" : 80,
"code" : 10
}
> db.books.findOne({auther: "李白" });
{
"_id" : 3,
"title" : "朝发白帝城",
"auther" : "李白",
"typeColumn" : "test",
"money" : 30,
"code" : 30
}
php代码如下,按顺序对应的
新闻热点
疑难解答