Installation of Mongodb and Mongo db php Driver

Step 1. Run the following command

	sudo apt-key adv --keyserver hkp://keyserver.ubuntu.com:80 --recv 7F0CEB10

	echo 'deb http://downloads-distro.mongodb.org/repo/ubuntu-upstart dist 10gen' | sudo tee /etc/apt/sources.list.d/mongodb.list

	sudo apt-get update

	apt-get install mongodb-10gen = 2.2.3

	sudo service mongodb restart

	mongo

Step 1. Install Mongodb php driver to connect mongodb from php code.

	$ sudo apt-get install php5-dev php-pear php5-mongo

	$ sudo pecl install mongo

	$ sudo echo "extension=mongo.so" >> /etc/php5/apache2/php.ini

	$ sudo service apache2 restart

now you are ready to work on mongo db.

To run the mongodb on terminal.

Write `mongo` in terminal to run mongodb

Create Database or use database.
```
  use DATABASE_NAME
```

Create Collection.

  db.createCollection("COLLECTION_NAME")

Show list of collection.
```
  show collections
```

insert document into collection.

  db.COLLECTION_NAME.insert({"KEY": "VALUE","KEY": "VALUE","KEY": "VALUE"})

update document into collection.

  db.COLLECTION_NAME.update({where Condidtion},{set data})
  db.COLLECTION_NAME.update({"key":"value"},{"KEY": "VALUE","KEY": "VALUE","KEY": "VALUE"})

delete all documents of that collection.
```
  db.COLLECTION_NAME.remove()
```

delete document with serach criterial.

  db.COLLECTION_NAME.remoove({Search Criteria})

delete document by limit 1.

  db.COLLECTION_NAME.remoove({Search Criteria},1)

Feach all document.
```
  db.COLLECTION_NAME.find()
```

Feach document with where condition.

  db.COLLECTION_NAME.find({Search Criteria})

Feach document with limit.

  db.COLLECTION_NAME.find().limit(LIMIT_NUMBER)

Display document with sort.

  db.COLLECTION_NAME.find().sort({KEY:1}) 
  1 for ascending order and -1 for descending order

Aggregate method group by with Sum.

  db.COLLECTION_NAME.aggregate([{$group: {_id : "$FIELD_NAME",num_country: {$sum:1}}}])

Get count of document.
```
  db.COLLECTION_NAME.find().count()
```

indexing.

  db.emp.ensureIndex({"key":1})
  1 => 'in accending order' or -1=> 'in decending order'

Drop location.
```
  db.COLLECTION_NAME.drop()
```
Drop Database.
```
  db.dropDatabase()
```

Steps to Connect php to mongodb after mongodb installation and perform query.

Create object of MongoClient
```
  $m = new MongoClient();
```
Create database's refrence
```
  $db = $m->my_first;
```
Create collection's refrence
```
  $collection = $db->mycol;
```

Insert Document Query

   $document = array( 
			"title" => "MongoDB", 
        "description" => "database", 
        "likes" => 100,
        "url" => "http://www.tutorialspoint.com/mongodb/",
        "by" =>"Bimal"
     );

  $collection->insert($document);

Find Documents Query
```
  $data = $collection->find();
```

Update document query

  $collection->update(array("title"=>"MongoDB"), array('$set'=>array("title"=>"MongoDB Tutorial")));

Update with Id

  $collection->update(array("_id" => new MongoId($id))

Remove document Query with limit 1

  $collection->remove(array("_id" => new MongoId($id)),array("justOne" => true));

Database Refrence

  $city_list = $collection->find();
  $country_list = $collection->getDBRef(array('$ref' =>'country','$id' => new 	MongoId($row['country_id']),'$db' => 'master'));

vikaskumarmca/mongodb-codeigniter