php mongoDB 的增/刪/改(curd)操作
$m = new Mongo("127.0.0.1");//選擇數據庫 $db = $m -> wmt;
//選擇集合 $collection = $db -> users;
$user1 = array('name' => 'hm', 'email' => 'admin@admin.com1','age'=>10);
$user2 = array('name' => 'hm', 'email' => 'admin@admin.com2','age'=>15);
$user3 = array('name' => 'hm', 'email' => 'admin@admin.com3','age'=>51);
$user4 = array('name' => 'hm', 'email' => 'admin@admin.com4','age'=>100);
$user5 = array('name' => 'hm', 'email' => 'admin@admin.com5','age'=>151);
$user6 = array('name' => 'hm', 'email' => 'admin@admin.com6','age'=>25);
$user7 = array('name' => 'hm', 'email' => 'admin@admin.com7','age'=>40);
$user8 = array('name' => 'mh', 'email' => 'admin@admin.com8','age'=>50);
$user9 = array('name' => 'mh', 'email' => 'admin@admin.com9','age'=>65);
$user10 = array('name' => 'mh', 'email' => 'admin@admin.com10','age'=>70);
$user11 = array('name' => 'mh', 'email' => 'admin@admin.com11','age'=>90);
$user12 = array('name' => 'mh', 'email' => 'admin@admin.com12','age'=>100);//插入數據 /$collection->insert($user1); $collection->insert($user2); $collection->insert($user3); $collection->insert($user4); $collection->insert($user5); $collection->insert($user6); $collection->insert($user7); $collection->insert($user8); $collection->insert($user9); $collection->insert($user10); $collection->insert($user11); $collection->insert($user12);/
//刪除 name 為hm //$collection -> remove(array('name'=>'hm'));
//刪除所有的 //$collection -> remove();
//查詢所有的記錄 //$users = $collection->find();
//查詢email為admin@admin.com12的記錄的所有字段 //$users = $collection->find(array('email' =>'admin@admin.com12' ));
//查詢email為admin@admin.com12 的name字段(注意默認會返回_id字段,其存儲數據的唯一標識) //$users = $collection->find(array('email' =>'admin@admin.com12' ),array('name'=>1));
//查詢name 和email字段(注意默認會返回_id字段) //$users = $collection -> find(array(),array('name'=>1,'email'=>1));
//查詢name為hm的記錄,并按照emai排序asc //$users = $collection -> find(array('name'=>'hm'))->sort(array('email'=>1));
//查詢name為hm的記錄,并按照emai排序desc //$users = $collection -> find(array('name'=>'hm'))->sort(array('email'=>-1));
//查詢age大于50的記錄 //$users = $collection -> find( array('age'=>array('$gt'=>50)));
//查詢age小于50的記錄 //$users = $collection -> find( array('age'=>array('$lt'=>50)));
//查詢age大于50小于70的記錄 //$users = $collection -> find( array('age'=>array('$lt'=>70,'$gt'=>50)));
//查詢name like %h% 的記錄 //$users = $collection -> find( array('name'=> new MongoRegex('/h/') ));
//查詢name like h% 的記錄 //$users = $collection -> find( array('name' => new MongoRegex('/^h/')));
//查詢name like %h的記錄 //$users = $collection -> find( array('name' => new MongoRegex('/h$/')));
//在name字段上創建索引 //$collection -> ensureIndex( array('name'=>1));
//創建聚簇索引 //$collection -> ensureIndex( array('name'=>1,'age'=>-1));
//查詢name為hm age為10的記錄 //$users = $collection -> find(array('name'=>'hm','age'=>10));
//查詢name為hm 或者age為100的記錄 //$users = $collection -> find( array('$or'=> array( array('name'=>'hm'),array('age'=>100 ) ) ));
//查詢按照age升序排序后的第6到10條記錄 //$users = $collection -> find() -> sort(array('age'=>1))->limit(5) -> skip(5);
//查詢不重復的name //$users = $db -> command( array('distinct'=>'users','key'=>'name'));
/*foreach($users as $user ) { var_dump($user);
echo '<br/>';
}/ //查詢user的記錄總數 /$count = $collection -> count(); var_dump($count);die();*/
//查詢age不為空的記錄 /$count = $collection -> find( array('age'=>array('$exists' =>true))) -> count(); var_dump($count);die();/ //查詢age大于30的記錄總數 /$count = $collection ->find(array('age'=>array('$gt'=>30)))->count(); var_dump($count);die();/
//更新email為admin@admin.com1 的name為huangman /$collection -> update(array('email'=>'admin@admin.com1'),array('$set'=>array('name'=>'huangman'))); $users = $collection -> find(array('email'=>'admin@admin.com1'));/
//更新email為admin@admin.com1 的記錄age加2 /$collection -> update(array('email' =>'admin@admin.com1'),array('$inc'=> array('age'=>2))); $users = $collection -> find(array('email'=>'admin@admin.com1'));/
/foreach ($users as $user ) { var_dump($user); }/</pre>