kimbs.cnkimbs.cn

1. Download and install http://fastdl.mongodb.org/win32/mongodb-win32-i386-1.6.5.zip unzip mongodb-win32-i386-1.6.5.zip to D:\mongodb
2. Create folder where database located [codesyntax lang="bash"]

$ mkdir D:\mongodb\data
$ mkdir D:\mongodb\data\db

[/codesyntax]
3. Start mongodb server [codesyntax lang="bash"]

$ cd D:\mongodb\bin
$ mongod.exe --dbpath=D:\mongodb\data\db --rest

[/codesyntax]
4. Web tool : http://localhost:28017/     5. Client tool for mongodb [codesyntax lang="bash"]

$ mongo.exe

[/codesyntax]
6. Create collection called mytestdb and limit the size (in fact we must use client tool) [codesyntax lang="bash"]

> db.createCollection("mytestdb", {capped:true, size:100000})
> show collections

[/codesyntax]
7. Driver for windows https://github.com/mongodb/mongo-php-driver/downloads https://github.com/downloads/mongodb/mongo-php-driver/mongo-1.1.3.zip unzip mongo-1.1.3.zip put mongo-1.1.3\mongo-1.1.3-php5.3vc6ts\php_mongo.dll to D:\xampp\php\ext\php_mongo.dll [codesyntax lang="ini"]

# modify php.ini
extension=php_mongo.dll

[/codesyntax]

---

1. Download and install [codesyntax lang="bash"]

$ curl http://downloads.mongodb.org/linux/mongodb-linux-i686-1.6.4.tgz > mongo.tgz
$ tar xzf mongo.tgz

[/codesyntax]
2. Create folder where database located [codesyntax lang="bash"]

$ sudo mkdir -p /data/mongo/db/
$ sudo chown `id -u` /data/mongo/db/

[/codesyntax]
3. Help and Launch [codesyntax lang="bash"]

$ ./mongo/bin/mongod --help
$ ./mongo/bin/mongod --dbpath=/data/mongo/db/

[/codesyntax]
4. Client tool for mongodb [codesyntax lang="bash"]

$ ./mongo/bin/mongo

[/codesyntax]

---

1. Mongo instance and database connection [codesyntax lang="php"]

// connect to database server
$mongo = new mongo("192.168.0.132:27017");
// select database to handle
$db = $mongo->selectDB("mytest");
// select collection (just like table in mysql)
$collection = $db->selectCollection("cartoons");

[/codesyntax]
2. Insert [codesyntax lang="php"]

$myinfo = array(
	'name' => 'Kim',
	'email' => 'xqpmjh@gmail.com',
	'sessions' => 0,
);
$safe_insert = true;
// $person is passed by reference
$collection->insert($person, $safe_insert);
echo $myid = $myinfo['_id'];

[/codesyntax]
3. Query [codesyntax lang="php"]

// find the person by both email and sessions exists
$filter = array(
    'email' => 'xqpmjh@gmail.com',
    'sessions' => array('$exists' => true),
);
// order by sessions desc
$cursor = $collection->find($filter)->sort(
  	array('sessions' => -1)
);
// show total docs
echo $total = $cursor->count();
// skip the first one and limit 3 docs
$cursor->limit(3)->skip(1);
foreach ($cursor as $user) {
    var_dump($user);
}

[/codesyntax]
4. Create index [codesyntax lang="php"]

$collection->ensureIndex(
    array('email' => 1),
    array('unique' => true, 'background' => true)
);

[/codesyntax]
5. Update [codesyntax lang="php"]

$filter = array('email' => 'xqpmjh@gmail.com');
$new_document = array(
    // increase sessions by one
	'$inc' => array('sessions' => 1),
    // set new name
 	'$set' => array(
   		'name' => 'kimho',
 	),
    // unset second address
 	'$unset' => array('address.1' => 1),
);
// for duplicated records
$options['multiple'] = false;
$collection->update(
	$filter,
 	$new_document,
 	$options
);

[/codesyntax]
6. Store big file (like video) [codesyntax lang="php"]

$grid = $db->getGridFS();
$metadata = array(
    "filename" => "foo.avi",
    "comment" => "wooooooo!",
    "permissions" => array(
        "kim" => "write",
        "everybody" => "read",
    )
);
$grid = $db->getGridFS();
$grid->storeFile("/data/video/avatar.avi", $metadata);

[/codesyntax]
7. Remove [codesyntax lang="php"]

// remove document which sessions equ 8
$filter = array('sessions' => 8);
$single = true;
$collection->remove($filter, $single);

[/codesyntax]

---

http://us.php.net/manual/en/book.mongo.php http://www.mongodb.org/display/DOCS/Home http://www.phpclasses.org/blog/post/118-Developing-scalable-PHP-applications-using-MongoDB.html