php mongoDB 的增/刪/改(curd)操作

webphp 12年前發布 | 2K 次閱讀 HTC

 $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>

 本文由用戶 webphp 自行上傳分享,僅供網友學習交流。所有權歸原作者,若您的權利被侵害,請聯系管理員。
 轉載本站原創文章,請注明出處,并保留原始鏈接、圖片水印。
 本站是一個以用戶分享為主的開源技術平臺,歡迎各類分享!