BIWEB开源PHP WMS系统创始人ArthurXF肖飞的blog

> use my_mongodb
switched to db my_mongodb
> db.user.find();
{ "_id" : ObjectId("4f81a4a1779282ca68fd8a5a"), "uid" : 2, "username" : "Jerry", "age" : 100 }
{ "_id" : ObjectId("4f844d1847d25a9ce5f120c4"), "uid" : 1, "username" : "Tom", "age" : 25 }
>

[root@localhost bin]# ./mongoexport -d my_mongodb -c user -o user.dat
connected to: 127.0.0.1
exported 2 records
[root@localhost bin]# cat user.dat
{ "_id" : { "$oid" : "4f81a4a1779282ca68fd8a5a" }, "uid" : 2, "username" : "Jerry", "age" : 100 }
{ "_id" : { "$oid" : "4f844d1847d25a9ce5f120c4" }, "uid" : 1, "username" : "Tom", "age" : 25 }
[root@localhost bin]#

[root@localhost bin]# ./mongoexport -d my_mongodb -c user --csv -f uid,username,age -o
user_csv.dat
connected to: 127.0.0.1
exported 2 records
[root@localhost bin]# cat user_csv.dat
uid,username,age
2,"Jerry",100
1,"Tom",25
[root@localhost bin]#

> db.user.drop();
true
> show collections;
system.indexes
>

[root@localhost bin]# ./mongoimport -d my_mongodb -c user user.dat
connected to: 127.0.0.1
imported 2 objects
[root@localhost bin]#

[root@localhost bin]# ./mongoimport -d my_mongodb -c user --type csv --headerline --file
user_csv.dat
connected to: 127.0.0.1
imported 3 objects
[root@localhost bin]#

> db.setProfilingLevel(2);
{ "was" : 0, "slowms" : 100, "ok" : 1 }

db.setProfilingLevel( level , slowms )
db.setProfilingLevel( 1 , 10 );

> db.system.profile.find().sort({$natural:-1}).limit(1)
{ "ts" : ISODate("2012-05-20T16:50:36.321Z"), "info" : "query test.system.profile reslen:1219
nscanned:8 \nquery: { query: {}, orderby: { $natural: -1.0 } } nreturned:8 bytes:1203", "millis" :
0 }
>

$article['saved_at'] = new MongoDate(); 
$timestamp = new MongoDate(strtotime('2011-05-21 12:00:00')); 
print date('g:i a, F j', $timestamp->sec); //prints 12 pm, May 21 

$lastweek = new MongoDate(strtotime('-1 week'));  //找出一个星期以来的记录 
$cursor = $articleCollection->find(array('saved_at' => 
array('$gt' => $lastweek))); 

$start = new MongoDate(strtotime('2011-05-01 00:00:00')); 
$end = new MongoDate(strtotime('2011-05-31 23:59:59')); 
$articleCollection->find(array('saved_at'=> 
array('$gte' => $start, 
'$lte' => $end))); 

 $cursor = $collection->find(); 
 <?php while ($cursor->hasNext()): 
 $article = $cursor->getNext(); ?> 
<h2><?php echo $article['title']; ?></h2> 

 $cursor = $articleCollection->find(); 
 //skip the first five articles in the cursor 
 $cursor->skip(5); 
 $cursor->limit(10);//结果集只取10条 

 $articles->update(array('_id' => MongoId('4dcd2abe5981')), array('$set' => array('title' => 'New Title'))); 

 $articles->update(array('_id' => MongoId('4dcd2abe5981')), array('$set' => array('content' => 'New Content'), 
 '$inc' => array('update_count' => 1))
); 
// 将update_count+1  

 $articles->update(array('_id' => MongoId('4dcd2abe5981')), array('$unset' => array('title' => True))); 
 // 将title field从这个document中移除 

$articles->update(array(), 
 array('$rename' => array('saved_at' => 'created_at')), 
 array('multiple' => True)
); 
//  将save_at更名为create_at 

$articleCollection->remove(array('_id' => new MongoId($id))); 
$movies->remove(array('genre' =>'drama'), array('justOne' => True)); 

  { 
   "_id" : ObjectId("4dd491695072aefc456c9aca"), 
   "username" : "alphareplicant", 
   "email" : "roybatty@androids.org", 
   "fullname" : "Roy Batty", 
   "joined_at" : ISODate("2011-05-19T03:41:29.703Z"), 
   "address" : { 
     "street" : "13 Tannhauser Gate", 
     "city" : "Caprica", 
     "state" : "CC", 
     "zipcode" : 512 
   }, 
} 

 { 
  _id : ObjectId("4dcd2abe5981aec801010000"), 
  title : "The only perfect site is hind-site", 
  content : "Loren ipsum dolor sit amet…", 
  saved_at : ISODate('2011-05-16T18:42:57.949Z'), 
  author_id : ObjectId("4dd491695072aefc456c9aca") 
} 

$article = $articleCollection->findOne(array('_id' => new MongoId($id))); 
$comments = (isset($article['comments'])) ? $article['comments'] : array(); 
$comment = array( 
                    'name' => $_POST['commenter_name'], 
                    'email' => $_POST['commenter_email'], 
                    'comment' => $_POST['comment'], 
                    'posted_at' => new MongoDate() 
                ); 
                
array_push($comments, $comment); 
$articleCollection->update(array('_id' => new MongoId($id)), array('$set' => array('comments' => $comments))); 

{ 
    name : "Gordon Freeman", 
  address : { 
    city : "Springfield", 
    state : "Florida" 
  } 
} 
 { 
  name : "Lara Croft", 
  address : { 
    city : "Miami", 
    state: "Florida" 
  } 
} 
// 则查询address中state为florida的document: 

 $users->find(array('address.city' => 'Springfield', 'address.state' => 'Florida'));