PHP操作MongoDB的方法

1

2

3

4

5

6

# https://github.com/mongodb/mongo-php-driver/archive/master.zip

# unzip master.zip

# /usr/local/php/bin/phpize

# ./config --with-php-config=/usr/local/php/bin/php-config

# make

# make install

1

2

# vim /usr/local/php/etc/php.ini

extension = mongo.so

1

# /usr/local/php/sbin/php-fpm -y /usr/local/php/etc/php-fpm.comf

1

2

3

4

5

<?php

$m = new MongoClient("mongodb://localhost/?journal=true&w=majority&wTimeoutMS=20000");

$m = new MongoClient("mongodb://rs1.example.com:27017,rs2.example.com:27017/?replicaSet=myReplSetName"));

$m = new MongoClient("mongodb://rs1.example.com:27017", array("replicaSet" => "myReplSetName"));

$m = new MongoClient("mongodb://rs1.example.com:27017,rs2.example.com:27017", array("replicaSet" => "myReplSetName","wTimeoutMS"=>20000));

1

$m->getHosts();

1

$m->listDBs();

1

2

3

$db = $m->db_name;

或

$db = $m->selectDB(db_name);

1

2

3

4

5

$col = $m->selectCollection(db_name, col_name);

或

$col = $m->selectDB(db_name)->selectCollection(col_name);

或

$col = $m->db_name->col_name;

1

$col_list = $db->listCollections();

1

$db_name = $db->__toString();

1

$db->drop();

1

$db->setSlaveOkay(true/false);

1

$db->getSlaveOkay();

1

2

3

4

5

<?php

$coll = $m->db_name->col_name;

$a = array(’website'=>’www.ttlsa.com');

$options = array(’safe’=>true);

$rs = $coll->insert($a,$options); $rs为数组，包含操作信息

1

2

3

4

5

<?php

$coll = $m->db_name->col_name;

$c = array(’website'=>'www.ttlsa.com',’hit’=>array(’$lt’=>100));

$options = array(’safe’=>true);

$rs = $coll->remove($c,$options); $rs为数组，包含操作信息

1

2

3

4

5

6

<?php

$coll = $m->db_name->coll_name;

$c = array(’uid'=>888,’login_count’=>array(’$lt’=>100));

$newobj = array(’vip'=>’1',’score'=>’10000');

$options = array(’safe’=>true,’multiple’=>true);

$rs = $coll->remove($c,$newobj,$options); $rs为数组，包含操作信息

1

2

3

4

5

<?php

$coll = $m->db_name->col_name;

$query = array(’score’=>array(’$lt’=>10000));

$fields = array(’uid'=>true,’vip'=>true);

$rs = $coll->findOne($query,$fields); 返回array或null

1

2

3

4

5

6

<?php

$coll = $m->db_name->col_name;

$query = array(’s’=>array(’$lt’=>100));

$query = array(’score’=>array(’$lt’=>10000));

$fields = array(’uid'=>true,’vip'=>true);

$rs = $coll->find($query,$fields); 返回游标对象MongoCursor。

1

2

$cursor = $coll->find();

$num = $cursor->count();

1

2

3

$cursor->fields(array(column_name1 => true, column_name2 => false));

或

$cursor = $coll->find()->fields(array(column_name1 => true, column_name2 => false));

1

$cursor = $coll->find()->limit(30)->skip(0);

1

$cursor = $coll->find()->sort(array(column_name1 => -1, column_name2 => 1));

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

$cursor = $coll->find($query,$fields);

while($cursor->hasNext()){

    $r = $cursor->getNext();

    var_dump($r);

}

或者

$cursor = $coll->find($query,$fields);

$r = array();

foreache($cursor as $k=>$v){

    var_dump($v);

    $r[] = $v;

}

或者

$cursor = $coll->find($query,$fields);

$array= iterator_to_array($cursor);

1

2

$cursor = $coll->find($query,$fields);

$cursor->snapshot();